store mission

Tables (7)

Favorite (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • store_id (Field2) — bigint
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

Mission (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • store_id (Key2) — bigint — Foreign key → Store.id — NOT NULL
  • id (Key22) — bigint — Foreign key → Store.region_id — NOT NULL
  • title (Field2) — varchar(20)
  • description (Field3) — varchar(20)
  • reward (Field4) — varchar(20)
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)

Region (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

Review (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • store_id (Key3) — bigint — Foreign key → Store.id — NOT NULL
  • id (Key22) — bigint — Foreign key → Store.region_id — NOT NULL
  • rating (Field3) — bigint
  • content (Field4) — varchar(20)
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)

Store (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • region_id (Key2) — bigint — Foreign key → Region.id — NOT NULL
  • name (Field) — varchar(20)
  • address (Field3) — varchar(20)
  • created_at (Field4) — datetime(6)
  • updated_at (Field5) — datetiem(6)

User (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • nickname (Field) — varchar(20)
  • email (Field2) — varchar(20)
  • created_at (Field3) — datetime(6)
  • updated_at (Field4) — datetime(6)

User_Mission (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • mission_id (Key3) — bigint — Foreign key → Mission.id — NOT NULL
  • store_id (Key22) — bigint — Foreign key → Mission.store_id — NOT NULL
  • id (Key222) — bigint — Foreign key → Mission.id — NOT NULL
  • status (Field3) — varchar(20)
  • completed_at (Field4) — datetime(6)
  • created_at (Field5) — datetime(6)