명식이 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