Table slot9.WORLD.TSTA.EXPORT_TRANSACTION_LOGS
This table is used to define export formats. This table is not used at this time
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
TRANSACTION_NUMBER number 0
TRANSACTION_NAME varchar2 64
TRANSACTION_TYPE varchar2 10
FILENAME varchar2 128
ORIGINATING_AGENCY_ORI varchar2 10
DESTINATION_AGENCY_ORI varchar2 10
TRANSACTION_DATE date 7
PERSON_ID number 0  √  null
JAIL_PEOPLE.PERSON_ID Implied Constraint R
ARREST_ID number 0  √  null
ARRESTS.ARREST_ID Implied Constraint R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DESTINATION_AGENCY_ORI" IS NOT NULL EXP_TLOG_DESTINATION_AGENCY_NN
"FILENAME" IS NOT NULL EXP_TLOG_FILENAME_NN
"ORIGINATING_AGENCY_ORI" IS NOT NULL EXP_TLOG_ORIGINATING_AGENCY_NN
"TRANSACTION_DATE" IS NOT NULL EXP_TLOG_TRANSACTION_DATE_NN
"TRANSACTION_NAME" IS NOT NULL EXP_TLOG_TRANSACTION_NAME_NN
"TRANSACTION_NUMBER" IS NOT NULL EXP_TLOG_TRANSACTION_NUMBER_NN
"TRANSACTION_TYPE" IS NOT NULL EXP_TLOG_TRANSACTION_TYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
TRANSACTION_NUMBER Primary key Asc EXP_TLOG_PK

Close relationships: