Likelion
Tables (6)
menu (Untitled)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- img_url (Field2) — varchar
- store_id (Key2) — int — Foreign key → store.id — NOT NULL
order
- id (Key) — long — Primary key — NOT NULL
- total_price (Field3) — int
- order_at (Field) — Timestamp
- ready (Field2) — bit
- total_menu (Field4) — varchar
- user_id (Key2) — varchar — Foreign key → user.id — NOT NULL
- owner_id (Key3) — int — Foreign key → owner.id — NOT NULL
- store_id (Key4) — int — Foreign key → store.id — NOT NULL
owner
- id (Key) — int — Primary key — NOT NULL
- 사업자번호 (Field) — varchar
rider (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- done (Field2) — bit
- order_id (Key2) — long — Foreign key → order.id — NOT NULL
store (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- location (Field2) — varchar
- open_time (Field3) — varchart
- tel (Field4) — varchar
- owner_id (Key2) — int — Foreign key → owner.id — NOT NULL
user
- id (Key) — varchar — Primary key — NOT NULL
- pw (Field) — varchar
- name (Field2) — varchar
- email (Field4) — varchar
- phoneNum (Field3) — varchar