FRAUDULENT_CERTIFICATE

93 rows


Description

This is a table for Fraudulent Certificate. Stores Fraudulent Certificates issued by the Administration Authorities of the country.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
FRAUDULENT_CERTIFICATE_ID NUMBER 18 null
FRAUDULENT_CERTIFICATE_DOC.FRAUDULENT_CERTIFICATE_ID FRAUDULENT_CERTIFICATE_DO_FK2R

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
ENUM_FRAUD_TYPE.ENUM_FRAUD_TYPE_ID FRAUDULENT_CERTIFICATE_EN_FK3R

Field Enumeration Fraud Type ID. Stores type of fraud, foreign key to table enum_fraud_type.

ENUM_METHOD_DETECTION_ID NUMBER 18 null
ENUM_METHOD_DETECTION.ENUM_METHOD_DETECTION_ID FRAUDULENT_CERTIFICATE_EN_FK2R

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
ENUM_ACTION_TAKEN.ENUM_ACTION_TAKEN_ID FRAUDULENT_CERTIFICATE_EN_FK1R

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
STCW_REFERENCE.STCW_REFERENCE_ID FRAUDULENT_CERTIFICATE_ST_FK1R

Field Stcw Reference ID. Stores foreign key to table stcw_reference in this record.

COUNTRY_ID NUMBER 18 null
COUNTRY.COUNTRY_ID FRAUDULENT_CERTIFICATE_CO_FK1R

Field Country ID. Stores the country of this fraud, foreign key to table country in this record.

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID Implied ConstraintR

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
ENUM_CERTIFICATE_TYPE.ENUM_CERTIFICATE_TYPE_ID FRAUDULENT_CERTIFICATE_EN_FK4R

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

Relationships