STRUCTURE

235 rows


Description

This is a table for Structure. Stores Structure of Met Institutions(area, departments, persons, etc..).

Columns

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

Field Structure ID. Stores primary key for this table.

NAME VARCHAR2 1000 null

Field Name. Stores the name given to this record.

ADDRESS VARCHAR2 4000 null

Field Address. Stores the address of the structure.

PHONE VARCHAR2 50 null

Field Phone. Stores the phone of the structure.

FAX VARCHAR2 50 null

Field Fax. Stores the fax of the structure.

WEB VARCHAR2 500 null

Field Web. Stores the web of the structure.

EMAIL VARCHAR2 500 null

Field Email. Stores the email of the structure.

OBSERVATIONS VARCHAR2 4000 null

Field Observations. Stores observations of the structure.

LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID STRUCTURE_LEGAL_ENTITY_FK1R

Field Legal Entity ID. Stores the entity 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)
STRUCTURE_PK Primary key Asc STRUCTURE_ID

Relationships