sf
Tables (6)
Product Description
- id — VARCHAR(20) — Primary key — NOT NULL
- itemID — VARCHAR(20) — Foreign key → item.itemID — NOT NULL
- description — VARCHAR(1000)
- price — VARCHAR(20)
Register
- id — VARCHAR(20) — Primary key — NOT NULL
- storeID — VARCHAR(20) — Foreign key → store.storeID — NOT NULL
SalesLineItem
- id — VARCHAR(20) — Primary key — NOT NULL
- itemID — VARCHAR(20) — Foreign key → item.itemID — NOT NULL
- saleID — VARCHAR(20) — Foreign key → sale.saleID — NOT NULL
- quantity — VARCHAR(20) — NOT NULL
item
- itemID — VARCHAR(20) — Primary key — NOT NULL
- storeID — VARCHAR(20) — Foreign key → store.storeID — NOT NULL
- quantity — VARCHAR(20)
sale
- saleID — VARCHAR(20) — Primary key — NOT NULL
- id — VARCHAR(20) — Foreign key → Register.id — NOT NULL
- dateTime — VARCHAR(30)
- total — VARCHAR(20)
store
- storeID — VARCHAR(20) — Primary key — NOT NULL
- name — VARCHAR(20)
- address — VARCHAR(30)