LEGAL_ENTITY

622 rows


Description

This is a table for Legal Entities. Stores Administration entities and Met Instituions of a country.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
LEGAL_ENTITY_ID NUMBER 18 null
CERTIFICATE_ENDORSEMENT.LEGAL_ENTITY_ID CERTIFICATE_ENDORSEMENT_L_FK1R
INSPECTION_LEGAL_ENTITY.LEGAL_ENTITY_ID INSPECTION_LEGAL_ENTITY_FK1R
LEGAL_ENTITY_DOCUMENT.LEGAL_ENTITY_ID LEGAL_ENTITY_DOCUMENT_LEG_FK1R
MET_PROGRAMM.LEGAL_ENTITY_ID MET_PROGRAMM_LEGAL_ENTITY_FK1R
QUALITY_SYSTEM.LEGAL_ENTITY_ID QUALITY_SYSTEM_LEGAL_ENTI_FK1R
STRUCTURE.LEGAL_ENTITY_ID STRUCTURE_LEGAL_ENTITY_FK1R
STUDENT.LEGAL_ENTITY_ID STUDENT_LEGAL_ENTITY_FK1R
TRAINING_FACILITY.LEGAL_ENTITY_ID TRAINING_FACILITY_LEGAL_E_FK1R
VIEW_BUSINESS_STU_PROGR.LEGAL_ENTITY_ID Implied ConstraintR
VIEW_BUSINESS_STUDENTS.LEGAL_ENTITY_ID Implied ConstraintR
VIEW_COUNT_MET_PROGRAMANS.LEGAL_ENTITY_ID Implied ConstraintR
VIEW_FINDING_AUX.LEGAL_ENTITY_ID Implied ConstraintR
VIEW_INSPECTION_FINDING.LEGAL_ENTITY_ID Implied ConstraintR
VIEW_MET_PROGRAMANS.LEGAL_ENTITY_ID Implied ConstraintR
VIEW_MET_STUDENTS.LEGAL_ENTITY_ID Implied ConstraintR
VIEW_STATISTICS_FINDING_AUX.LEGAL_ENTITY_ID Implied ConstraintR
VIEW_STATISTICS_MET_PROGRAMANS.LEGAL_ENTITY_ID Implied ConstraintR

Field Legal Entity 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_LEGAL_ENTITY_ID NUMBER 18 null
ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID LEGAL_ENTITY_ENUM_LEGAL_E_FK1R

Field Enumeration Legal Entity ID. Stores the type of entity of the record, foreign key to table enum_legal_entity.

COUNTRY_ID NUMBER 18 null
COUNTRY.COUNTRY_ID LEGAL_ENTITY_COUNTRY_FK1R

Field Country ID. Stores foreign key to table country in this record.

ADDRESS VARCHAR2 4000 null

Field Address. Stores the address of the entity.

PHONE VARCHAR2 50 null

Field Phone. Stores the phone of the entity.

FAX VARCHAR2 50 null

Field Fax. Stores the fax of the entity.

WEB VARCHAR2 500 null

Field Web. Stores the web address of the entity.

EMAIL VARCHAR2 500 null

Field Email. Stores the email of the entity.

MAIN_RESPONSIBILITIES VARCHAR2 4000 null

Field Main Responsibilities. Stores the responsabilities of the entity.

STRUCTURE NUMBER 1 null

Field Structure. Stores if the entity have a structure.

QUALITY_STANDARDS_SYSTEM NUMBER 1 null

Field Quality Standards System. Stores if the entity have a quality standards system.

CERTIFICATES_ENDORSEMENTS NUMBER 1 null

Field Certificates Endorsements. Stores if the entity have a certificates and endorsements.

ABBREVIATION VARCHAR2 500 null

Field Abbreviation. Stores the abbreviation of the entity.

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.

DIPLOMAS_TAB NUMBER 1 1
COC_TAB NUMBER 1 1
ENDORSEMENTS_TAB NUMBER 1 1
COPS_TAB NUMBER 1 1
OTHER_TAB NUMBER 1 1

Indexes

Constraint Name Type Sort Column(s)
ENTITY_PK Primary key Asc LEGAL_ENTITY_ID

Relationships