MET_PROGRAMM_DOCUMENT

35 rows


Description

This is a table for Met Programms with Documents. Stores the relation between the documents and the programms.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
MET_PROGRAMM_DOCUMENT_ID NUMBER 18 null

Field Met Programm Document ID. Stores primary key for this table.

DOCUMENT_ID NUMBER 18 null
DOCUMENT.DOCUMENT_ID MET_PROGRAMM_DOCUMENT_FK2R

Field Document ID. Stores foreign key to table documents in this record.

MET_PROGRAMM_ID NUMBER 18 null
MET_PROGRAMM.MET_PROGRAMM_ID MET_PROGRAMM_DOC_FK1R

Field Met Programm ID. Stores foreign key to table met_programm.

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.

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)
MET_PROGRAMM_DOCUMENT_PK Primary key Asc MET_PROGRAMM_DOCUMENT_ID
MET_PROGRAMM_DOCUMENT_UK1 Must be unique Asc/Asc DOCUMENT_ID + MET_PROGRAMM_ID

Relationships