capstone

Tables (3)

connect

  • connectIdx — bigint — Primary key — NOT NULL
  • startTime — datetime
  • endTime — datetime
  • score — int
  • missionIdx — bigint — Foreign key → mission.missionIdx — NOT NULL
  • userIdx — bigint — Foreign key → user.userIdx — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime

mission

  • missionIdx — bigint — Primary key — NOT NULL
  • missionType — bigint
  • createdAt — datetime
  • updatedAt — datetime

user

  • userIdx — bigint — Primary key — NOT NULL
  • userName — varchar(100)
  • createdAt — datetime
  • updatedAt — datetime