Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

IM_START_BLOCKS

Columns

NameTypeNullableDefault valueComment
START_BLOCKDATEN  
START_OF_LARGER_UNIT_PCHAR(1.0)Y'f'  
NOTEVARCHAR2(4000.0)Y  

Primary key:

Constraint NameColumns
SYS_C002088430START_BLOCK

Check Constraints:

Constraint NameCheck Condition
SYS_C002088428"START_BLOCK" IS NOT NULL
SYS_C002088429start_of_larger_unit_p in ('t','f')

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088430NORMALUNIQUESTART_BLOCK

Referenced by:

TableConstraint
IM_EMPLOYEE_PERCENTAGE_TIME SYS_C002088432
IM_PROJECT_PAYMENTS SYS_C002088441
IM_PROJECT_PAYMENTS_AUDIT SYS_C002088449
IM_ALLOCATIONS SYS_C002088460
IM_ALLOCATIONS_AUDIT SYS_C002088470


Generated by OraSchemaDoc, (c) Aram Kananov, 2002