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