UMC
Tables (7)
member (Untitled)
- 유저아이디 (id) — Primary key
- 유저이름 (name)
- 성별 (sex)
- 생년월일 (birth)
- 주소 (address)
- 포인트 (point)
- 활성상태 (activated)
- email (Field)
member_mission (Untitled6)
- id — Primary key — NOT NULL
- 미션id (mission_id) — Foreign key → mission.미션id
- 유저아이디 (member_id) — Foreign key → member.유저아이디
mission (Untitled2)
- 미션id (id) — Primary key
- 미션내용 (mission_detail)
- 포인트 (point)
region (Untitled4)
- 지역id (id) — Primary key
- 지역이름 (name)
review (Untitled5)
- 리뷰id (review_id) — Primary key — NOT NULL
- 가게id (store_id) — Foreign key → store.가게id
- 유저아이디 (user_id) — Foreign key → member.유저아이디
- 제목 (title)
- 내용 (detail)
store (Untitled3)
- 가게id (id) — Primary key
- 지역id (id2) — Foreign key → region.지역id
- 상호명 (name)
store_mission (Untitled7)
- Key (id) — Primary key — NOT NULL
- 가게id (store_id) — Foreign key → store.가게id
- 미션id (mission_id) — Foreign key → mission.미션id