TRAINING_FACILITY

1932 rows


Description

This is a table for Training Facility. Stores Training Facilities of a Met Institution.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
TRAINING_FACILITY_ID NUMBER 18 null
TRAINING_FACILITY_DOCUMENT.TRAINING_FACILITY_ID TRAINING_FACILITY_DOCUMEN_FK1R

Field Training Facility ID. Stores primary key for this table.

NAME VARCHAR2 1000 null

Field Name. Stores the name given to this record.

DESCRIPTION VARCHAR2 4000 null

Field Description. Stores the description given to this record.

ENUM_FACILITY_TYPE_ID NUMBER 18 null
ENUM_FACILITY_TYPE.ENUM_FACILITY_TYPE_ID TRAINING_FACILITY_ENUM_FA_FK1R

Field Enumeration Facility Type ID. Stores the type of facility of the record, foreign key to table enum_facility_type.

LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID TRAINING_FACILITY_LEGAL_E_FK1R

Field Legal Entity ID. Stores the met instituion of this record, 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)
TRAINING_FACILITY_PK Primary key Asc TRAINING_FACILITY_ID

Relationships