2
Tables (35)
admin
- admin_id — varchar(50) — Primary key — NOT NULL
- password — varchar(100) — NOT NULL
alarm_list
- alarm_id — int(11) — Primary key — NOT NULL
- user_id — varchar(50) — NOT NULL
- class_id — int(11) — NOT NULL
- type — varchar(20) — NOT NULL
- title — varchar(255) — NOT NULL
- created_at — timestamp
- is_read — tinyint(1)
attendance
- attendance_id — int(11) — Primary key — NOT NULL
- student_id — varchar(50) — Foreign key → student.student_id — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- date — date — NOT NULL
- state — enum('present','absent','late','excused')
- created_at — timestamp
- updated_at — timestamp
- reason — text
board
- board_id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id
- board_name — varchar(255) — NOT NULL
- is_default — tinyint(1)
class
- class_id — int(11) — Primary key — NOT NULL
- class_name — varchar(255) — NOT NULL
- prof_id — varchar(50) — Foreign key → professor.prof_id
- start_time — time — NOT NULL
- end_time — time — NOT NULL
- present_start — time — NOT NULL
- present_end — time — NOT NULL
- late_end — time — NOT NULL
- credit — int(11) — NOT NULL
- capacity — int(11) — NOT NULL
- course_type — enum('전공','교양') — NOT NULL
- required — tinyint(1) — NOT NULL
class_day
- id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- day_of_week — enum('월','화','수','목','금','토','일') — NOT NULL
class_milestone
- milestone_id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- title — varchar(255) — NOT NULL
- due_date — datetime — NOT NULL
- created_at — timestamp
- updated_at — timestamp
course_registration
- id — int(11) — Primary key — NOT NULL
- student_id — varchar(50) — Foreign key → student.student_id — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- registration_status — enum('예비','확정') — NOT NULL
- registered_at — datetime
- preset — int(11) — NOT NULL
department
- department_id — int(11) — Primary key — NOT NULL
- department_name — varchar(255) — NOT NULL
- university_id — int(11) — Foreign key → university.university_id — NOT NULL
exam
- exam_id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- prof_id — varchar(50) — NOT NULL
- prof_name — varchar(100) — NOT NULL
- title — varchar(255) — NOT NULL
- start_time — datetime — NOT NULL
- end_time — datetime — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- question_count — int(11) — NOT NULL
exam_answer
- answer_id — int(11) — Primary key — NOT NULL
- submission_id — int(11) — Foreign key → exam_submission.submission_id — NOT NULL
- question_id — int(11) — Foreign key → exam_question.question_id — NOT NULL
- student_id — varchar(50) — NOT NULL
- exam_id — int(11) — NOT NULL
- answer — int(11)
- is_correct — tinyint(1)
exam_board
- board_id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- board_name — varchar(100)
- created_at — timestamp
- updated_at — timestamp
exam_question
- question_id — int(11) — Primary key — NOT NULL
- exam_id — int(11) — Foreign key → exam.exam_id — NOT NULL
- question_title — text — NOT NULL
- question_text — text — NOT NULL
- correct_answer — int(11) — NOT NULL
- answer1 — text — NOT NULL
- answer2 — text — NOT NULL
- answer3 — text — NOT NULL
- answer4 — text — NOT NULL
exam_submission
- submission_id — int(11) — Primary key — NOT NULL
- exam_id — int(11) — Foreign key → exam.exam_id — NOT NULL
- student_id — varchar(50) — Foreign key → student.student_id — NOT NULL
- submitted_at — timestamp
- score — int(11)
likes
- like_id — int(11) — Primary key — NOT NULL
- post_id — int(11) — Foreign key → post.post_id — NOT NULL
- user_id — varchar(255) — NOT NULL
- created_at — timestamp
message
- message_id — int(11) — Primary key — NOT NULL
- sender_id — varchar(50) — NOT NULL
- sender_name — varchar(50) — NOT NULL
- receiver_id — varchar(50) — NOT NULL
- receiver_name — varchar(50) — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- sent_at — timestamp
- is_read — tinyint(1)
notice
- notice_id — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- created_at — datetime
post
- post_id — int(11) — Primary key — NOT NULL
- board_id — int(11) — Foreign key → board.board_id
- author_id — varchar(255)
- author_role — varchar(255)
- author — varchar(255)
- title — varchar(255)
- content — text
- created_at — timestamp
- updated_at — timestamp
- view — int(11)
- likes — int(11)
- file_path — varchar(255)
post_milestone_status
- status_id — int(11) — Primary key — NOT NULL
- post_id — int(11) — Foreign key → team_activity_post.post_id — NOT NULL
- milestone_id — int(11) — Foreign key → class_milestone.milestone_id — NOT NULL
- status — varchar(20) — NOT NULL
- updated_at — timestamp
professor
- prof_id — varchar(50) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- department — varchar(100)
- email — varchar(100)
- password — varchar(255) — NOT NULL
- phone — varchar(50)
- university — varchar(100) — NOT NULL
project_member
- member_id — int(11) — Primary key — NOT NULL
- post_id — int(11) — Foreign key → team_activity_post.post_id — NOT NULL
- student_id — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- department — varchar(100)
- email — varchar(100)
- contact — varchar(50)
- approved_at — datetime — NOT NULL
recommended_grade
- id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- grade — int(11) — NOT NULL
registration_period
- id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- registration_type — enum('예비','본') — NOT NULL
- registration_start — datetime — NOT NULL
- registration_end — datetime — NOT NULL
schedule
- schedule_id — int(11) — Primary key — NOT NULL
- user_id — varchar(255) — NOT NULL
- date — date — NOT NULL
- title — varchar(255)
- content — text
- color — varchar(10)
- mark — tinyint(1)
- created_at — timestamp
- updated_at — timestamp
- alarm_time — datetime
student
- id — int(11) — Primary key — NOT NULL
- student_id — varchar(50) — NOT NULL
- university — varchar(100) — NOT NULL
- department — varchar(100)
- name — varchar(100) — NOT NULL
- email — varchar(255)
- password — varchar(255) — NOT NULL
- phone — varchar(50)
- grade — int(11)
student_class
- id — int(11) — Primary key — NOT NULL
- student_id — varchar(50) — Foreign key → student.student_id — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- remarks — varchar(255)
survey_board
- board_id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
survey_post
- survey_id — int(11) — Primary key — NOT NULL
- board_id — int(11) — Foreign key → survey_board.board_id — NOT NULL
- title — varchar(255) — NOT NULL
- start_time — datetime — NOT NULL
- end_time — datetime — NOT NULL
- created_at — timestamp
- updated_at — timestamp
survey_question
- question_id — int(11) — Primary key — NOT NULL
- survey_id — int(11) — Foreign key → survey_post.survey_id — NOT NULL
- question_text — text — NOT NULL
- question_type — enum('radio','checkbox','text','linear_scale') — NOT NULL
- options — json
- min_select — int(11)
- max_select — int(11)
- min_value — int(11)
- max_value — int(11)
- created_at — timestamp
- is_required — tinyint(1)
- min_label — varchar(255)
- max_label — varchar(255)
survey_response
- user_id — varchar(50) — Primary key — NOT NULL
- survey_id — int(11) — Foreign key → survey_post.survey_id — NOT NULL
- question_id — int(11) — Foreign key → survey_question.question_id — NOT NULL
- response — text — NOT NULL
team_activity_application
- application_id — int(11) — Primary key — NOT NULL
- post_id — int(11) — Foreign key → team_activity_post.post_id — NOT NULL
- applicant_student_id — varchar(50) — NOT NULL
- status — enum('PENDING','APPROVED','REJECTED')
- applied_at — timestamp
team_activity_comment
- comment_id — int(11) — Primary key — NOT NULL
- post_id — int(11) — Foreign key → team_activity_post.post_id — NOT NULL
- commenter_id — varchar(50) — NOT NULL
- content — text — NOT NULL
- created_at — timestamp
team_activity_post
- post_id — int(11) — Primary key — NOT NULL
- class_id — int(11) — Foreign key → class.class_id — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- author_id — varchar(50) — NOT NULL
- author_name — varchar(255)
- department — varchar(100)
- email — varchar(100)
- contact — varchar(50)
- likes — int(11)
- team_members — json
- created_at — timestamp
- updated_at — timestamp
todo_list
- todo_id — int(11) — Primary key — NOT NULL
- user_id — varchar(50) — NOT NULL
- text — varchar(255) — NOT NULL
- completed — tinyint(1)
- created_at — timestamp
- updated_at — timestamp
university
- university_id — int(11) — Primary key — NOT NULL
- university_name — varchar(255) — NOT NULL