coffeeShop
Tables (3)
menu (메뉴)
- id — int — Primary key — NOT NULL
- name — varchar(50)
- price — int
order (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- userId (Key2) — int — Foreign key → user.id — NOT NULL
- menuId (id) — int — Foreign key → menu.id — NOT NULL
- price (Field3) — int
- orderDate (Field4) — date
user (Untitled)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(50)
- points (Field2) — int