kkoProject
Tables (8)
Live (Room_Info)
- roomId (Key) — Integer — Primary key — NOT NULL
- roomName (Field4) — CHAR(80)
- roomPw (Field5) — CHAR(24)
- solverId (Key3) — Integer — Foreign key → User.userId — NOT NULL
Live (Peer_Info)
- peerId (Key) — CHAR(128) — Primary key — NOT NULL
- roomId (Field2) — Integer
- peerName (Field3) — String
Solve (Problem)
- problemId (Key) — Integer — Primary key — NOT NULL
- problemTitle (Field2) — CHAR(128)
- problemData (Field3) — VARCHAR(1024)
- problemSolution (Field4) — VARCHAR(1024)
- problemType (Field5) — Boolean
- endDate (Field6) — LocalDateTime
- hashTag (Field7) — CHAR(128)
- problemLevel (Field8) — Integer
- views (Field9) — Integer
- recommends (Field10) — Integer
- userId (Key3) — Integer — Foreign key → User.userId — NOT NULL
Solve (Answer)
- solveId (Key) — Integer — Primary key — NOT NULL
- problemId (Field3) — Integer
- solverId (Key2) — Integer — Foreign key → User.userId — NOT NULL
Solve (Attach)
- attachId (Key) — Integer — Primary key — NOT NULL
- imgUrl (Field2) — VARCHAR(1024)
- problemId (Key3) — Integer — Foreign key → Solve.problemId — NOT NULL
Solve (FeedBack)
- feedbackId (Key) — Integer — Primary key — NOT NULL
- feedbackData (Field2) — VARCHAR(1024)
- solverId (Key3) — Integer — Foreign key → User.userId — NOT NULL
Solve (Solution)
- solutionId (Key) — Integer — Primary key — NOT NULL
- userId (Field) — Integer
- problemId (Key2) — Integer — Foreign key → Solve.problemId — NOT NULL
User (Solver)
- userId (Key) — Integer — Primary key — NOT NULL
- problemId (Field) — Integer
- roomId (Field3) — Integer