WEEK1

Tables (9)

complete_mission (Untitled5)

  • user_id (Key3) — bigint — Foreign key → mission.id — NOT NULL
  • mission_id (Key) — bigint — Foreign key → user.id — NOT NULL

mission (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
  • region_id (Key22) — bigint — Foreign key → store.region_id — NOT NULL
  • mission_status (Field) — boolean
  • point (Field2) — bigint
  • mission_text (Field3) — text

new_alarm (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • is_confirmed (Field) — boolean
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)
  • title (Field4) — varchar(40)
  • body (Field5) — text

region (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • region_name (Field2) — varchar(20)

review (Untitled4)

  • id (Key3) — bigint — Primary key — NOT NULL
  • store_id (Key) — bigint — Foreign key → store.id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • photo (Field) — blob
  • review_text (Field2) — text

review_alarm (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • is_confirmed (Field) — boolean
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)
  • title (Field4) — varchar(40)
  • body (Field5) — text

store (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • region_id (Key2) — bigint — Foreign key → region.id — NOT NULL
  • store_introduce (Field) — varchar(30)
  • store_status (Field2) — boolean
  • store_address (Field3) — varchar(30)

user (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • gender (Field2) — varchar(10)
  • birth (Field3) — varchar(20)
  • address (Field4) — varchar(30)
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)
  • status (Field7) — varchar(10)
  • inactive_date (Field8) — datetime
  • point (Field9) — bigint

working_mission (Untitled6)

  • mission_id (Key2) — bigint — Foreign key → mission.store_id — NOT NULL
  • user_id (Key) — bigint — Foreign key → user.id — NOT NULL