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