week1

Tables (3)

member (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • name (VARCHAR(50))
  • email (VARCHAR(100))
  • github_id (Field3)
  • deleted_at (Field4)

member_mission (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
  • completed_at (Field3) — DATETIME — NOT NULL
  • member_id (2) — BIGINT — Foreign key → member.id — NOT NULL — Auto Increment
  • mission_id (Key2) — BIGINT — Foreign key → mission.id — NOT NULL — Auto Increment

mission (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
  • title (Field) — VARCHAR(100)
  • description (Field2) — VARCHAR(500) — NOT NULL
  • created_at (Field3) — DATETIME