Table slot9.WORLD.TSTA.PROPERTIES_AUDIT
This table stores audit information for MASTER PROPERTIES
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_AUDIT_ID number 38
ARREST_PROPERTIES_AUDIT.PROP_AUDIT_ID Implied Constraint R
PROPERTY_ID number 0
PROPERTIES.PROPERTY_ID Implied Constraint R
PROPERTY_TYPE_CODE varchar2 30  √  null
EVIDENCE varchar2 1  √  null
DOCUMENT varchar2 30  √  null
TYPE_OF_QUANTITY varchar2 30  √  null
PRIMARY_COLOR varchar2 30  √  null
SECONDARY_COLOR varchar2 30  √  null
DRUG_TYPE varchar2 30  √  null
QUANTITY number 20,3  √  null
DESCRIPTION varchar2 2500  √  null
MAKE varchar2 20  √  null
MODEL varchar2 25  √  null
SERIAL_NUMBER varchar2 25  √  null
VALUE number 11,2  √  null
MISC varchar2 160  √  null
DOCUMENT_NUMBER varchar2 6  √  null
BANK varchar2 40  √  null
DOCUMENT_DATE date 7  √  null
ACCOUNT_NAME varchar2 40  √  null
ACCOUNT_NUMBER number 16  √  null
PAYABLE_TO varchar2 40  √  null
AMOUNT number 12,2  √  null
ENDORSEE varchar2 40  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
BARREL_LENGTH varchar2 20  √  null
CALGAG_CODE varchar2 30  √  null
GUN_ACT_CODE varchar2 30  √  null
GUN_TYP_CODE varchar2 30  √  null
INDX_SEC_LEVEL_CODE number 0  √  null
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE Implied Constraint R
INDX_SEC_LEVEL_ID varchar2 100  √  null
INDX_SEC_LEVEL_AGENCY varchar2 30  √  null
ACTIVE_SUBSCRIPTION varchar2 1  √  null
CALGAG_CODE_TYPE varchar2 30  √  null
DRUG_TYPE_TYPE varchar2 30  √  null
GUN_ACT_CODE_TYPE varchar2 30  √  null
GUN_TYP_CODE_TYPE varchar2 30  √  null
PRIMARY_COLOR_TYPE varchar2 30  √  null
SECONDARY_COLOR_TYPE varchar2 30  √  null
TYPE_OF_QUANTITY_TYPE varchar2 30  √  null
REC_ID number 0  √  null
DOCUMENT_TYPE varchar2 30  √  null
CURRENCY_CODE varchar2 30  √  null
CURRENCY_CODE_TYPE varchar2 30  √  null
DATE_OF_INFO date 7  √  null
NUM_ROUNDS number 0  √  null
GUN_MAKE_ID number 0  √  null
GUN_MAKE_CODES.GUN_MAKE_ID Implied Constraint R
LOADED_BY varchar2 100  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PROP_AUDIT_ID" IS NOT NULL PROPAUD_AUDIT_ID_NN
"PROPERTY_ID" IS NOT NULL PROPAUD_PROP_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PROP_AUDIT_ID Primary key Asc PROPAUD_PK
PROPERTY_ID Performance Asc PROPAUD_PRO_I

Close relationships: