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_STATUS_REPORT_SECTIONS

Columns

NameTypeNullableDefault valueComment
SR_SECTION_IDNUMBER(38)N  
SR_SECTION_NAMEVARCHAR2(50.0)N  
SR_FUNCTION_NAMEVARCHAR2(50.0)N  

Primary key:

Constraint NameColumns
ISRS_SR_SECTION_ID_PKSR_SECTION_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088534"SR_SECTION_NAME" IS NOT NULL
SYS_C002088535"SR_FUNCTION_NAME" IS NOT NULL

Unique Keys:

Constraint nameColumns
ISRS_SR_FUNCTION_NAME_UNSR_FUNCTION_NAME
ISRS_SR_SECTION_NAME_UNSR_SECTION_NAME

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
ISRS_SR_FUNCTION_NAME_UNNORMALUNIQUESR_FUNCTION_NAME
ISRS_SR_SECTION_ID_PKNORMALUNIQUESR_SECTION_ID
ISRS_SR_SECTION_NAME_UNNORMALUNIQUESR_SECTION_NAME

Generated by OraSchemaDoc, (c) Aram Kananov, 2002