Table slot9.WORLD.TSTA.STATE_DISTRICT_CODES
This table defines state district codes used for citations
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
STATE_DIST_CODE varchar2 2
BI_CITATIONS_VW.STATE_DIST_CODE Implied Constraint R
CITATION_ADDRESS_VW.STATE_DIST_CODE Implied Constraint R
CITATION_BUSINESS_VW.STATE_DIST_CODE Implied Constraint R
CITATION_EMPLOYEE_VW.STATE_DIST_CODE Implied Constraint R
CITATION_PERSON_VW.STATE_DIST_CODE Implied Constraint R
CITATION_RACIAL_PROFILE_VW.STATE_DIST_CODE Implied Constraint R
CITATION_VEHICLE_VW.STATE_DIST_CODE Implied Constraint R
CITATION_VW.STATE_DIST_CODE Implied Constraint R
CITATIONS.STATE_DIST_CODE CITATION_STDISTCD_FK R
INCIDENT_CITATION_VW.STATE_DIST_CODE Implied Constraint R
JS_CITATION_VW.STATE_DIST_CODE Implied Constraint R
DESCRIPTION varchar2 240  √  null state district desc
ACTIVE varchar2 1  √  'N'
ACTIVE_DATE date 7  √  null
DIST_STREET varchar2 25  √  null
DIST_CITY varchar2 15  √  null
DIST_STATE varchar2 2  √  null
DIST_ZIP number 38  √  null
DIST_PHONE number 38  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ACTIVE IN ('Y', 'N') CK_STDIST_ACTIVE
"STATE_DIST_CODE" IS NOT NULL STDIST_STATE_DIST_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
STATE_DIST_CODE Primary key Asc STDIST_PK

Close relationships  within of separation: