Week1
Tables (19)
address (주소)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
- 시/도 (city) — varchar(10)
- 동 (town) — varchar(10)
inquiry (문의)
- Key — bigint — Primary key — NOT NULL
- Key (id) — bigint — Foreign key → member.Key — NOT NULL
- Field (title) — varchar(20)
- Field (detail) — text
member (유저)
- Key (id) — bigint — Primary key — NOT NULL
- 유저명 (name) — varchar(15)
- 닉네임 (nickname) — varchar(15)
- 성별 (gender) — varchar(15)
- 생년월일 (birth) — varchar(8)
- 생성일 (created_at) — datetime(6)
- 업뎃일 (updated_at) — datetime(6)
- 비활성화일 (deactive_at) — datetime(6)
- 유저상태 (status) — enum
- 이메일 (email) — varchar(20)
- 계정타입 (account_type) — varchar(10)
- 전화번호 (phoneNum) — varchar(13)
member_mission (유저 미션)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
- Key (mission_id) — bigint — Foreign key → mission.Key — NOT NULL
- Key (id2) — bigint — Foreign key → mission.Key — NOT NULL
- Key (region_id) — bigint — Foreign key → mission.Key — NOT NULL
- Field (status) — varchar(10)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
member_point (유저가 보유한 포인트)
- Key (point_id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
- Key (missionPoint_id) — bigint — Foreign key → mission_point.Key — NOT NULL
- Key (mission_id) — bigint — Foreign key → mission_point.Key — NOT NULL
- Key (id2) — bigint — Foreign key → mission_point.Key — NOT NULL
- Key (region_id) — bigint — Foreign key → mission_point.Key — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
member_policy (유저 정책 동의)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
- Key (policy_id) — bigint — Foreign key → policy.Key — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
member_preference (유저 선호도)
- Key (id) — bigint — Primary key — NOT NULL
- Key (preference_id) — bigint — Foreign key → preferences.Key — NOT NULL
- Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
member_setting (유저별 세팅값)
- Key — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
- Key (Key2) — bigint — Foreign key → setting.Key — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
mission (미션)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → store.Key — NOT NULL
- Key (region_id) — bigint — Foreign key → store.Key — NOT NULL
- 미션이름 (title) — varchar(20)
- 미션상세 (body) — text
- 미션보상 (reward) — varchar(20)
- 미션생성일 (created_at) — datetime(6)
- 미션업뎃일 (updated_at) — datetime(6)
mission_point (미션당 부여된 포인트)
- Key (missionPoint_id) — bigint — Primary key — NOT NULL
- Key (mission_id) — bigint — Foreign key → mission.Key — NOT NULL
- Key (id2) — bigint — Foreign key → mission.Key — NOT NULL
- Key (region_id) — bigint — Foreign key → mission.Key — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
new_mission (새로운 미션 알림)
- Key (id) — bigint — Primary key — NOT NULL
- Key (notification_id) — bigint — Foreign key → notification.Key — NOT NULL
- Key (member_id) — bigint — Foreign key → notification.Key — NOT NULL
- Field (title) — varchar(20)
- Field (body) — text
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
notification (알림)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
- Field (is_confirmed) — boolean
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
policy (정책)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(40)
- Field (details) — text
- 필수 (essential) — boolean
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
preferences (선호도)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(10)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
region (지역)
- Key — bigint — Primary key — NOT NULL
- 시/도 (state) — varchar(20)
- 시/군/구 (city) — varchar(20)
- 동/읍/면 (town) — varchar(20)
- 도로명주소 (address_road) — varchar(20)
- 위도 (latitude) — decimal
- 경도 (longitude) — decimal
- Field (created_at) — datetime(6)
- Field4 (updated_at) — datetime(6)
request_review (리뷰 요청 알림)
- Key (id) — bigint — Primary key — NOT NULL
- Key (notification_id) — bigint — Foreign key → notification.Key — NOT NULL
- Key (member_id) — bigint — Foreign key → notification.Key — NOT NULL
- Field (title) — varchar(20)
- Field (body) — text
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
review (리뷰)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
- Key (store_id) — bigint — Foreign key → store.Key — NOT NULL
- Key (region_id) — bigint — Foreign key → store.Key — NOT NULL
- Field (rate) — int
- Field (description) — text
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
setting (세팅)
- Key — bigint — Primary key — NOT NULL
- Field (name) — varchar(10)
- Field (status) — boolean
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
store (가게 관련)
- Key (store_id) — bigint — Primary key — NOT NULL
- Key (region_id) — bigint — Foreign key → region.Key — NOT NULL
- Field (name) — varchar(20)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)