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