first ERD answer
테이블 (11)
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (region)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Field (name)
Copy Of Copy Of Copy Of Copy Of Untitled (terms)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Field (title)
- Field (body)
- Field (optional)
Copy Of Copy Of Copy Of Copy Of Untitled2 (mission)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Key (store_id) — 외래 키 → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (reward)
- Field (deadline)
- Field (mission_spec)
Copy Of Copy Of Copy Of Untitled (food_category)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Field (name)
Copy Of Copy Of Copy Of Untitled2 (store)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Key (region_id) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
- Field (name)
- Field (address)
- Field (score)
Copy Of Copy Of Untitled (review_image)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Field (image_url)
- Key (review_id) — 외래 키 → Untitled.Key — NOT NULL
Copy Of Copy Of Untitled2 (member_mission)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Field (status)
- Key (mission_id) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
- Key (member_id) — 외래 키 → 사용자.Key — NOT NULL
Copy Of Untitled (member_agree)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Key (member_id) — 외래 키 → 사용자.Key — NOT NULL
- Key (terms_id) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
Copy Of Untitled2 (member_prefer)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Key (member_id) — 외래 키 → 사용자.Key — NOT NULL
- Key (category_id) — 외래 키 → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
Untitled (review)
- Key (id) — 기본 키 — NOT NULL
- Field (body)
- Field (score)
- Key (member_id) — 외래 키 → 사용자.Key — NOT NULL
- Key (store_id) — 외래 키 → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
사용자 (member)
- Key (id) — 기본 키 — NOT NULL
- 생성시간 (created_at)
- 수정시간 (updated_at)
- Field (name)
- Field2 (gender)
- Field3 (age)
- Field4 (address)
- Field5 (spec_address)
- Field6 (status)
- Field7 (inactive_date)
- Field8 (social_type)
- Field9 (email)
- Field10 (point)