| | Physical Name | Logical Name | Description | FieldName | Data Type | Field Description | PK | Logical Name |
| 1 | INVT | Inventory | A table that stores the name of item sold by the online store | INVT_ID | numeric (7) | Unique identifier of an inventory item | Yes | Inventory ID |
| | INVT | Inventory | A table that stores the name of item sold by the online store | INVT_DESC | VARCHAR(300) | Describes the inventory item | NOT NULL | Inventory Description |
| | INVT | Inventory | A table that stores the name of item sold by the online store | SIZE | Numeric (2) | The size of an clothing item | NOT NULL | Size |
| | INVT | Inventory | A table that stores the name of item sold by the online store | INV_DATE | DATE | Date of Inventory | NOT NULL | Inventory Date |
| | INVT | Inventory | A table that stores the name of item sold by the online store | IN_STOCK | numeric (7) | Number of items in stock | NOT NULL | In stock |
| | INVT | Inventory | A table that stores the name of item sold by the online store | COST | DECIMAL(10,2) | Cost of an item | NOT NULL | Cost |
| 2 | SHP_CRT | Shopping Cart | Shopping cart item per customer | SHP_ID | numeric (7) | Unique Shopping Cart ID | PK | Shipping ID |
| | SHP_CRT | Shopping Cart | Shopping cart item per customer | INVT_ID | numeric (7) | Unique identifier of an inventory item | FK | Inventory ID |
| | SHP_CRT | Shopping Cart | Shopping cart item per customer | TRAN_ID | numeric (7) | Unique ID of a transaction | FK | Transaction ID |
| | SHP_CRT | Shopping Cart | Shopping cart item per customer | CUST_ID | numeric (7) | Unique identifier of a customer | FK | Customer ID |
| | SHP_CRT | Shopping Cart | Shopping cart item per customer | QTY | numeric (4) | The quantity of item sold | NOT NULL | Quantity |
| 3 | CUST | Customer | Customer Details | CUST_ID | numeric (7) | Unique identifier of a customer | PK | Customer ID |
| | CUST | Customer | Customer Details | FNAME | VARCHAR(100) | Customer First Name | NOT NULL | First Name |
| | CUST | Customer | Customer Details | LNAME | VARCHAR(100) | Customer Last Name | NOT NULL | Last Name |
| | CUST | Customer | Customer Details | ADDRID | numeric (7) | Unique identifier of an address id | FK |
| 4 | ADDRSS | Address | Address associated to a customer, shipping or warehouse | ADDRID | numeric (7) | Unique identifier of an address id | PK | Address ID |
| | ADDRSS | Address | Address associated to a customer, shipping or warehouse | RES_NO | VARCHAR(20) | House or Apartment Number | NOT NULL | Residence Number |
| | ADDRSS | Address | Address associated to a customer, shipping or warehouse | STREET | VARCHAR(200) | Street Address | NOT NULL | Street Address |
| | ADDRSS | Address | Address associated to a customer, shipping or warehouse | CITY | VARCHAR(100) | Name of the City | NOT NULL | City Name |
| | ADDRSS | Address | Address associated to a customer, shipping or warehouse | STATE | CHAR(2) | Name of the State | NOT NULL | State |
| | ADDRSS | Address | Address associated to a customer, shipping or warehouse | ZIP | CHAR(10) | Zip code | NOT NULL | Zip Code |
| | ADDRSS | Address | Address associated to a customer, shipping or warehouse | ADDRTYPE | CHAR(1) | Address Type: (H) - Home; (O) - Office; (C) - Customrer; (S) - Shipping; (V) - Supplier / Vendor; (W) - Warehouse; | NOT NULL | Address Type |
| 5 | TRANSCTN | Transaction | Transaction details | TRAN_ID | numeric (7) | Unique ID of a transaction | PK | Transaction ID |
| | TRANSCTN | Transaction | Transaction details | CUST_ID | numeric (7) | Unique identifier of a customer | FK | Customer ID |
| | TRANSCTN | Transaction | Transaction details | INVT_ID | numeric (7) | Unique identifier of an inventory item - provides product being purchased by a customer | PK | Inventory ID |
| | TRANSCTN | Transaction | Transaction details | ADDRID | numeric (7) | Unique identifier of an address id - this is the shipping address | FK | Address ID |
| | TRANSCTN | Transaction | Transaction details | AMT | DECIMAL(10,2) | The amount charged per item | NOT NULL | Amount |
| | TRANSCTN | Transaction | Transaction details | PRM_ID | numeric (7) | Unique identifier of a promotion, only if applicable | NULLABLE | Promotion ID |
| | TRANSCTN | Transaction | Transaction details | CARD_NUM | numeric (14) | Customer card number | NOT NULL | Card Number |
| 6 | PROMO | Promotion | Promotion or deals offered by the store towards an item / product | PRM_ID | numeric (7) | Unique identifier of a promotion | PK | Promotion ID |
| | PROMO | Promotion | Promotion or deals offered by the store towards an item / product | PRM_DESC | VARCHAR(200) | A brief description of the promotion | NOT NULL | Promotion Description |
| | PROMO | Promotion | Promotion or deals offered by the store towards an item / product | PRM_AMT | DECIMAL(5,2) | Amount to be deducted from the price of the item | NOT NULL | Promotion Amount |
| 7 | SUPLR | Supplier | Provides items to the store | SUP_ID | numeric (7) | Unique identifier of a supplier | PK | Supplier ID |
| | SUPLR | Supplier | Provides items to the store | INVT_ID | numeric (7) | Unique identifier of an inventory item - provides item from the supplier | FK | Inventory ID |
| | SUPLR | Supplier | Provides items to the store | SUP_NAME | VARCHAR(300) | Supplier Name | NOT NULL | Supplier Name |
| | SUPLR | Supplier | Provides items to the store | ADDRID | numeric (7) | Unique identifier of an address id - this is the supplier address | FK | Address ID |
| 8 | EMPLY | Employee | Employee Records | EMPID | numeric (7) | Unique identifier of An employee | PK | Supplier ID |
| | EMPLY | Employee | Employee Records | ADDRID | numeric (7) | Unique identifier of an address id - this is the employee address | FK | Address ID |
| | EMPLY | Employee | Employee Records | FNAME | VARCHAR(100) | Employee First Name | NOT NULL | First Name |
| | EMPLY | Employee | Employee Records | LNAME | VARCHAR(100) | Employee Last Name | NOT NULL | Last Name |
| | EMPLY | Employee | Employee Records | DEPT | VARCHAR(100) | Employee department | NOT NULL | Department |
| | EMPLY | Employee | Employee Records | DESGN | VARCHAR(100) | Employee Designation | NOT NULL | Designation |
| 9 | WHRHSE | Warehouse | Items or products are physically located or stored in Warehouse locations | WHR_ID | numeric (7) | Unique identifier of a Warehouse | PK | Warehouse ID |
| | WHRHSE | Warehouse | Items or products are physically located or stored in Warehouse locations | ADDRID | numeric (7) | Unique identifier of an address id - this is the Warehouse address | FK | Address ID |
| | WHRHSE | Warehouse | Items or products are physically located or stored in Warehouse locations | WHR_NM | VARCHAR(100) | Warehouse Name | NOT NULL | Name of the Warehouse |
| | WHRHSE | Warehouse | Items or products are physically located or stored in Warehouse locations | INVT_ID | numeric (7) | Unique identifier of an inventory item - provides location of an item in a Warehouse | NOT NULL | Inventory ID |
| 10 | ORDER | Order | Items or products ordered by a customer | ORDER_ID | numeric (7) | Unique identifier of an order | PK | Order ID |
| | ORDER | Order | Items or products ordered by a customer | INVT_ID | numeric (7) | Unique identifier of an inventory item - purchased by a Customer | FK | Inventory ID |
| | ORDER | Order | Items or products ordered by a customer | WHR_ID | numeric (7) | Unique identifier of a Warehouse | PK | Warehouse ID |
| | ORDER | Order | Items or products ordered by a customer | CUST_ID | numeric (7) | Unique identifier of a customer | PK | Customer ID |
| | ORDER | Order | Items or products ordered by a customer | TRAN_ID | numeric (7) | Unique ID of a transaction - to track a transaction | NOT NULL | Transaction ID |
| | ORDER | Order | Items or products ordered by a customer | ORD_DESC | VARCHAR(300) | Description of order | NOT NULL | Order Description |
| 11 | SHIPPING | SHIPNG | Shipping Details | SHPNG_ID | numeric (7) | Unique identifier of a Shipment | PK | Shipping ID |
| | SHIPPING | SHIPNG | Shipping Details | SHNG_DESC | VARCHAR(100) | High Level description of a Shipment |
| | SHIPPING | SHIPNG | Shipping Details | ORDER_ID | numeric (7) | Unique identifier of an order |
| | SHIPPING | SHIPNG | Shipping Details | ADDRID | numeric (7) | Unique identifier of an address id - this is the Shipping address | FK | Address ID |
| | SHIPPING | SHIPNG | Shipping Details | SHPNG_STATUS | CHAR(1) | Shipping Status - Y is shipment fullfilled; N - shipment is not dispacthed; T - shipment is in transit | NOT NULL | Shipping Status |
seafood1
Entity_Tables_Dictionary3670.xlsx
