맛집

테이블 (9)

Store (Untitled2)

  • sid — int — 기본 키 — NOT NULL
  • sname — varchar
  • image — varchar
  • phone — varchar
  • bhour — varchar
  • tag — varchar
  • score — double
  • category — varchar
  • menulist (menu_list) — int
  • price — int
  • sido — varchar
  • gugun — varchar
  • dong — varchar
  • bunji — varchar

User (Untitled)

  • uid — int — 기본 키 — NOT NULL
  • email — varchar
  • password — varchar
  • sex — varchar
  • age — date

card (Untitled8)

  • cardid (Key) — int — 기본 키 — NOT NULL
  • sex (Field) — varchar
  • age (Field2) — date
  • sido (Field3) — varchar
  • gugun (Field4) — varchar
  • dong (Field5) — varchar
  • category (Field6) — int
  • howmany (Field7) — int
  • Field8

cardcategory (Untitled9)

  • ccid (Key) — int — 기본 키 — NOT NULL
  • canum (Field) — int
  • category (Field2) — varchar

course (Untitled5)

  • cid — int — 기본 키 — NOT NULL
  • uid — int — 외래 키 → User.uid — NOT NULL
  • course — varchar
  • dtype — tinyint
  • people — int
  • isfinish — tinyint

enter (Untitled6)

  • eid (Key) — int — 기본 키 — NOT NULL
  • ename (Field) — varchar
  • category (Field2) — varchar
  • emenulist (Field3) — int

enterreview (Untitled7)

  • erid (Key) — int — 기본 키 — NOT NULL
  • uid — int — 외래 키 → User.uid — NOT NULL
  • eid (Key2) — int — 외래 키 → enter.eid — NOT NULL
  • score (Field) — double
  • comment (Field2) — varchar

menu_list (Untitled3)

  • mid — int — 기본 키 — NOT NULL
  • sid — int — 외래 키 → Store.sid — NOT NULL
  • menu — varchar
  • price — int

storereview (Untitled4)

  • rid — int — 기본 키 — NOT NULL
  • sid — int — 외래 키 → Store.sid — NOT NULL
  • uid — int — 외래 키 → User.uid — NOT NULL
  • score — double
  • comment — varchar