논리적설계
테이블 (9)
Untitled
- Key — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL
- Field
- Field2
Untitled2
- Key — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL
- Field
- Field2
- Key (Key3) — 외래 키 → Untitled.Key — NOT NULL
- Key2 (Key22) — 외래 키 → Untitled.Key2 — NOT NULL
business
- bus_name — varchar(20)
- bus_man — varchar(20)
- bus_num — varchar(20)
cstomer
- name — char(20)
- password — int(10)
- number — varchar(20)
- mail — varchar(20)
- rating — varchar(20)
menu_coffee
- menu_num — INT
- coffee — VARCHAR(255)
- price — INT(10)
- manufacturer — VARCHAR(100)
- stock — INT(10)
menu_desert
- menu_num — INT
- desert — VARCHAR(255)
- price — INT(10)
- buisiness — VARCHAR(100)
- stock — INT(10)
menu_drink
- menu_num — INT
- drink — VARCHAR(255)
- price — INT(10)
- buisiness — VARCHAR(100)
- stock — INT(10)
orders
- order_id — char(20)
- name — char(20)
- amount — int
stock
- stock_no — int(10)
- coffee_total — varchar(20)
- drink_total — varchar(20)
- dessert_total — varchar(20)