sd
Tables (6)
allergies
- id — int — Primary key — NOT NULL
- 알러지이름 (algname) — varchar(200) — NOT NULL
ingdAlgs
- id — int — Primary key — NOT NULL
- 메뉴id (menu_id) — int — Foreign key → menu.id — NOT NULL
- 알러지id (alg_id) — int — Foreign key → allergies.id — NOT NULL
menu
- id — int — Primary key — NOT NULL
- 메뉴이름 (menu_name) — varchar(30) — NOT NULL
- 가격 (menu_price) — varchar(50) — NOT NULL
- 식당ID (rest_id) — int — Foreign key → restaurant.id — NOT NULL
restaurant
- id — int — Primary key — NOT NULL
- 식당회원id (rest_id) — varchar(30) — NOT NULL
- 식당이름 (rest_name) — varchar(30) — NOT NULL
- 주소 (address) — varchar(50) — NOT NULL
- 사장이름 (ceo_name) — varchar(30) — NOT NULL
- 번호 (tel) — varchar(30) — NOT NULL
- 대표사진 (img_url) — varchar(50)
userAlgs
- id — int — Primary key — NOT NULL
- 알러지id (algid) — int — Foreign key → allergies.id — NOT NULL
- 유저id (uid) — int — Foreign key → users.id — NOT NULL
users
- id — int — Primary key — NOT NULL
- 회원id (uid) — varchar(30) — NOT NULL
- 이름 (name) — varchar(30) — NOT NULL
- 비밀번호 (psword) — varchar(30) — NOT NULL
- 나이 (age) — varchar(30) — NOT NULL
- 성별 (gen) — varchar(30) — NOT NULL
- 국적 (country) — varchar(30) — NOT NULL
- email — varchar(30) — NOT NULL
- in_date — datetime