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)