promotion

Tables (4)

Convenience

  • ID — LONG — Primary key — NOT NULL
  • WIFI — BOOLEAN
  • Outlet — BOOLEAN
  • PET — BOOLEAN
  • Packaging/Delivery (Field) — BOOLEAN
  • Store_ID — LONG — Foreign key → Store.Store_ID — NOT NULL

Made

  • Made_ID — LONG — Primary key — NOT NULL
  • Image — FILE
  • HashTag — STRING
  • Prompt — STRING
  • User_Input — STRING
  • Result_Title — STRING
  • Result_Content — STRING
  • Store_ID — LONG — Foreign key → Store.Store_ID — NOT NULL

Promotion_Info

  • ID — LONG — Primary key — NOT NULL
  • Title — STRING
  • Image — FILE
  • Description — STRING
  • Date — DATE
  • Like — Number
  • Comment — STRING
  • Prompt — STRING
  • Store_ID — LONG — Foreign key → Store.Store_ID — NOT NULL

Store

  • Store_ID — LONG — Primary key — NOT NULL
  • Store_Name — STRING
  • Store_Image — FILE
  • Information — STRING
  • LocationL (Location) — STRING
  • Store_Time (Store_TIme) — Number
  • Closed_days — STRING
  • Reservation — boolean
  • Menu — FILE
  • Count — NUMBER