명식이 v2

테이블 (8)

area

  • area_id — int — 기본 키 — NOT NULL
  • name — varchar
  • created_at — datetime
  • updated_at — datetime
  • created_by — int
  • updated_by — int

meal

  • meal_id — int — 기본 키 — NOT NULL
  • meal_type — varchar
  • menu1 — varchar
  • menu2 — varchar
  • menu3 — varchar
  • menu4 — varchar
  • menu5 — varchar
  • menu6 — varchar
  • offered_at — datetime
  • status_type — varchar
  • hate — int
  • love — int
  • area_id — int
  • meal_week_id — int
  • created_at — datetime
  • updated_at — datetime
  • created_by — int
  • updated_by — int

my_code

  • my_code_id — int — 기본 키 — NOT NULL
  • code_name — varchar
  • my_code_group_id — int
  • use_flag — varchar
  • created_at — datetime
  • updated_at — datetime
  • created_by — int
  • updated_by — int
  • code_name_en — varchar

my_code_group

  • my_code_group_id — int — 기본 키 — NOT NULL
  • code_name — varchar
  • code_name_en — varchar
  • created_at — datetime
  • updated_at — datetime
  • created_by — int
  • updated_by — int

review

  • review_id — int — 기본 키 — NOT NULL
  • registered_at — varchar
  • content — varchar
  • user_id — int
  • created_at — datetime
  • updated_at — datetime
  • created_by — int
  • updated_by — int

scrap

  • scrap_id — int — 기본 키 — NOT NULL
  • store_id — varchar
  • user_id — int
  • created_at — datetime
  • updated_at — datetime
  • created_by — int
  • updated_by — int

user

  • user_id (user+id) — int — 기본 키 — NOT NULL
  • phone_id — varchar
  • created_at — datetime
  • updated_at — datetime
  • created_by — int
  • updated_by — int

week

  • week_id — int — 기본 키 — NOT NULL
  • start_date — datetime
  • end_date — datetime
  • created_at — datetime
  • updated_at — datetime
  • created_by — int
  • updated_by — int