title
테이블 (11)
Untitled (favorite_food)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(20)
- Field2 (created_at) — datetime(6)
- Field3 (updated_at) — datetime(6)
Untitled (member_favorite_food)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (created_at) — datetime(6)
- Field2 (update_at) — datetime(6)
- id (member_id) — bigint — 외래 키 → 맴버.id — NOT NULL
- Key (fav_food_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
Untitled (terms_of_service)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(20)
- Field (select) — boolean
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
Untitled (member_terms)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field2 (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Key (terms_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- id (member_id) — bigint — 외래 키 → 맴버.id — NOT NULL
Untitled (mission)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (complete) — boolean
- Field (count_of_complete) — int
- Field (name) — varchar(20)
- Key (region_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
Untitled (region)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(20)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
Untitled (member_mission)
- Key — bigint — 기본 키 — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- id (member_id) — bigint — 외래 키 → 맴버.id — NOT NULL
- Key (mission_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
Untitled (store)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(20)
- Field (rating) — float
- Field (address) — varchar(20)
- Key (region_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Key (id2) — bigint — 외래 키 → Untitled.Key — NOT NULL
Untitled (review)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (comment) — text
- Field (rating) — float
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
Untitled (member_review)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- id (id2) — bigint — 외래 키 → 맴버.id — NOT NULL
- Key (id3) — bigint — 외래 키 → Untitled.Key — NOT NULL
맴버 (Member)
- id — bigint — 기본 키 — NOT NULL
- 이름 (name) — varchar(20)
- 성별 (gender) — varchar(20)
- birth — varchar(10)
- Field2 (address) — varchar(20)
- Field (point) — bigint
- Field (created_at) — datetime(6)
- Field3 (updated_at) — datetime(6)
- Field4 (inactive_date) — datetime
- Field (status) — varchar(15)