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)