market_mission
테이블 (12)
food_category
- food_id — bigint — 기본 키 — NOT NULL
- prefer_id (id2) — bigint — 외래 키 → member_prefer.prefer_id — NOT NULL
- member_id (id22) — bigint — 외래 키 → member_prefer.member_id — NOT NULL
- food_name (name) — varchar(10)
- created_at — datetime(6)
- updated_at — datetime(6)
member
- member_id (id) — bigint — 기본 키 — NOT NULL
- member_password (password) — varchar(15)
- member_name (name) — varchar(10)
- member_gender (gender) — varchar(10)
- member_birth (birth) — varchar(10)
- member_address (address) — varchar(40)
- member_email (email) — varchar(15)
- created_at — datetime(6)
- updated_at — datetime(6)
- status — varchar(15)
- inactive_date — datetime
- member_point (point) — int
member_mission
- mem_mission_id (id) — bigint — 기본 키 — NOT NULL
- mission_id (id2) — bigint — 외래 키 → mission.mission_id — NOT NULL
- member_id (id3) — bigint — 외래 키 → member.member_id — NOT NULL
- status — varchar(15)
- created_at — datetime(6)
- updated_at — datetime(6)
member_prefer
- prefer_id (id) — bigint — 기본 키 — NOT NULL
- member_id (id2) — bigint — 외래 키 → member.member_id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
mission
- mission_id (id) — bigint — 기본 키 — NOT NULL
- reward_point — int
- description — text
- expireday — varchar(10)
- created_at — datetime(6)
- updated_at — datetime(6)
new_mission
- new_id (id) — bigint — 기본 키 — NOT NULL
- alarm_id (id2) — bigint — 외래 키 → 알람.alarm_id — NOT NULL
- member_id (id22) — bigint — 외래 키 → 알람.member_id — NOT NULL
- new_title (title) — varchar(30)
- new_body (body) — text
restaurant
- restaurant_id (id) — bigint — 기본 키 — NOT NULL
- category_id (id2) — bigint — 외래 키 → restaurant_category.category_id — NOT NULL
- location — varchar(40)
- restaurant_name (name) — varchar(10)
- reward — int
- rating — float
- opening_hours — TIME
- created_at — datetime(6)
- updated_at — datetime(6)
- closing_hours — TIME
restaurant_category (resta_category)
- category_id (id) — bigint — 기본 키 — NOT NULL
- category_name (name) — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
review
- review_id (id) — bigint — 기본 키 — NOT NULL
- member_id (id2) — bigint — 외래 키 → member.member_id — NOT NULL
- restaurant_id (id3) — bigint — 외래 키 → restaurant.restaurant_id — NOT NULL
- category_id (id22) — bigint — 외래 키 → restaurant.category_id — NOT NULL
- title — varchar(30)
- content — text
- rating — float
- created_at — datetime(6)
- updated_at — datetime(6)
review_request
- review_request_id (id) — bigint — 기본 키 — NOT NULL
- alarm_id (id2) — bigint — 외래 키 → 알람.alarm_id — NOT NULL
- member_id (id22) — bigint — 외래 키 → 알람.member_id — NOT NULL
- review_re_title (title) — varchar(30)
- review_re_body (body) — text
termsOfService (terms)
- terms_id (id) — bigint — 기본 키 — NOT NULL
- member_id (id2) — bigint — 외래 키 → member.member_id — NOT NULL
- content — text
- effective_date — datetime
- enddate — datetime
- is_checked — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
알람 (alarm)
- alarm_id (id) — bigint — 기본 키 — NOT NULL
- member_id (id2) — bigint — 외래 키 → member.member_id — NOT NULL
- is_conformed — boolean
- created_at — datetime(6)
- updated_at — datetime(6)