Table slot9.WORLD.TSTA.WEAPONS_TRAININGS
Legacy table. 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
WEAPON_ID number 30
SERIAL_NUMBER varchar2 25  √  null
DESCRIPTION varchar2 255  √  null
CALIBER varchar2 8  √  null
ON_DUTY varchar2 1  √  null A flag to determine if the training allows for a weapon on duty.
OFF_DUTY varchar2 1  √  null A flag to determine if the training involves carrying a weapon off duty.
PASS varchar2 1  √  null A flag if the user passed of not.
SCORE number 3  √  null
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
MODEL_CODE varchar2 2
WEAPON_MODEL_CODES.CODE WT_WMC120_FK R
The make code for a weapon.
MAKE_CODE varchar2 3
WEAPON_MAKE_CODES.CODE WT_WMC20_FK R
The code for the model of the weapon.
WEAPON_TYPE_CODE varchar2 2
WEAPON_TYPE_CODES.CODE WT_WTC120_FK R
The type of weapon code.
NOTE_ID number 0  √  null
EJS_NOTES.NOTE_ID WT_EJSN_FK R
Uniqe ID for Note
ENROLLMENT_ID number 30
ENROLLMENTS.ENROLLMENT_ID WT_ENR120_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ENROLLMENT_ID" IS NOT NULL WT_ENROLLMENT_ID_NN
"MAKE_CODE" IS NOT NULL WT_MAKE_CODE_NN
"MODEL_CODE" IS NOT NULL WT_MODEL_CODE_NN
"WEAPON_ID" IS NOT NULL WT_WEAPON_ID_NN
"WEAPON_TYPE_CODE" IS NOT NULL WT_WEAPON_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
WEAPON_ID Primary key Asc WT_PK
NOTE_ID Performance Asc WT_EJSN_FK_I
ENROLLMENT_ID Performance Asc WT_ENR120_FK_I
MODEL_CODE Performance Asc WT_WMC120_FK_I
MAKE_CODE Performance Asc WT_WMC20_FK_I
WEAPON_TYPE_CODE Performance Asc WT_WTC120_FK_I

Close relationships  within of separation: