2023.11.13 Quiz 테이블 수정

수정 : 2023.11.15 id 수정

//11.21 Notice 테이블 추가, 연관 관계 오류 수정

// 12.14

• DB diagram

Table User {
user_id integer [primary key]
username varchar
nickname varchar
password varchar
essay varchar
email varchar
role varchar
created_at timestamp
updated_at timestamp
}

Table PostReply {
post_reply_id integer [primary key]
content varchar
post_id integer
user_id integer
created_at timestamp
updated_at timestamp
}

Table StudyRoom {
study_room_id integer [primary key]
study_name varchar
title varchar
description varchar
start_date LocalDateTime //스터디 시작 날짜
end_date LocalDateTime //스터디 종료 날짜
start_time timestamp // 스터디 시작 시각
end_time timestamp // 스터디 종료 시각
current_num integer // 현재 참가중인 인원
max_num integer // 스터디 최대 인원
created_by integer
created_at timestamp
updated_at timestamp
}

Table StudyMember {
study_member_id integer [primary key]
study_id integer
user_id integer
status integer //0 : 승인 대기 1: 정회원 2: 가입 거부
}

Table Post {
post_id integer [primary key]
title varchar
content varchar
study_id integer
user_id integer
category integer // 글 종류(출석, 회고)
created_at timestamp
updated_at timestamp
}

Table StudySkill {
study_skill_id integer [primary key]
study_id integer
skill_id integer
}

Table Skill {
id integer [primary key]
skill_name String
position String
}

Table Quiz{
quiz_id integer [primary key]
user_id integer
study_id integer
title varchar
quiz_link varchar
difficulty integer
}

Table Qna{
qna_id integer [primary key]
user_id integer
category varchar
title varchar
content varchar
created_at timestamp
updated_at timestamp
}

Table QnaReply{
qnaReply_id integer [primary key]
qna_id integer
comment varchar
created_at timestamp
updated_at timestamp
}

Table Notice{
  notice_id integer [primary key]
  title varchar
  content varchar
  created_by integer
  created_at timestamp
  updated_at timestamp
}

Table Attendance {
attendance_id integer [primary key]
study_room_id integer
user_id integer
attendance_date LocalDateTime // 출석체크된 시간
status integer //0 : 지각 1: 출석
}

Table AttendanceDay{
attendance_id integer [primary key]
study_room_id varchar
user_id timestamp
attendance_date timestamp
status intefer 
}

Ref: "StudyRoom"."study_room_id" < "StudySkill"."study_id"
Ref: "StudySkill"."skill_id" - "Skill"."id"
Ref: "StudyRoom"."study_room_id" < "StudyMember"."study_id"
Ref: "User"."user_id" < "StudyMember"."user_id"
Ref: "StudyRoom"."study_room_id" < "Post"."study_id"
Ref: "User"."user_id" < "Post"."user_id"
Ref: "Post"."post_id" < "PostReply"."post_id"
Ref: "User"."user_id" < "PostReply"."user_id"
Ref: "StudyRoom"."study_room_id" < "Attendance"."study_room_id"
Ref: "User"."user_id" < "Attendance"."user_id"
Ref: "StudyMember"."user_id" < "Quiz"."user_id"
Ref: "StudyRoom"."study_room_id" < "Quiz"."study_id"
Ref: "User"."user_id" < "Qna"."user_id"
Ref:  "User"."user_id" < "Notice"."created_by"
Ref: "Qna"."qna_id" < "QnaReply"."qna_id"
Ref : "User"."user_id" - "StudyRoom"."created_by"
Ref: "StudyRoom"."study_room_id" < "AttendanceDay"."study_room_id"
Ref: "User"."user_id" < "AttendanceDay"."user_id"