특화

테이블 (8)

menu

  • id — int — 기본 키 — NOT NULL
  • store — int — 외래 키 → store.id — NOT NULL
  • menu_name — char
  • price — int

place

  • id — int — 기본 키 — NOT NULL
  • region_tags — int — 외래 키 → region_tags.id — NOT NULL
  • place_name — char
  • area — char
  • tel — char
  • address — char
  • latitude — float
  • logitude — float
  • category — char

post (Untitled2)

  • id — int — 기본 키 — NOT NULL
  • user — int — 외래 키 → user.id — NOT NULL
  • title — char
  • content — char
  • create_date — timestamp
  • update_date — timestamp

region_tags (tags)

  • id — int — 기본 키 — NOT NULL
  • region_name — char

reply (Untitled3)

  • id — int — 기본 키 — NOT NULL
  • post — int — 외래 키 → post.user — NOT NULL
  • user — int — 외래 키 → user.id — NOT NULL
  • content — char
  • create_date — timestamp
  • update_date

review (Untitled)

  • id — int — 기본 키 — NOT NULL
  • user — int — 외래 키 → user.id — NOT NULL
  • store — int — 외래 키 → store.id — NOT NULL
  • place — int — 외래 키 → place.id — NOT NULL
  • score — int
  • content — char
  • reg_time — timestamp
  • review_id — int

store

  • id — int — 기본 키 — NOT NULL
  • region_tags — int — 외래 키 → region_tags.id — NOT NULL
  • store__name — char
  • branch — char
  • area — char
  • tel — char
  • address — char
  • latitude — float
  • longitude — float
  • category — char

user

  • id — int — 기본 키 — NOT NULL
  • gender — char
  • age — int
  • email — char
  • pwd — char
  • create_account — timestamp
  • update_account — timestamp
  • tag — int
  • nick_name — char