| | Physical Name | Logical Name | Description | FieldName | Data Type | Field Description | PK | Logical Name |
| | 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_DESC | VARCHAR(300) | Describes the inventory item | NOT NULL | Inventory Description |
| | | | | SIZE | Numeric (2) | The size of an clothing item | NOT NULL | Size |
| | | | | INV_DATE | DATE | Date of Inventory | NOT NULL | Inventory Date |
| | | | | IN_STOCK | numeric (7) | Number of items in stock | NOT NULL | In stock |
| | | | | COST | DECIMAL(10,2) | Cost of an item | NOT NULL | Cost |
| | SHP_CRT | Shopping Cart | Shopping cart item per customer | SHP_ID | numeric (7) | Unique Shopping Cart ID | PK | Shipping ID |
| | | | | INVT_ID | numeric (7) | Unique identifier of an inventory item | FK | Inventory ID |
| | | | | TRAN_ID | numeric (7) | Unique ID of a transaction | FK | Transaction ID |
| | | | | CUST_ID | numeric (7) | Unique identifier of a customer | FK | Customer ID |
| | | | | CARD_NUM | numeric (14) | Customer card number | NOT NULL | Card Number |
| | CUST | Customer | Customer Details | QTY | numeric (4) | The quantity of item sold | NOT NULL | Quantity |
| | | | | CUST_ID | numeric (7) | Unique identifier of a customer | PK | Customer ID |
| | | | | FNAME | VARCHAR(100) | Customer First Name | NOT NULL | First Name |
| | | | | LNAME | VARCHAR(100) | Customer Last Name | NOT NULL | Last Name |
| | | | | ADDRID | numeric (7) | Unique identifier of an address id | FK |
| | ADDRSS | Address | Address associated to a customer, shipping or warehouse | ADDRID | numeric (7) | Unique identifier of an address id | PK | Address ID |
| | | | | RES_NO | VARCHAR(20) | House or Apartment Number | NOT NULL | Residence Number |
| | | | | STREET | VARCHAR(200) | Street Address | NOT NULL | Street Address |
| | | | | CITY | VARCHAR(100) | Name of the City | NOT NULL | City Name |
| | | | | STATE | CHAR(2) | State | NOT NULL | State |
| | | | | ZIP | CHAR(10) | Zip code | NOT NULL | Zip Code |
| | TRANSCTN | Transaction | Transaction details | TRAN_ID | numeric (7) | Unique ID of a transaction | PK | Transaction ID |
| | | | | CUST_ID | numeric (7) | Unique identifier of a customer | FK | Customer ID |
| | | | | INVT_ID | numeric (7) | Unique identifier of an inventory item - provides product being purchased by a customer | PK | Inventory ID |
| | | | | ADDRID | numeric (7) | Unique identifier of an address id - this is the shipping address | FK | Address ID |
| | | | | AMT | DECIMAL(10,2) | The amount charged per item | NOT NULL | Amount |
| | | | | PRM_ID | numeric (7) | Unique identifier of a promotion, only if applicable | NULLABLE | Promotion ID |
| | 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 |
| | | | | PRM_DESC | VARCHAR(100) | A brief description of the promotion | NOT NULL | Promotion Description |
| | | | | PRM_AMT | DECIMAL(5,2) | Amount to be deducted from the price of the item | NOT NULL | Promotion Amount |
| | SUPLR | Supplier | Provides items to the store | SUP_ID | numeric (7) | Unique identifier of a supplier | PK | Supplier ID |
| | | | | INVT_ID | numeric (7) | Unique identifier of an inventory item - provides item from the supplier | FK | Inventory ID |
| | | | | SUP_NAME | VARCHAR(300) | Supplier Name | NOT NULL | Supplier Name |
| | | | | ADDRID | numeric (7) | Unique identifier of an address id - this is the supplier address | FK | Address ID |
| | EMPLY | Employee | Employee Records | EMPID | numeric (7) | Unique identifier of a supplier | PK | Supplier ID |
| | | | | ADDRID | numeric (7) | Unique identifier of an address id - this is the employee address | FK | Address ID |
| | | | | FNAME | VARCHAR(100) | Customer First Name | NOT NULL | First Name |
| | | | | LNAME | VARCHAR(100) | Customer Last Name | NOT NULL | Last Name |
| | 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 |
| | | | | ADDRID | numeric (7) | Unique identifier of an address id - this is the Warehouse address | FK | Address ID |
| | | | | WHR_NM | VARCHAR(100) | Warehouse Name | NOT NULL | Name of the Warehouse |
seafood1
Entity_Tables_Dictionary.xlsx
