mission1

Tables (5)

mission (Untitled3)

  • id — INT — Primary key — NOT NULL
  • store_id (2) — INT — Foreign key → store.id — NOT NULL
  • title (Field2) — VARCHAR(100)
  • description (Field3) — TEXT

review (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (2) — INT — Foreign key → user.id — NOT NULL
  • store_id (3) — INT — Foreign key → mission.id — NOT NULL
  • mission_id (4) — INT — Foreign key → store.id — NOT NULL
  • rating (Field4) — INT
  • content (Field5) — TEXT
  • created_at (Field6) — DATETIME

store (Untitled2)

  • id — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • address (Field2) — VARCHAR(255)

user

  • id — INT — Primary key — NOT NULL
  • email (Field2) — VARCHAR(100)
  • passward (Field3) — VARCHAR(100)
  • nickname (Field) — VARCHAR(50)
  • created_at (Field4) — DATETIME

user_mission (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (2) — INT — Foreign key → user.id — NOT NULL
  • mission_id (3) — INT — Foreign key → mission.id — NOT NULL
  • status (Field3) — VARCHAR(20)
  • created_at (Field4) — DATETIME