UMC_8th
Tables (10)
alarm
- id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- is_confirmed — tinyint(1) — NOT NULL — 확인 유무
- created_at — datetime(6)
- updated_at — datetime(6)
food_like
- id — bigint — NOT NULL
- name — varchar(20) — NOT NULL
- selected — int — NOT NULL — 체크 유무
member
- id — bigint — NOT NULL
- password — varchar(20) — NOT NULL
- nickname — varchar(20) — NOT NULL
- gender — varchar(20) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- status — varchar(15)
- inactive_date — datetime
- address — varchar(20) — NOT NULL — 주소
- agreement — int — NOT NULL — 약관 동의 유무
member_food_like
- id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- food_like_id — bigint — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
member_mission
- id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- mission_id — bigint — NOT NULL
- status — varchar(20) — NOT NULL — 진행 상황 확인 (완료 유무 등)
- created_at — datetime(6)
- updated_at — datetime(6)
mission
- id — bigint — NOT NULL
- deadline — varchar(20) — NOT NULL — 마감 기한
- condition — varchar(20) — NOT NULL — 완료 조건
- store_id — bigint — NOT NULL
mission_alarm
- id — bigint — NOT NULL
- alarm_id — bigint — NOT NULL
- title — varchar(30)
- body — text
review_alarm
- id — bigint — NOT NULL
- alarm_id — bigint — NOT NULL
- title — varchar(30)
- body — text
store
- id — bigint — NOT NULL
- name — varchar(20) — NOT NULL
- category_id — bigint — NOT NULL
store_category
- id — bigint — NOT NULL
- name — bigint — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)