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