UMC실습
테이블 (13)
alarm
- alarm_id — bigint — 기본 키 — NOT NULL
- user_ID — bigint — 외래 키 → user.user_ID — NOT NULL
- is_confirmd (is_confirmed) — boolean — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- created_at — datetime — NOT NULL
food
- food_id — bigint — 기본 키 — NOT NULL
- name — varchar(15) — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
marketing (marketing_alarm)
- alarm_id — bigint — 기본 키 — NOT NULL
- alarm_id (alarm_id2) — bigint — 외래 키 → alarm.alarm_id — NOT NULL
- title — varchar(30) — NOT NULL
- body — text — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- created_at — datetime — NOT NULL
member_agree
- ma_id — bigint — 기본 키 — NOT NULL
- user_ID — bigint — 외래 키 → user.user_ID — NOT NULL
- terms_id — bigint — 외래 키 → terms.terms_id — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- created_at — datetime — NOT NULL
mission
- mission_id — bigint — 기본 키 — NOT NULL
- store_id — bigint — 외래 키 → store.store_id — NOT NULL
- rate — float — NOT NULL
- reward — int — NOT NULL
- body — text — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- status — varchar(15) — NOT NULL
- deadline — datetime — NOT NULL
notice (notice_alarm)
- alarm_id — bigint — 기본 키 — NOT NULL
- alarm_id (alarm_id2) — bigint — 외래 키 → alarm.alarm_id — NOT NULL
- title — varchar(30) — NOT NULL
- body — text — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- created_at — datetime — NOT NULL
preference_food
- pf_id — bigint — 기본 키 — NOT NULL
- user_ID — bigint — 외래 키 → user.user_ID — NOT NULL
- food_id — bigint — 외래 키 → food.food_id — NOT NULL
- name — varchar(15) — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
region
- region_id — bigint — 기본 키 — NOT NULL
- name — varchar(20) — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
review
- reivew_id (revies_id) — bigint — 기본 키 — NOT NULL
- user_ID — biging — 외래 키 → user.user_ID — NOT NULL
- store_id — biging — 외래 키 → store.store_id — NOT NULL
- rate — float — NOT NULL
- body — text — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- inactive_date — datetime — NOT NULL
store
- store_id — bigint — 기본 키 — NOT NULL
- region_id — bigint — 외래 키 → region.region_id — NOT NULL
- name — varchar(50) — NOT NULL
- rate — float — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- inactive_date — datetime — NOT NULL
- status — varchar(15) — NOT NULL
- time — datetime — NOT NULL
- address — varchar(50) — NOT NULL
terms
- terms_id — bigint — 기본 키 — NOT NULL
- title — bigint — NOT NULL
- body — text — NOT NULL
- optional — boolean — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- created_at — datetime — NOT NULL
user
- user_ID — bigint — 기본 키 — NOT NULL
- region_id — bigint — 외래 키 → region.region_id — NOT NULL
- social_login — varchar(15) — NOT NULL
- name — varchar(20) — NOT NULL
- sex — varchar(15) — NOT NULL
- birth — varchar(15) — NOT NULL
- address — text — NOT NULL
- passward — text — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL
- status — varchar(15) — NOT NULL
- inactive_date — datetime — NOT NULL
- point — int — NOT NULL
- email — varchar(50) — NOT NULL
- phone — varchar(50)
user_mission
- user_mission_id — bigint — 기본 키 — NOT NULL
- user_ID — bigint — 외래 키 → user.user_ID — NOT NULL
- mission_id (mission_id2) — bigint — 외래 키 → mission.mission_id — NOT NULL
- status — varchar(15) — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at (upladed_at) — datetime — NOT NULL