Table slot9.WORLD.TSTA.CITATION_DELETE
This table store the citation information when the citation is deleted 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
CITATION_ID number 0 Citation ID Number
TICKET_NUMBER varchar2 20  √  null Citation Ticket Number
CITATION_TYPE_CODE varchar2 2  √  null
CITATION_TYPE_CODES.CITATION_TYPE_CODE Implied Constraint R
Citation Type Code
COUNTY_CODE varchar2 30  √  null Citation County Code
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
Citation agency
FILED_DATE date 7  √  null Citaion Filed Date
DELETE_COMMENT varchar2 4000 Comment for why this interview was deleted
LOG_ID number 38
ACCESS_LOGS.LOG_ID Implied Constraint R
ID for this delete log
CREATOR_ID varchar2 100  √  null Record Create By User ID
CREATOR_DATE date 7  √  null Date Record Created
UPDATOR_ID varchar2 100  √  null Record Last Updated By User ID
UPDATOR_DATE date 7  √  null Date Record last updated
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CITATION_ID" IS NOT NULL CIT_DELETE_CITATION_ID_NN
"DELETE_COMMENT" IS NOT NULL CIT_DELETE_COMMENT_NN
"LOG_ID" IS NOT NULL CIT_DELETE_LOG_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CITATION_ID + LOG_ID Primary key Asc/Asc CIT_DELETE_PK

Close relationships: