Table slot9.WORLD.TSTA.WARRANT_DELETE
This tables stores the WARRANT information when a WARRANT is deleted from 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
WARRANT_ID number 38 ID of the deleted Warrant.
LOG_ID number 38
ACCESS_LOGS.LOG_ID Implied Constraint R
Auto Generated Sequence ID for deleted warrants.
MN_PER_PERSON_ID number 0 Person ID number
MN_MN_ID number 0 Master Name ID number
UPDATOR_ID varchar2 100  √  null USER ID of the person updating record.
UPDATOR_DATE date 7  √  null Date the record was updated.
CREATOR_DATE date 7  √  null Date the report was deleted.
CREATOR_ID varchar2 100  √  null USER ID of the person deleting the warrant.
ID_COMMENT varchar2 4000 Indicates the reason the warrant was deleted.
DATE_ISSUED date 7  √  null Indicates the date the warrant was created.
STATE_WAR_ID varchar2 100  √  null State Warrant ID.
WSC_CODE varchar2 30 Warrant Status Code
WSC_CODE_TYPE varchar2 30  √  'WARRANT_STATUS_CODES' Warrant Status Code Type
ISSUING_AGENCY varchar2 30 Identifies the agency that issued the warrant.
WARRANT_TYPE_CODE_TYPE varchar2 30 'WARRANT_TYPES' EJS_CODE "WARRANT_TYPES"
WARRANT_TYPE varchar2 255 'WARRANT' Identifies the type of warrant
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID_COMMENT" IS NOT NULL WARDEL_ID_COMMENT_NN
"ISSUING_AGENCY" IS NOT NULL WARDEL_ISSU_AG_NN
"LOG_ID" IS NOT NULL WARDEL_LOG_ID_NN
"MN_MN_ID" IS NOT NULL WARDEL_MN_MN_ID_NN
"MN_PER_PERSON_ID" IS NOT NULL WARDEL_MN_PER_PERSON_ID_NN
"WARRANT_ID" IS NOT NULL WARDEL_WARRANT_ID_NN
"WARRANT_TYPE" IS NOT NULL WARDEL_WARTYPE_NN
"WARRANT_TYPE_CODE_TYPE" IS NOT NULL WARDEL_WARTYPECD_NN
"WSC_CODE" IS NOT NULL WARDEL_WSC_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
LOG_ID Primary key Asc WARDEL_PK
DATE_ISSUED + WSC_CODE Performance Asc/Asc WARDEL_DATEISSUE_WSCCD_I
ISSUING_AGENCY Performance Asc WARDEL_ISSUING_AGNCY_I
MN_PER_PERSON_ID Performance Asc WARDEL_MN_PER_PERSON_ID_I
MN_MN_ID + MN_PER_PERSON_ID Performance Asc/Asc WARDEL_MNPER_I
STATE_WAR_ID Performance Asc WARDEL_STATE_WAR_ID_I
WARRANT_TYPE_CODE_TYPE + WARRANT_TYPE Performance Asc/Asc WARDEL_WARTYPCD_WARTYP_I
WSC_CODE Performance Asc WARDEL_WSC_CODE_I
WSC_CODE_TYPE + WSC_CODE Performance Asc/Asc WARDEL_WSC_CODE_TYPECD_I
WARRANT_ID Must be unique Asc WARRANT_DELETE_UK

Close relationships: