Table slot9.WORLD.TSTA.PAWN_TICKETS
This table is not currently used
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
ID number 38
PAWN_PROPERTIES.PT_ID PP_PT_FK R
PAWN_TICKET_IMAGES.PT_ID PTI_PT_FK R
DS_ICR_CAT_QUERIES.ID Implied Constraint R
Unique identifier
TICKET_NUMBER varchar2 20
PAWN_PROPERTIES.PT_TICKET_NUMBER PP_PT_FK R
PAWN_TICKET_IMAGES.PT_TICKET_NUMBER PTI_PT_FK R
Ticket number of pawn ticket
OWNED_DURATION varchar2 30  √  null Duration of how long property was owned.
DATE_PAWNED date 7 Date of pawned property
MATURITY_DATE date 7  √  null Pawned property maturity date.
CREATOR_ID varchar2 100  √  null Person who created record
CREATOR_DATE date 7  √  null Date record was created
UPDATOR_ID varchar2 100  √  null Last person who updated record.
UPDATOR_DATE date 7  √  null Date record was last updated.
PER_PERSON_ID number 38
PEOPLE.PERSON_ID PT_PER_FK R
Person ID number
BUSNS_BUSINESS_NUMBER number 38
BUSINESSES.BUSINESS_NUMBER PT_BUSNS_FK R
Unique id for business
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"BUSNS_BUSINESS_NUMBER" IS NOT NULL PT_BUSNS_BUSINESS_NUMBER_NN
"DATE_PAWNED" IS NOT NULL PT_DATE_PAWNED_NN
"ID" IS NOT NULL PT_ID_NN
"PER_PERSON_ID" IS NOT NULL PT_PER_PERSON_ID_NN
"TICKET_NUMBER" IS NOT NULL PT_TICKET_NUMBER_NN

Indexes:
Column(s) Type Sort Constraint Name
ID + TICKET_NUMBER Primary key Asc/Asc PT_PK
BUSNS_BUSINESS_NUMBER Performance Asc PT_BUSNS_FK_I
PER_PERSON_ID Performance Asc PT_PER_FK_I

Close relationships  within of separation: