soongmile

Tables (4)

Answer (AnswerTable)

  • 답변Id (answer_id) — Long — Primary key — NOT NULL
  • 내용 (content) — varchar(800)
  • 게시일 (post_time) — LocalDateTime
  • 작성자Id (user_id) — Long — Foreign key → User.사용자Id — NOT NULL
  • 질문Id (question_id) — Long — Foreign key → Question.질문Id — NOT NULL

Point (PointTable)

  • 포인트Id (point_id) — Long — Primary key — NOT NULL
  • 포인트 (point) — int

Question (QuestionTable)

  • 질문Id (question_id) — Long — Primary key — NOT NULL
  • 제목 (title) — varchar(100)
  • 내용 (content) — varchar(500)
  • 게시일 (post_time) — LocalDateTime
  • 수정일 (edit_time) — LocalDateTime
  • 조회수 (hits) — int
  • 작성자Id (user_id) — Long — Foreign key → User.사용자Id — NOT NULL

User (UserTable)

  • 사용자Id (user_id) — Long — Primary key — NOT NULL
  • 비밀번호 (password) — varchar(20)
  • 학과 (major) — varchar(20)
  • 학번 (collegeId) — varchar(10)
  • 닉네임 (nickname) — varchar(10)
  • 포인트Id (point_id) — Long — Foreign key → Point.포인트Id — NOT NULL