Make your own free website on Tripod.com
Data Dictionary
Table Name Attribute Name Contents Type Format Range Req. PK/FK FK Ref. Table
CUSTOMER CUS_ID Customer Id Number CHAR(6) Z99999   Y PK  
  CUS_FNAME Customer First Name VCHAR(20) X(20)   Y  
CUS_LNAME Customer Last Name VCHAR(25) X(20)   Y  
CUS_INITIAL Customer Middle Initial CHAR(1) X      
CUS_ADDRESS Customer Address CHAR(50) X(50)   Y  
CUS_PHONE Customer Phone Number CHAR(10) 9(10)      
SALE_ID Sale person Id CHAR(4) 9999   Y FK SALE
 
SALE SALE_ID Sale person Id CHAR(4) 9999   Y PK  
  STOCK_ID Stock Id Number CHAR(6) X(6)   Y FK STOCK
CUS_ID Customer Id Number CHAR(6) Z99999   Y FK CUSTOMER
 
EMPLOYEE EMP_ID Employee Id CHAR(4) 9999   Y PK  
  EMP_FNAME Employee First Name VCHAR(20) X(20)   Y  
EMP_LNAME Employee Last Name VCHAR(25) X(25)   Y  
EMP_INITIAL Employee Initial CHAR(1) X      
EMP_ADDRESS Employee Address CHAR(50) X(50)   Y  
EMP_PHONE Employee Phone Number CHAR(10) 9(10)      
EMP_DATE_HIRED Date Employee is hired DATE/TIME dd-mm-yyyy   Y  
EMP_STUTUS Status of Employee CHAR(20) X(20)   Y  
EMP_DWORK Employee Days Worked VCHAR(20) X(20)      
EMP_TWORK Employee Time Worked DATE/TIME Z9X99XZ9X99      
EMP_DEP Employee Department VCHAR(20) X(20)   Y  
 
STOCK STOCK_ID Stock Id Number CHAR(6) X(6)   Y PK  
  STOCK_NAME Name of Product VCHAR(25) X(25)   Y  
STOCK_CATEGORY Category of Product VCHAR(25) X(25)      
STOCK_DESC Descrption of Product VCHAR(40) X(40)   Y  
STOCK_AMT Inventory Amount CHAR(6) Z99999   Y  
UNIT_PRICE Unit Price Of Stock CURRENCY ZZ999.99      
SUPP_ID Supplier Id Number CHAR(6) Z99999   Y FK SUPPLIER
 
SUPPLIER SUPP_ID Id of the Supplier CHAR(6) Z99999   Y PK  
  SUPP_FNAME First Name of Supplier VCHAR(20) X(20)   Y  
SUPP_LNAME Last Name of Supplier VCHAR(25) X(25)   Y  
SUPP_ADDRESS Address of Supplier VCHAR(75) X(75)   Y  
SUPP_PHONE Phone Number of Supplier CHAR(10) X(10)   Y  
 
ORDER ORDER_ID Order Id Number CHAR(4) Z999   Y PK  
  ORDER_DATE   Date order was made VCHAR(25) X(25)   Y  
ORDER_TIME Time order was made DATE/TIME Z9X99   Y  
EMP_ID Employee Id number  CHAR(6) Z99999   Y FK EMPLOYEE
CUS_ID Customer Id number CHAR(6) Z99999   Y FK CUSTOMER
 
ORDERED ITEM ORDER_ID Order Id Number CHAR(4) Z999   Y FK ORDER
  STOCK_ID Stock Id CHAR(6) Z99999   Y FK STOCK
CUS_ID Customer Id CHAR(6) Z99999   Y FK CUSTOMER
QTY_ORDERED Quantity Ordered CHAR(4) Z9999   Y    
TOTAL_PRICE Toal Price of Item CURRENCY ZZ999.99   Y  
 
STOCK SUPPLIED STOCK_ID Stock Id Number CHAR(6) Z99999   Y FK STOCK
  SUPP_ID Supplier Id Number CHAR(6) Z99999   Y FK SUPPLIER
 
INVOICE INVOICE_ID Invoice Id Number CHAR(5) Z9999   Y PK  
  INVOICE_DATE Invoice Date DATE dd-mmm-yyyy   Y    
  INVLINE_ID Invoice Line Id CHAR(6) Z99999   Y FK INVOICE LINE
  CUSTOMER_ID Customer Id CHAR(6) Z99999   Y FK CUSTOMER
  EMPLOYEE_ID Employee Id CHAR(4) 9999   Y FK EMPLOYEE
 
INVOICE LINE INVLINE_ID Invoice Line Id CHAR(6) Z99999   Y PK  
  STOCK_ID Stock Id CHAR(6) Z99999   Y FK STOCK
  ORDER_ID Order Id Number CHAR(4) Z999   Y FK ORDERED ITEM
  PRICEB_VAT Price Before VAT CURRENCY ZZ999.99        
  VAT VAT Price CURRENCY ZZ999.99        
  TOTAL_PRICE Total Price of Items CURRENCY ZZ999.99   Y    
                 
                 
PROMOTION TITLE STOCK_ID Stock Id CHAR(6) Z99999   Y FK STOCK
  PRO_ID Promotions Id CHAR(6) Z99999   Y FK PROMOTION
                 
                 
PROMOTION PRO_ID Promotion Id CHAR(6) Z99999   Y PK  
  STOCK_ID Stock Id CHAR(6) Z99999   Y FK STOCK
  PRO_TYPE Promotion Type VCHAR(15) X(15)   Y    
  PRO_REL_DATE Promotion Release Date DATE dd-mmm-yyyy   Y