dong1443

Tables (10)

attendance

  • attendance_id — VARCHAR(20) — Primary key — NOT NULL
  • attendance_date — DATE — NOT NULL
  • status — varchar(30)
  • professor_id — varchar(20)
  • attendance_remarks — VARCHAR(200)
  • student_id — VARCHAR(20) — NOT NULL
  • course_id — VARCHAR(20) — NOT NULL

course

  • course_id — VARCHAR(20) — Primary key — NOT NULL
  • dept_id — VARCHAR(20) — NOT NULL
  • professor_id — VARCHAR(20) — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • course_status — varchar(20) — NOT NULL
  • course_max_cnt — INT
  • course_score — INT — NOT NULL
  • credit_category — varchar(30) — NOT NULL
  • course_plan — TEXT

course_time

  • course_time_id — VARCHAR(20) — Primary key — NOT NULL
  • professor_id — varchar(20) — NOT NULL
  • course_id — VARCHAR(20) — NOT NULL
  • course_time_yoil — ENUM('월', '화', '수', '목', '금', '토', '일')
  • course_time_start — TIME
  • course_time_end — TIME

dept

  • dept_id — VARCHAR(20) — Primary key — NOT NULL
  • dept_name — VARCHAR(50) — NOT NULL

notice

  • notice_id — VARCHAR(10) — NOT NULL
  • writer_id — VARCHAR(10) — NOT NULL
  • notice_title — VARCHAR(100) — NOT NULL
  • notice_content — TEXT — NOT NULL
  • notice_created_at — DATETIME — NOT NULL
  • notice_updated_at — DATETIME
  • notice_file — VARCHAR(255)
  • notice_read_count — INT

post

  • post_id — VARCHAR(10) — NOT NULL
  • author_id — VARCHAR(10) — NOT NULL
  • post_title — VARCHAR(100) — NOT NULL
  • post_content — TEXT — NOT NULL
  • post_created_at — DATETIME — NOT NULL
  • post_updated_at — DATETIME
  • post_group — INT
  • post_group_level — INT
  • post_group_step — INT
  • post_file — VARCHAR(255)
  • post_read_count — INT

professor

  • professor_id — VARCHAR(20) — Primary key — NOT NULL
  • professor_name — VARCHAR(50) — NOT NULL
  • professor_email — VARCHAR(100)
  • professor_birthday — DATE
  • professor_phone — VARCHAR(20)
  • professor_major — VARCHAR(50)
  • professor_img — VARCHAR(255)
  • professor_password — VARCHAR(255)

registration

  • registration_id — VARCHAR(20) — Primary key — NOT NULL
  • student_id — VARCHAR(20) — NOT NULL
  • course_id — VARCHAR(20) — NOT NULL
  • professor_id — VARCHAR(20) — NOT NULL
  • registration_status — varchar(30)
  • registration_create — DATETIME
  • registration_update — DATETIME

score

  • student_id — varchar(20)
  • score_id — varchar(20)
  • course_id — varchar(20) — NOT NULL
  • professor_id — varchar(20) — NOT NULL
  • score_end — varchar(20)
  • score_level — varchar(20)
  • score_etc — varchar(50)
  • dept_id — varchar(30) — NOT NULL

student

  • student_id — VARCHAR(20) — Primary key — NOT NULL
  • student_name — VARCHAR(50) — NOT NULL
  • student_num — VARCHAR(20) — NOT NULL
  • dept_id — VARCHAR(20) — NOT NULL
  • student_email — VARCHAR(100)
  • student_password — VARCHAR(255)
  • student_status — varchar(20)
  • student_birthday — DATE
  • student_phone — VARCHAR(20)
  • student_img — VARCHAR(255)