codeit

Tables (4)

Untitled (liked)

  • user_id — NOT NULL — Foreign key → users.user_id — NOT NULL
  • Key (store_id) — NOT NULL — Foreign key → store.Key — NOT NULL

orders

  • order_id (Key) — NOT NULL — Primary key — NOT NULL
  • payment_method (payment_mothod) — NOT NULL
  • order_date — NOT NULL
  • order_status — NOT NULL
  • user_id — NOT NULL — Foreign key → users.user_id — NOT NULL
  • Key (store_id) — NOT NULL — Foreign key → store.Key — NOT NULL

store

  • Key (store_id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (address) — NOT NULL

users (USER)

  • user_id — NOT NULL — Primary key — NOT NULL
  • account_id — NOT NULL
  • password — NOT NULL
  • name — NOT NULL