|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MRDTL_OUINSTANCE | _decimal_10_0 | decimal(10) | No | MR OUInstance ID. | Yes |
| MRDTL_MREQ_NO | _varchar_40 | varchar(40) | No | The number identifying the material request. | Yes |
| MRDTL_LINE_NO | _decimal_10_0 | decimal(10) | No | The number identifying the row in the multiline in which the part is entered. | Yes |
| MRDTL_REQ_PART_CRT_OU | _decimal_10_0 | decimal(10) | Yes | Requested Part Created OUInstance. | No |
| MRDTL_REQ_PART_NO | _varchar_40 | varchar(40) | Yes | The number identifying the part for which the material request is raised. | No |
| MRDTL_REQ_QTY | _decimal_28_8 | decimal(28) | Yes | The total quantity of the part required | No |
| MRDTL_REQ_UOM | _varchar_10 | varchar(10) | Yes | The unit of measurement of the required parts | No |
| MRDTL_REQ_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Requested Part Qty in Stock Uom. | No |
| MRDTL_ALT_PART_CRT_OU | _decimal_10_0 | decimal(10) | Yes | Alternate Part Created OUInstance. | No |
| MRDTL_ALT_PART_NO | _varchar_40 | varchar(40) | Yes | The number identifying the alternate part that can be used if the part entered in the "Requested Part #" is not available. | No |
| MRDTL_PART_STATUS | _varchar_40 | varchar(40) | Yes | Part/Stock Status. | No |
| MRDTL_PREFRD_COND | _varchar_5 | varchar(5) | Yes | The preferred condition of the requested part 1. New - Indicates that the part must be new or purchased recently 2.Overhauled - Indicates that some maintenance action or servicing must be done on the part, and the part has not been used after serv | No |
| MRDTL_EXP_RETURN_DATE | _datetime_8 | datetime(8) | Yes | The expected date on which the part must be returned | No |
| MRDTL_REMARKS | _varchar_255 | varchar(255) | Yes | General comments regarding part details | No |
| MRDTL_ISSUED_QTY | _decimal_28_8 | decimal(28) | Yes | The quantity of the issued part | No |
| MRDTL_ISSUED_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Quantity that has been totally issued for the MR line item (in stock uom). | No |
| MRDTL_AUTH_QTY | _decimal_28_8 | decimal(28) | Yes | The total quantity authorized for the part | No |
| MRDTL_AUTH_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Authorised Quantity in Stock UOM | No |
| MRDTL_TLOG_TOTALC_QTYINSTKUOM | _decimal_28_8 | decimal(28) | Yes | Tech Log Allocated Quantiry in Stock UOM- Sum of Part Requsted Quantity in Stock UOM which are Allocated to many Tech Log numbers.. | No |
| MRDTL_SHORTCLOSE_FLAG | _varchar_5 | varchar(5) | Yes | This will indicate whether the lineitem is shortclosed or not. It will Y if it is short closed else it will be N . | No |
| MRDTL_CREATED_USER | _varchar_30 | varchar(30) | Yes | The name of the user who created the material request | No |
| MRDTL_CREATED_DATE | _datetime_8 | datetime(8) | Yes | The date on which the material request was created | No |
| MRDTL_MODIFIED_USER | _varchar_30 | varchar(30) | Yes | The name of the user who last modified the material request | No |
| MRDTL_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | The date on which the material request was last modified | No |
| MRDTL_TASK_OU | _decimal_10_0 | decimal(10) | Yes | Task OU Id of the Task in the WorkOrder. | No |
| MRDTL_TASK_NO | _varchar_40 | varchar(40) | Yes | Task Id for which part is estimated in the WorkOrder. | No |
| MRDTL_TASK_KEYSEQNO | _decimal_10_0 | decimal(10) | Yes | The task serial number associated with the work order for every part requested, if the reference document type is CWO. | No |
| MRDTL_LINELVL_STATUS | _varchar_40 | varchar(40) | Yes | This will indicate the line level status. It will be one of the following :- PIsu - Partially Issued ShCl - Short Closed Isu - Completely Issued NULL - Authorized and no issue or sh | No |
| MRDTL_SHCLS_QTY | _decimal_28_8 | decimal(28) | Yes | The quantity of the short closed part | No |
| MRDTL_SHCLS_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Short Closed Quantity in Stock UOM. | No |
| MRDTL_SHORTCLOSE_COMMENTS | _varchar_255 | varchar(255) | Yes | Additional comments or remarks pertaining to the material request which typically are reasons for short closing the material request. | No |
| MRDTL_ACC_USAGE | _varchar_20 | varchar(20) | Yes | The accounting usage to be used. | No |
| MRDTL_CC_USAGE | _varchar_20 | varchar(20) | Yes | The costing usage to be used | No |
| MRDTL_FIN_BOOK | _varchar_20 | varchar(20) | Yes | Finance book. | No |
| MRDTL_ACC_CODE | _varchar_32 | varchar(32) | Yes | Account Code. | No |
| MRDTL_ANLY_CODE | _varchar_5 | varchar(5) | Yes | Analysis Code. | No |
| MRDTL_SUBANLY_CODE | _varchar_5 | varchar(5) | Yes | Sub Analysis Code. | No |
| MRDTL_COSTCENTER_CODE | _varchar_20 | varchar(20) | Yes | Cost Center Code. | No |
| MRDTL_RTN_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | For Maint MR alone, pending return quantity needs to be tracked. This will have the total returned qty for the MR-Part.. | No |
| MRDTL_REQ_TYPE | _varchar_5 | varchar(5) | Yes | The requirement type of the part, which could be Normal or Specific. | No |
| MRDTL_MAT_TYPE | _varchar_5 | varchar(5) | Yes | The material type, which could be Main Core or Regular. | No |
| MRDTL_ALT_ALLOWED | _varchar_5 | varchar(5) | Yes | Displays Specific Alternates if alternate part numbers can be considered in place of the requested part number, when the Requested Part #"is not available. Displays Not Allowed if alternate part numbers cannot be considered. | No |
| MRDTL_RECEIVED_QTY | _decimal_28_8 | decimal(28) | Yes | The quantity of part received.. | No |
| MRDTL_RECEIVED_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | The unit of measurement of the received part . | No |
| MRDTL_NEWPART | udd_designparamcode | varchar(5) | Yes | Column to check whether its a New Part or Not. Value stored with Y and N | No |
| MRDTL_DISCREPANCY_NO | udd_documentno | varchar(40) | Yes | To store the DISCREPANCY_NO | No |
| MRDTL_DISCREPANCY_OU | udd_ctxt_ouinstance | int(4) | Yes | To store DISCREPANCY_OU | No |
| MRDTL_NEWPART_DESC | udd_txt150 | varchar(150) | Yes | To store New part desc | No |
| MRDTL_REQ_MODE | udd_designparamcode | varchar(5) | Yes | Use the drop-down list box to specify the mode of request. The system lists "Normal", "Conditional Requisition" and "Force Requisition". | No |
| MRDTL_EFFECTIVITY_NOTES | udd_txt2000 | varchar(2000) | Yes | The effectivity or suitability of the part to aircraft or component as defined for the part in the "Maintain Part Effectivity" page in the "Aircraft" business component | No |
| MRDTL_REQ_FOR | udd_designparamcode | varchar(5) | No | Request For | No |
| MRDTL_PMA_PRT_ALWD | udd_designparamcode | varchar(5) | Yes | PMA Part Allowed flag | No |
| MRDTL_PMA_PRT_PREFRD | udd_designparamcode | varchar(5) | Yes | PMA Part preffered | No |
| MRDTL_PMA_HOLDCODE | udd_remarks | varchar(255) | Yes | PMA Hold code | No |
| MRDTL_DEVIATED_PRT_ALWD | udd_designparamcode | varchar(5) | Yes | Deviated Part Allowed flag | No |
| MRDTL_DEVIATED_HOLDCODE | udd_remarks | varchar(255) | Yes | Deviated hold code | No |
| MRDTL_LLP_MINRMLIFE_PERCENTAGE | udd_seqno | int(4) | Yes | Minimum Remaining life Percentage | No |
| MRDTL_USG_LLP_LESS_MINRMLIFE_ALWD | udd_designparamcode | varchar(5) | Yes | Usage of less minimum remaining life allowed flag | No |
| MRDTL_RMLIFE_HOLDCODE | udd_remarks | varchar(255) | Yes | Remaining life hold code | No |
| MRDTL_USG_OWNEDPRT_ALWD | udd_designparamcode | varchar(5) | Yes | Usage of Owned Part Allowed flag | No |
| MRDTL_USG_OWNEDPRT_HOLDCODE | udd_remarks | varchar(255) | Yes | Usage of Owned Part Hold code | No |
| MRDTL_REFDOC_PART_LINK_NO | _Bigint_8 | Bigint(8) | Yes | Reference Document Part Link Number | No |
| MRDTL_TASK_TRACK_ID | bigint | Bigint(8) | Yes | Task Track ID. | No |
| MRDTL_ADL_REF_DOC_LINENO | udd_rowno | int(4) | Yes | Addiional Refrence Document Line Number | No |
| MRDTL_EXCH_HOLD_CODE | udd_remarks | varchar(255) | Yes | Exchange hold code | No |
| MRDTL_EXCH_QUOTE_HOLD_CODE | udd_remarks | varchar(255) | Yes | Exchange Quote hold code | No |
| MrDtl_Llvl_Alloc_Flag | udd_designparamcode | varchar(5) | Yes | Line Level Allocation Flag | No |
| MRDTL_SC_UNIQUEID | udd_documentno | varchar(40) | Yes | Unique Id for maintain Short close History | No | |
| Table Name : | MR_MRMN_MATRL_REQ_MAIN_HDR |
| Comment : | This table allows you to store the create a material request transaction details. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MRMN_OUINSTANCE | _decimal_10_0 | decimal(10) | No | MR OUInstance. | Yes |
| MRMN_MREQ_NO | _varchar_40 | varchar(40) | No | A unique number identifying the material request | Yes |
| MRMN_CLASS | _varchar_5 | varchar(5) | Yes | system provides the following options: 1.Maintenance - this option indicate that the MR is created for a maintenance requirement. 2.General - this option indicate that the MR is created for a general requirement | No |
| MRMN_TYPE | _varchar_5 | varchar(5) | Yes | type of the material request. If the MR Class is Maintenance or General, the system provides the following options: 1. Planned- Indicates that the material request is raised due to planned maintenance activities or execution documents, which con | No |
| MRMN_PRIORITY | _varchar_5 | varchar(5) | Yes | the priority of the material request 1. Normal - MR raised for parts that pertain to the usual requirement of an aircraft 2. AOG - MR raised for the aircraft on ground | No |
| MRMN_CATEGORY | _varchar_25 | Varchar(25) | Yes | The category to which the material request belongs This will have the list of active quick codes defined for MR category in the Quick Code activity. | No |
| MRMN_NEED_DATE | _datetime_8 | datetime(8) | Yes | The date on which the parts will be consumed or needed | No |
| MRMN_WAREHOUSE_OU | _decimal_10_0 | decimal(10) | Yes | Warehouse OUInstance ID. | No |
| MRMN_WAREHOUSE_NO | _varchar_10 | varchar(10) | Yes | The number identifying the warehouse where you are located. | No |
| MRMN_USER_STATUS | _varchar_25 | Varchar(25) | Yes | The user-defined status of the material request | No |
| MRMN_MR_STATUS | _varchar_5 | varchar(5) | Yes | MR Document Status. . List of codes and values for MR Status Draft - Drft Fresh - Frsh Authorized - Auth Cancelled - Can Partially issued - PI | No |
| MRMN_AIRCRAFT_OU | _decimal_10_0 | decimal(10) | Yes | Aircraft OUInstance ID. | No |
| MRMN_AIRCRAFT_REG_NO | _varchar_30 | varchar(30) | Yes | The registration number of the aircraft for which the parts are required | No |
| MRMN_COMPONENT_ID | _varchar_90 | varchar(90) | Yes | The number identifying the component for which the materials are required | No |
| MRMN_WORK_CENTER_OU | _decimal_10_0 | decimal(10) | Yes | WorkCenter OUInstance ID. | No |
| MRMN_WORK_CENTER | _varchar_30 | varchar(30) | Yes | The number identifying the work center where the parts are required | No |
| MRMN_STATION_CODE | _varchar_32 | varchar(32) | Yes | The number identifying the station where the parts are required | No |
| MRMN_REQUESTING_LOCN | _decimal_10_0 | decimal(10) | Yes | The organization unit from where the material request is prepared. | No |
| MRMN_SOURCE_FLAG | _varchar_5 | varchar(5) | Yes | Will be LIN or PLN | No |
| MRMN_REF_DOC_TYPE | _varchar_5 | varchar(5) | Yes | This indicates the type of the reference document.The reference document type based on which the material request is prepared List of codes and values for Ref Doc Type Component work order - CWo Line work order - LWo Tech Lo | No |
| MRMN_REF_DOC_NO | _varchar_40 | varchar(40) | Yes | The number identifying the reference document based on which the material request is prepared. | No |
| MRMN_REQUESTOR_OU | _decimal_10_0 | decimal(10) | Yes | OUInstance ID to which the Requestor belongs to.. | No |
| MRMN_REQUESTOR | _varchar_20 | varchar(20) | Yes | The number identifying the employee who made the request for the part. The employee name will be displayed alongside | No |
| MRMN_REQUESTOR_NAME | _varchar_150 | varchar(150) | Yes | The name identifying the employee who made the request for the part. The employee name will be displayed alongside. | No |
| MRMN_HARD_ALLOC_REQD | _varchar_5 | varchar(5) | Yes | Indicates whether the part need to be hard allocated. | No |
| MRMN_ISS_IN_SINGLE_LOT | _varchar_5 | varchar(5) | Yes | This indicates whether the parts can be issued in a staggered manner as and when available. | No |
| MRMN_USER_DEF_1 | _varchar_25 | Varchar(25) | Yes | Additional details pertaining to the material request | No |
| MRMN_USER_DEF_2 | _varchar_25 | Varchar(25) | Yes | Additional details pertaining to the material request. | No |
| MRMN_DELIVERY_INSTRUCTION | _varchar_255 | varchar(255) | Yes | Delivery Instructions for the MR. | No |
| MRMN_REMARKS | _varchar_255 | varchar(255) | Yes | Additional remarks pertaining to the material request, which typically are reasons for modifying the material request. | No |
| MRMN_SHORTCLOSE_COMMENTS | _varchar_255 | varchar(255) | Yes | Additional comments or remarks pertaining to the material request which typically are reasons for short closing the material request. | No |
| MRMN_PART_TYPE | _varchar_5 | varchar(5) | Yes | The type of the part. | No |
| MRMN_AUTH_BY | _varchar_30 | varchar(30) | Yes | The name of the user who approved the material request | No |
| MRMN_AUTH_DATE | _datetime_8 | datetime(8) | Yes | The date on which the material request was approved | No |
| MRMN_AUTOMR_FLAG | _varchar_5 | varchar(5) | Yes | If the MR is automatically generated by the system thru LineWo, CWo, etc AutoMR_Flag will be Yes . This needs to be maintained because system should ensure that MR created thru the respective workorder component cannot be modified in Edit MR .. | No |
| MRMN_CREATED_DATETIME | _datetime_8 | datetime(8) | Yes | The date on which the material request was created | No |
| MRMN_CREATED_USER | _varchar_30 | varchar(30) | Yes | The name of the user who created the material request | No |
| MRMN_MODIFIED_DATETIME | _datetime_8 | datetime(8) | Yes | The date on which the material request was last modified | No |
| MRMN_MODIFIED_USER | _varchar_30 | varchar(30) | Yes | The name of the user who last modified the material request | No |
| MRMN_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp of a Record. | No |
| MRMN_REF_DOC_OU | _decimal_10_0 | decimal(10) | Yes | ou of the reference doc | No |
| MRMN_FILENAME | _varchar_50 | varchar(50) | Yes | The name of the file used for document reference that is associated to the material request | No |
| MRMN_WF_NEW_STATE | _varchar_10 | varchar(10) | Yes | Currect state of Material Request in Work Flow. | No |
| MRMN_WF_DOC_KEY | _varchar_128 | varchar(128) | Yes | Work flow Document Key It will have the Material Request number concatednated with MR Created Ouinstance ID. | No |
| MRMN_ACC_USAGE | _varchar_20 | varchar(20) | Yes | The accounting usage to be used. | No |
| MRMN_CC_USAGE | _varchar_20 | varchar(20) | Yes | The costing usage to be used | No |
| MRMN_CUSTOMER_ID | udd_customer_id | varchar(18) | Yes | The code identifying the customer. | No |
| MRMN_CUSTOMER_OU | udd_ctxt_ouinstance | int(4) | Yes | OU Instance of the Customer. | No |
| MRMN_ISU_OPTION | udd_designparamcode | varchar(5) | Yes | To store the Issue option either Document level or Line Level | No |
| MRMN_MMD_PRINT_FLAG | udd_chkflag | varchar(1) | Yes | To enable selective MMD Printing . | No |
| MRMN_ADL_REF_DOC_TYPE | udd_documenttype | varchar(40) | Yes | Additional Reference document type | No |
| MRMN_ADL_REF_DOC_NO | udd_documentno | varchar(40) | Yes | Additional Reference document no | No |
| MRMN_DNR_RCPT_FLAG | udd_designparamcode | varchar(5) | Yes | Donor Receipt Flag | No |
| created_area_code | _Varchar_40 | varchar(40) | Yes | Created Area Code | No |
| MRMN_BACKFLUSH_FLAG | udd_designparamcode | varchar(5) | Yes | Back Flushing flag | No |
| MRMN_AUTH_CHK | udd_documentno | varchar(40) | Yes | Authorize Check | No |
| MRMN_FAC_OBJ_NO | udd_designparamcode | varchar(5) | Yes | Facility object number | No |
| MRMN_SOURCE | udd_flag | varchar(25) | Yes | MR source | No |
| MRMN_SRCTASK_NAME | udd_documentno | varchar(40) | Yes | Source task name | No | |
| Table Name : | MR_MRPRM_PARAMETER_DETAILS |
| Comment : | Stores Parameter detail information. In this component, this table needs to store only search criteria message |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MRPRM_COMPONENTNAME | _varchar_80 | varchar(80) | No | Component Name. | Yes |
| MRPRM_PARAMCATEGORY | _varchar_10 | varchar(10) | No | Parameter Category. | Yes |
| MRPRM_PARAMTYPE | _varchar_15 | varchar(15) | No | Paramter Type. | Yes |
| MRPRM_PARAMCODE | _varchar_5 | varchar(5) | No | Parameter Code. | Yes |
| MRPRM_PARAMDESC | _varchar_80 | varchar(80) | Yes | Parameter Description. | No |
| MRPRM_LANGID | _decimal_10_0 | decimal(10) | No | Language ID. | Yes |
| MRPRM_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date. | No |
| MRPRM_SORTBY | _decimal_10_0 | decimal(10) | Yes | Sort By. -It is sequential numbers used to load combo values in some predefined order | No | |
| Table Name : | MR_MRQC_QUICK_CODE |
| Comment : | This table allows you to store create material request quick code |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MRQC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Quickcode Created Ouinstance ID. | Yes |
| MRQC_QUICK_CODE | _varchar_25 | Varchar(25) | No | A unique identifier for the quick code | Yes |
| MRQC_TYPE | _varchar_80 | varchar(80) | No | the quick code type for which quick codes have to be defined. The system provides the options: MR Category and User Status. . | Yes |
| MRQC_DESC | _varchar_80 | varchar(80) | Yes | The textual description of the quick code | No |
| MRQC_STATUS | _varchar_15 | varchar(15) | Yes | The system provides the options:Active and Inactive. | No |
| MRQC_CREATED_BY | _varchar_30 | varchar(30) | Yes | The login ID of the user who has created the quick code. | No |
| MRQC_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | The login ID of the user that last modified the quick code. | No |
| MRQC_CREATEDDATE | _datetime_8 | datetime(8) | Yes | The date on which the quick code was created | No |
| MRQC_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | The date on which the quick code was last modified | No |
| MRQC_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp of a Record. | No | |
| Table Name : | MR_MRSL_MATREQ_SRLLOT |
| Comment : | It holds the Part Serial Lot information. If Part Requirement type is Specific for a MR, Serial - Lot information will be stored. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MRSL_OUINSTANCE | _decimal_10_0 | decimal(10) | No | MR OUInstance ID. | Yes |
| MRSL_MREQ_NO | _varchar_40 | varchar(40) | No | The number identifying the material request. | Yes |
| MRSL_LINE_NO | _decimal_10_0 | decimal(10) | No | The number identifying the row in the multiline in which the part is entered. | Yes |
| MRSL_SEQ_NO | _decimal_10_0 | decimal(10) | No | Sequence Number. | Yes |
| MRSL_REQ_PART_OU | _decimal_10_0 | decimal(10) | Yes | Request part created Ouinstance ID. | No |
| MRSL_REQ_PART_NO | _varchar_40 | varchar(40) | Yes | The number identifying the part for which the material request is raised. | No |
| MRSL_SRL_NO | _varchar_40 | varchar(40) | Yes | The preferred serial number of the part. | No |
| MRSL_LOT_NO | _varchar_18 | varchar(18) | Yes | The preferred lot number of the part. | No |
| MRSL_ZONE_ID | _varchar_10 | varchar(10) | Yes | Zone ID. | No |
| MRSL_BIN_ID | _varchar_10 | varchar(10) | Yes | Bin Id. | No |
| MRSL_REQ_UOM | _varchar_10 | varchar(10) | Yes | Requested UOM. | No |
| MRSL_REQ_QTY | _decimal_28_8 | decimal(28) | Yes | Requested Quantity in Requested UOM. | No |
| MRSL_REQ_QTYINSTKUOM | _decimal_28_8 | decimal(28) | Yes | Requested Quantity in Stock UOM. | No |
| MRSL_PART_STATUS | _varchar_40 | varchar(40) | Yes | Part Status. | No | |
| Table Name : | MR_MRTLOG_MATREQ_PRT_INFO |
| Comment : | This entity contains the List of parts of a MR document allocated to Tech logs. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MRTLOG_OUINSTANCE | _decimal_10_0 | decimal(10) | No | MR OUInstance ID. | Yes |
| MRTLOG_MREQ_NO | _varchar_40 | varchar(40) | No | Material Request Document No. | Yes |
| MRTLOG_LINE_NO | _decimal_10_0 | decimal(10) | No | Line Number. | Yes |
| MRTLOG_TECHLOG_OU | _decimal_10_0 | decimal(10) | No | Tech log Ouinstance. | Yes |
| MRTLOG_TECHLOG_NO | _varchar_40 | varchar(40) | No | Tech Log Number. | Yes |
| MRTLOG_TLOG_LINE_NO | _decimal_10_0 | decimal(10) | Yes | Tech Log Line No. | No |
| MRTLOG_REQ_PART_OU | _decimal_10_0 | decimal(10) | Yes | Requested Part Created Ouinstance. | No |
| MRTLOG_REQ_PART_NO | _varchar_40 | varchar(40) | Yes | Request Part Number. | No |
| MRTLOG_ALLOC_QTYINSTKUOM | _decimal_28_8 | decimal(28) | Yes | Part Requested Qunatity in Stock UOM. | No |
| MRTLOG_PART_STATUS | _varchar_40 | varchar(40) | Yes | Requested Part Status. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |