UMC미션_10.11
테이블 (12)
alarm
- alarm_id (id) — bigint — 기본 키 — NOT NULL
- 회원id (id2) — bigint — 외래 키 → user.회원id — NOT NULL
- is_confiremd — boolean — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
food
- 음식id (id) — bigint — 기본 키 — NOT NULL
- 이름 (name) — varchar(15) — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
marketing (marketing_notice)
- id — bigint — 기본 키 — NOT NULL
- alarm_id (id2) — bigint — 외래 키 → alarm.alarm_id — NOT NULL
- title — varchar(30) — NOT NULL
- body — text — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
mission
- mission_id — bigint — 기본 키 — NOT NULL
- store_id — bigint — 외래 키 → store.store_id — NOT NULL
- reward — varchar(15)
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
- status — varchar(15) — NOT NULL
- deadline — datetime — NOT NULL
my_page (CopyOfUntitled2)
- my_page_id (id) — bigint — 기본 키 — NOT NULL
- 회원id (id2) — bigint(20) — 외래 키 → user.회원id — NOT NULL
- help — bigint — 외래 키 → 약관.my_page_id — NOT NULL
- piont (point) — int — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
- status — varchar(15) — NOT NULL
- inactive_date — datetime
notice (notice_alarm)
- id — bigint — 기본 키 — NOT NULL
- alarm_id (id2) — bigint — 외래 키 → alarm.alarm_id — NOT NULL
- title — varchar(30) — NOT NULL
- body — text — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
preference_food (preferce_food)
- 음식id (id) — bigint — 기본 키 — NOT NULL
- 회원id (id2) — bigint(20) — 외래 키 → user.회원id — NOT NULL
- 음식id (id3) — bigint(20) — 외래 키 → food.음식id — NOT NULL
- 이름 (name) — varchar(15) — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
review
- 회원id (id) — bigint — 기본 키 — NOT NULL
- 회원id (id2) — bigint — 외래 키 → user.회원id — NOT NULL
- store_id — bigint — 외래 키 → store.store_id — NOT NULL
- body — varchar(15)
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
- inactive_date — datetime — NOT NULL
- rate — NOT NULL
- status (stauts) — varchar(15) — NOT NULL
store
- store_id — bigint — 기본 키 — NOT NULL
- rate — int — NOT NULL
- place — varchar(30) — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
- status — varchar(15) — NOT NULL
- inactive_date — datetime — NOT NULL
- time — datetime — NOT NULL
user
- 회원id (id) — bigint — 기본 키 — NOT NULL
- social_login — varchar(15) — NOT NULL
- 이름 (name) — varchar(15) — NOT NULL
- 성별 (sex) — varchar(15) — NOT NULL
- 생년월일 (birth) — varchar(15) — NOT NULL
- 주소 (address) — varchar(15) — NOT NULL
- password — varchar(30) — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
- status — varchar(15) — NOT NULL
- inactive_date — datetime — NOT NULL
user_mission (user_miisioon)
- user_mission_id — bigint — 기본 키 — NOT NULL
- 회원id (id2) — bigint — 외래 키 → user.회원id — NOT NULL
- mission_id (mission_id2) — bigint — 외래 키 → mission.mission_id — NOT NULL
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
- status — varchar(15) — NOT NULL
약관
- my_page_id (id) — bigint — 기본 키 — NOT NULL
- body — text
- created_at — datetime — NOT NULL
- uploaded_at — datetime — NOT NULL
- inactive_date — datetime