erd 미션

테이블 (6)

member (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field2) — varchar(20)
  • phone_num (Field)
  • nickname (Field3)
  • status (Field6) — varchar
  • inactive (Field7)
  • create_at (Field4) — datetime(6)
  • update_at (Field5) — datetime(6)
  • password (Field8)
  • email (Field9) — varchar(50)

member_mission (Untitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • datetime_at (Field2) — datetimr(6)
  • update_at (Field3) — datetime(6)
  • status (Field) — varchar(50)
  • mission_id (Key2) — bigint — 외래 키 → mission.id — NOT NULL
  • member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL

member_preference (Untitled5)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • created_at (Field3) — datetime(6)
  • updated_at (Field4) — datetime(6)
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • preference_id (Key3) — bigint — 외래 키 → preference.id — NOT NULL

mission (Untitled8)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • body (Field7) — varvhar(100)
  • updated_at (Field4) — datetime(6)
  • created_at (Field3) — datetime(6)
  • region (Field) — varchar(100)

preference (Untitled7)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • type (Field) — varchar(20) — NOT NULL
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

reveiw (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • content (Field) — text
  • mission_id (Key2) — bigint — 외래 키 → mission.id — NOT NULL
  • updated_at (Field2) — datetime(6)
  • created_at (Field3) — datetime(6)
  • member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL