Table slot9.WORLD.TSTA.DEPARTMENT_EQUIPMENT
This table defines equipment used in the OFFICER DAILY LOG 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
EQUIPMENT_ID number 0
ASSIGNMENT_EQUIPMENT.EQUIPMENT_ID AE_DE_FK R
DV_EQUIPMENT.EQUIPMENT_ID DVEQ_DE_FK R
Equipment ID
DESCRIPTION varchar2 80  √  null Equipment description
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE DE_AC_FK R
Agency code
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
CREATOR_ID varchar2 100  √  null Person creating the record
REC_ID number 0  √  null
SERIAL_NUMBER varchar2 255  √  null
EQUIPMENT_TYPE varchar2 255  √  null
EJS_CODES.CODE DE_EJSCD_EQCD_FK R
References ITEM_TYPE_CODES
ACTIVE varchar2 1  √  'Y'
EQUIPMENT_TYPE_CODE_TYPE varchar2 30  √  'EQUIPMENT_TYPE_CODES'
EJS_CODES.CODE_TYPE DE_EJSCD_EQCD_FK R
OAN varchar2 100  √  null Owner applied number
PROCUREMENT_DATE date 7  √  null Purchase date
COST number 0  √  null Purchase cost
VENDOR_COMMENT varchar2 100  √  null Purchase vendor comments
VENDOR_ID number 0  √  null
ITEM_VENDORS.VENDOR_ID DE_ITVD_FK R
Purchase vendor id from ITEM_VENDORS
MAKE number 0  √  null
ITEM_MAKE_CODES.MAKE_ID DE_ITMK_FK R
References ITEM_MAKE_CODES
MODEL number 0  √  null
ITEM_MODEL_CODES.MODEL_ID DE_ITMO_FK R
References ITEM_MODEL_CODES

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EQUIPMENT_ID" IS NOT NULL DE_EQUIPMENT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
EQUIPMENT_ID Primary key Asc DE_PK
AGENCY_CODE Performance Asc DE_AC_FK_I
EQUIPMENT_TYPE_CODE_TYPE + EQUIPMENT_TYPE Performance Asc/Asc DE_EJSCD_EQCD_FK_I
MAKE Performance Asc DE_ITMK_FK_I
MODEL Performance Asc DE_ITMO_FK_I
VENDOR_ID Performance Asc DE_ITVD_FK_I

Close relationships  within of separation: