2

Tables (7)

favorite (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • favorite_category (Field) — Enum(Chinese, Korean ..)
  • created_at (Field2) — datetime(6)
  • deleted_at (Field3) — datetime(6)
  • is_deleted (Field4) — boolean

member (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • gender (Field5) — Enum(MALE, FEMALE)
  • age (Field7) — int
  • phone_number (Field6) — varchar(20)
  • point (Field2) — int
  • created_at (Field3) — datetime(6)
  • update_at (Field4) — datetime(6)
  • is_deleted (Field8) — boolean

member_favorite (Untitled7)

  • member_fav_id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key3) — bigint — Foreign key → member.id — NOT NULL
  • fav_id (Key2) — bigint — Foreign key → favorite.id — NOT NULL
  • created_at (Field) — datetime(6)
  • deleted_at (Field2) — datetime(6)
  • is_deleted (Field3) — boolean

member_mission (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
  • mission_id (Key22) — bigint — Foreign key → mission_list.store_id — NOT NULL
  • status (Field) — Enum(progress, complete, fail)
  • created_at (Field2) — datetime(6)
  • update_at (Field3) — datetime(6)
  • is_deleted (Field4) — boolean

mission_list (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
  • 내용 (Field) — text
  • created_at (Field2) — datetimne(6)
  • updated_at (Field3) — datetime(6)
  • point (Field4) — int
  • is_deleted (Field5) — boolean

review (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • mission_id (Key2) — bigint — Foreign key → member_mission.id — NOT NULL
  • member_id (Key22) — bigint — Foreign key → member_mission.member_id — NOT NULL
  • member_mission_id (Key222) — bigint — Foreign key → member_mission.mission_id — NOT NULL
  • memo (Field) — text
  • score (Field4) — int
  • created_at (Field2) — datetime(6)
  • update_at (Field3) — datetime(6)
  • is_deleted (Field5) — boolean

store (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • adress (Field2) — varchar(20)
  • information (Field3) — text
  • created_at (Field4) — datetime(6)
  • update_at (Field5) — datetime(6)
  • is_deleted (Field6) — boolean