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