yummy_diary

Tables (7)

Menu (Menus)

  • id — int — Primary key — NOT NULL
  • store_id (store) — int — Foreign key → Store.id — NOT NULL
  • name (Field) — char
  • price — int

Post (Posts)

  • id — int — Primary key — NOT NULL
  • user id (user) — int — Foreign key → User.id — NOT NULL
  • meal — char — choicce
  • date — date
  • menus — char
  • party — char
  • store id (store) — int — Foreign key → Store.id — NOT NULL — store, location 둘 중 하나만
  • location — char — store, location 둘 중 하나만
  • score — float — score 는 location 등록 때만 가능하게

Review (Reviews)

  • id — int — Primary key — NOT NULL
  • user id (writer) — int — Foreign key → User.id — NOT NULL
  • store — int — Foreign key → Store.id — NOT NULL
  • score (total_score) — int
  • content — char
  • date (reg_time) — datetime

Store (Stores)

  • id — int — Primary key — NOT NULL
  • name — char
  • branch — char
  • tel — char
  • address — char
  • latitude — float
  • longtitude — float
  • bhour (bhour_list) — char

Store-Tag (Stores-Tags)

  • id — int — Primary key — NOT NULL
  • store id (store) — int — Foreign key → Store.id — NOT NULL
  • tag id (tag) — int — Foreign key → Tag.id — NOT NULL

Tag (Tags)

  • id — int — Primary key — NOT NULL
  • content — char

User (Accounts)

  • id — int — Primary key — NOT NULL
  • email — email
  • birth_year — int
  • gender — char
  • password — char