Table slot9.WORLD.TSTA.ITEM_VENDORS
This table defines the valid vendors that can be added to the inventory order information when adding inventory 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
VENDOR_ID number 0
ASSIGNMENT_VEHICLES.VENDOR_ID AV_ITVD_FK R
DEPARTMENT_EQUIPMENT.VENDOR_ID DE_ITVD_FK R
DEPARTMENT_VEHICLES.PURCHASE_FROM_VENDOR_ID DV_ITVD_FK R
DV_FUEL_OIL.VENDOR_ID DVFUEL_ITVD_FK R
DV_SERVICE_RECORDS.VENDOR_ID DVSERV_ITVD_FK R
ITEM_ORDERS.VENDOR_ID ITORD_ITVD_FK R
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ITVD_AGNCY_CD_FK R
VENDOR_NAME varchar2 255
CONTRACT_NUMBER varchar2 100  √  null
ADDRESS varchar2 255  √  null
PHONE varchar2 50  √  null
WEBSITE varchar2 100  √  null
EMAIL varchar2 100  √  null
CONTACT varchar2 100  √  null
NOTES varchar2 500  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
IS_VEH_SERVICE_LOC varchar2 1  √  'N'
IS_VEH_FUEL_LOC varchar2 1  √  'N'
IS_VEH_PURCHASE_LOC varchar2 1  √  'N'
IS_EQUIP_PURCHASE_LOC varchar2 1  √  'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"VENDOR_ID" IS NOT NULL ITVD_VENDOR_ID_NN
"VENDOR_NAME" IS NOT NULL ITVD_VENDOR_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
VENDOR_ID Primary key Asc ITVD_PK
AGENCY_CODE Performance Asc ITVD_AGNCY_CD_FK_I

Close relationships  within of separation: