Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
FRAUDULENT_CERTIFICATE_ID | NUMBER | 18 | null |
|
|
Field Fraudulent Certificate ID. Stores primary key for this table. |
||||
SHIP_FLAG | NUMBER | 18 | √ | null |
|
|
Field Ship Flag. Stores flag of the ship where the fraud was detected. |
|||
ENUM_FRAUD_TYPE_ID | NUMBER | 18 | √ | null |
|
|
Field Enumeration Fraud Type ID. Stores type of fraud, foreign key to table enum_fraud_type. |
|||
ENUM_METHOD_DETECTION_ID | NUMBER | 18 | √ | null |
|
|
Field Enumeration Method Detection ID. Stores method of detection in this fraud, foreign key to table enum_method_detection. |
|||
DETECTING_ENTITY | NUMBER | 18 | √ | null |
|
|
Field Detecting Entity. Stores the country who detect the fraud. |
|||
ALLEGED_ISSUING_ENTITY | NUMBER | 18 | √ | null |
|
|
Field Alleged Issuing Entity. Stores the country alleged issuing entity. |
|||
ENUM_ACTION_TAKEN_ID | NUMBER | 18 | √ | null |
|
|
Field Enumeration Action Taken ID. Stores type of action taken in this fraud, foreign key to table enum_action_taken. |
|||
OBSERVATION | VARCHAR2 | 4000 | √ | null |
|
|
Field Observation. Stores observation of the fraud detected. |
|||
FRAUDULENT_CERTIFICATE_DATE | DATE | 7 | √ | null |
|
|
Field Fraudulent Certificate Date. Stores when the fraud was detected. |
|||
STCW_REFERENCE_ID | NUMBER | 18 | √ | null |
|
|
Field Stcw Reference ID. Stores foreign key to table stcw_reference in this record. |
|||
COUNTRY_ID | NUMBER | 18 | null |
|
|
Field Country ID. Stores the country of this fraud, foreign key to table country in this record. |
||||
ENUM_STATUS_ID | NUMBER | 18 | null |
|
|
Field Status. Stores the status of the record, foreign key to table enum_status. |
||||
VERSION_ID | NUMBER | 18 | 0 |
|
|
Field Version. Stores the version of the record. |
||||
CDATE | TIMESTAMP(6) | 11,6 | SYSTIMESTAMP |
|
|
Field Create Date. Stores when the record was created. |
||||
CUSER | VARCHAR2 | 75 | null |
|
|
Field Create User. Stores who create the record. |
||||
MUSER | VARCHAR2 | 75 | null |
|
|
Field Modified User. Stores who modified the record. |
||||
MDATE | TIMESTAMP(6) | 11,6 | SYSTIMESTAMP |
|
|
Field Modified Date. Stores when the record was modified. |
||||
ENUM_CERTIFICATE_TYPE_ID | NUMBER | 18 | √ | null |
|
|
Field Enumeration Certificate Type ID. Stores type of certificate in this fraud, foreign key to table enum_certificate_type of this record. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
FRAUDULENT_CERTIFICATE_PK | Primary key | Asc | FRAUDULENT_CERTIFICATE_ID |
F_CERT_COUNTRY_ID_IDX | Performance | Asc | COUNTRY_ID |
F_CERT_FRAUD_TYPE_ID_IDX | Performance | Asc | ENUM_FRAUD_TYPE_ID |
F_CERT_METHOD_ID_IDX | Performance | Asc | ENUM_METHOD_DETECTION_ID |
F_CERT_STATUS_ID_IDX | Performance | Asc | ENUM_STATUS_ID |
F_CERT_TAKEN_ID_IDX | Performance | Asc | ENUM_ACTION_TAKEN_ID |