Table slot9.WORLD.TSTA.PROPERTY_DETAIL_TYPE_CODES
This table defines the detail type codes for details added to a MASTER PROPERTY in the application
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
PROP_DTL_TYPE varchar2 6
PROPERTY_DETAILS.PROP_DTL_TYPE PD_PDTC_FK R
PROPERTY_DETAILS_VW.PROP_DTL_TYPE Implied Constraint R
PROPERTY_RMS_SEARCH_VW.PROP_DTL_TYPE Implied Constraint R
PROPERTY_SEARCH_VW.PROP_DTL_TYPE Implied Constraint R
PROP_DTL_DESC varchar2 80
ACTIVE varchar2 1 'Y'
DOCUMENT varchar2 1
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ACTIVE IN ('N', 'Y') CK_PDTC_ACTIVE
"ACTIVE" IS NOT NULL PDTC_ACTIVE_NN
"DOCUMENT" IS NOT NULL PDTC_DOCUMENT_NN
"PROP_DTL_DESC" IS NOT NULL PDTC_PROP_DTL_DESC_NN
"PROP_DTL_TYPE" IS NOT NULL PDTC_PROP_DTL_TYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
PROP_DTL_TYPE Primary key Asc PDTC_PK

Close relationships  within of separation: