convenient store
Tables (8)
branch (Untitled3)
- branch_id (Key2) — int — Primary key — NOT NULL
- branch_name (Field2) — text
- manager_id (Key) — int — Foreign key → manager.manager_id — NOT NULL
employee (Untitled8)
- employee_id (Field) — num — Primary key — NOT NULL
- employee_name (Field3) — text — NOT NULL
- employee_contact (Field2) — int
event (Untitled2)
- event_id (Key) — int — Primary key — NOT NULL
- event_name (Field) — text
- event_quantity (Field4) — int — NOT NULL
item (Untitled4)
- item_id (Key) — int — Primary key — NOT NULL
- item_name (Field) — text
- category (Field2) — text
- expiration date (Field3) — date
- stock (Field4) — int — NOT NULL
- min_stock (Field5) — int — NOT NULL
manager (Untitled9)
- manager_id (Key) — int — Primary key — NOT NULL
- manager_name (Field) — text — NOT NULL
- manager_contact (Field2) — int — NOT NULL
- location (Field3) — text — NOT NULL
sales (Untitled5)
- sales_id (Key) — int — Primary key — NOT NULL
- total_discount (Field) — int — NOT NULL
- total_price (Field2) — int — NOT NULL
- payment_method (Field3) — text — NOT NULL
- date (Field4) — date — NOT NULL
sales_detail (Untitled7)
- sales_detail_id (Key) — int — Primary key — NOT NULL
- sales_quantity (Field) — int — NOT NULL
- original price/unit (Field2) — int — NOT NULL
- discount/unit (Field3) — int
- price/unit (Field7) — int — NOT NULL
- item_id (Key2) — int — Foreign key → item.item_id — NOT NULL
- sales_id (Key4) — int — Foreign key → sales.sales_id — NOT NULL
- event_id (Key3) — int — Foreign key → event.event_id — NOT NULL
- employee_id (Field4) — num — Foreign key → employee.employee_id — NOT NULL
work (Untitled)
- Field
- employee_id (Field2) — num — Foreign key → employee.employee_id — NOT NULL
- branch_id (Key2) — int — Foreign key → branch.branch_id — NOT NULL