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