week1
mission
Tables (5)
Food Category (food_category)
- PK (id) — biting — Primary key — NOT NULL
- category name (category_name) — varchar(10)
Mission (mission)
- PK (id) — bigint — Primary key — NOT NULL
- 가게이름 (store_name) — varchar(20)
- 미션 포인트 (mission_point) — int
- 적립 퍼센트 (mission_percent) — float
- 진행상태 (status) — varchar(10)
- 미션 시작 날짜 (start_date) — DATE
- 미션 종료 날짜 (end_date) — DATE
Mission_User (mission_user)
- PK (id) — bigint — Primary key — NOT NULL
- FK (Key) — bigint — Primary key — NOT NULL
- FK (mission_id) — bigint — Primary key — NOT NULL
- PK (id2) — bigint — Foreign key → Mission.PK — NOT NULL
- UserId (id3) — bigint — Foreign key → User.UserId — NOT NULL
User
- UserId (id) — bigint — Primary key — NOT NULL
- 이름 (name) — varchar(10)
- 성별 (gender) — ENUM('남자', ''여자', ''선택 안 함')
- 생년원일 (birth) — DATE
- 주소 (address) — text
- 위치정보동의 (location_consent) — boolean
- 마케팅 동의 (marketing_consent) — boolean
- 생성일시 (created_at) — datetime(6)
- 수정일시 (updated_at) — datetime(6)
- status — varcher(15)
- 비활성화시기 (inactive_date) — datetime(6)
User Preference (user_preference)
- FK (user_id) — bigint — Primary key — NOT NULL
- PK (id) — biting — Primary key — NOT NULL
- FK (category_id) — bigint — Primary key — NOT NULL
- UserId (id2) — bigint — Foreign key → User.UserId — NOT NULL
- PK (id3) — biting — Foreign key → Food Category.PK — NOT NULL