umc
Tables (7)
Alarm
- Key (id) — Bigint — Primary key — NOT NULL
- id (user_id) — Bigint — Foreign key → Member.id — NOT NULL
- Field (dtype) — varchar(20)
- Field (title) — varchar(30)
- Field (body) — text
Member (member)
- id — Bigint — Primary key — NOT NULL
- 이름 (userame) — Varchar(20)
- 성별 (sex) — Varchar(1)
- 생년월일 (birthday) — Date
- 주소 (region) — Varchar(20)
- 포인트 (point) — int
- Field — enum
Member_mission (member_mission)
- Key (id) — Bigint — Primary key — NOT NULL
- mission_id — bigint — Foreign key → Mission.mission_id — NOT NULL
- id (user_id) — Bigint — Foreign key → Member.id — NOT NULL
- Field (succes_state) — Varchar(20)
Mission (mission)
- mission_id (Key) — bigint — Primary key — NOT NULL
- end_Date (end_date) — Date
- price' (price) — int
- store_id — bigint — Foreign key → Store.store_id — NOT NULL
- Field (region) — Varchar(20)
- Field (point) — int
Review
- review_id (id) — bigint — Primary key — NOT NULL
- user_id — Bigint — Foreign key → Member.id — NOT NULL
- store_id — bigint — Foreign key → Store.store_id — NOT NULL
- img — IMAGE
- star — int(1)
- Field (content) — text
Store (store)
- store_id (id) — bigint — Primary key — NOT NULL
- 가게명 (name) — Varchar(20)
- 주소 (add) — Varchar(50)
- 음식종류 (type) — Varchar(20)
favorite_food
- id — bigint — Primary key — NOT NULL
- id (user_id) — Bigint — Foreign key → Member.id — NOT NULL
- 음식종류 (food_type) — Varchar(20)