mim

Tables (6)

member (Untitled)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • birthday (Field) — int
  • created_at (create_at) — datetime(6)
  • updated_at — datetime(6)
  • email (status) — varchar(50)
  • my_point (Field2) — int
  • complet_mission (Field3) — int

member_mission (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • status (Field) — varchar(10)
  • point (Field2) — int

mission (Untitled2)

  • id — bigint — Primary key — NOT NULL
  • mission_name (Field2) — varchar(20)
  • point (Field) — int
  • Field3

region (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • name (Field) — bigint
  • address (Field2) — varchar(40)

review (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (id) — bigint — Foreign key → member.id — NOT NULL
  • store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
  • starpoint (Field2) — float

store (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • region_id (id) — bigint — Foreign key → region.id — NOT NULL
  • mission_id (id2) — bigint — Foreign key → mission.id — NOT NULL
  • name (Field2) — varchar(30)
  • address (Field) — varchar(40)
  • Field3