Table slot9.WORLD.TSTA.SMTS
This table stores the Scars, Marks, and Tatoos for a MASTER PERSON created 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
SMT_ID number 0
PEOPLE_COMBO_ADDR_PHONES_VW.SMT_ID Implied Constraint R
PEOPLE_COMBO_ADR_PH_VW.SMT_ID Implied Constraint R
PEOPLE_COMBO_ADR_VW.SMT_ID Implied Constraint R
PEOPLE_COMBO_PH_VW.SMT_ID Implied Constraint R
PEOPLE_COMBO_VW.SMT_ID Implied Constraint R
PEOPLE_SMT_VW.SMT_ID Implied Constraint R
SMT ID number
PER_PERSON_ID number 0
PEOPLE.PERSON_ID SMT_PER_FK C
Person ID number
BDY_PRT_BODY_PART_CODE varchar2 30
EJS_CODES.CODE SMT_BDY_PRT_BODY_P_EJS_CODE_FK R
Body part/location code
SMT_CD_SMT_CODE varchar2 30
EJS_CODES.CODE SMT_SMT_CD_SMT_COD_EJS_CODE_FK R
SMT and other characteristics code
DESCRIPTION varchar2 40  √  null Description of SMT
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date record created
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
IMA_IMAGE_ID number 0  √  null
BDY_PRT_BODY_PART_CODE_TYPE varchar2 30  √  'BODY_PART_CODES'
EJS_CODES.CODE_TYPE SMT_BDY_PRT_BODY_P_EJS_CODE_FK R
SMT_CD_SMT_CODE_TYPE varchar2 30  √  'SMT_TYPE_CODES'
EJS_CODES.CODE_TYPE SMT_SMT_CD_SMT_COD_EJS_CODE_FK R
REC_ID number 0  √  null
DATE_OF_INFO date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"BDY_PRT_BODY_PART_CODE" IS NOT NULL SMT_BDY_PRT_BODY_PART_CODE_NN
"PER_PERSON_ID" IS NOT NULL SMT_PER_PERSON_ID_NN
"SMT_CD_SMT_CODE" IS NOT NULL SMT_SMT_CD_SMT_CODE_NN
"SMT_ID" IS NOT NULL SMT_SMT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
SMT_ID Primary key Asc SMT_PK
BDY_PRT_BODY_PART_CODE_TYPE + BDY_PRT_BODY_PART_CODE Performance Asc/Asc SMT_BDY_PRT_BODY_P_EJS_CODE_I
BDY_PRT_BODY_PART_CODE Performance Asc SMT_BDY_PRT_FK_I
PER_PERSON_ID Performance Asc SMT_PER_FK_I
SMT_CD_SMT_CODE Performance Asc SMT_SMT_CD_FK_I
SMT_CD_SMT_CODE_TYPE + SMT_CD_SMT_CODE Performance Asc/Asc SMT_SMT_CD_SMT_COD_EJS_CODE_I

Close relationships  within of separation: