INSPECTION_LEGAL_ENTITY

411 rows


Description

This is a table for Inspection with Legal Entity. Stores wich Entities are inspected in a Inspection.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
INSPECTION_LEGAL_ENTITY_ID NUMBER 18 null
FINDING.INSPECTION_LEGAL_ENTITY_ID FINDING_INSP_L_ENTITY_FKR

Field Inspection Legal Entity ID. Stores primary key for this table.

INSPECTION_ID NUMBER 18 null
INSPECTION.INSPECTION_ID INSPECTION_LEGAL_ENTITY_FK2R

Field Inspection ID. Stores foreign key to table inspection.

LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID INSPECTION_LEGAL_ENTITY_FK1R

Field Legal Entity ID. Stores foreign key to table legal_entity.

VERSION_ID NUMBER 18 0

Field Version. Stores the version of the record.

CUSER VARCHAR2 75 null

Field Create User. Stores who create the record.

CDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Create Date. Stores when the record was created.

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.

Indexes

Constraint Name Type Sort Column(s)
INSPECTION_LEGAL_ENTITY_PK Primary key Asc INSPECTION_LEGAL_ENTITY_ID
INSPECTION_LEGAL_ENTITY_UK1 Must be unique Asc/Asc LEGAL_ENTITY_ID + INSPECTION_ID

Relationships