데이파이브

테이블 (13)

DIMC

  • Student ID (student_id) — INT(11) — 외래 키 → 학생.Student ID — NOT NULL
  • DIMC URL (dimc_url) — VARCHAR(255)

강사 (instructors)

  • Instructor ID (insturctor_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)

강의 (lectures)

  • Lecture ID (lecture_id) — INT(11) — 기본 키 — NOT NULL
  • Instructor ID (insturctor_id) — INT(11) — 외래 키 → 강사.Instructor ID — NOT NULL
  • Lecture Name (lecture_name) — VARCHAR(255)
  • Syllabus (syllabus) — TEXT

공지 (notices)

  • Notice ID (notice_id) — INT(11) — 기본 키 — NOT NULL
  • Writer (writer) — VARCHAR(255)
  • Title (title) — VARCHAR(255)
  • Body (body) — TEXT
  • Posted Datetime (posted_at) — TIMESTAMP
  • Target Type (target_type) — VARCHAR(20)

댓글 (comments)

  • Comment ID (comment_id) — INT(11) — 기본 키 — NOT NULL
  • Writer ID (student_id) — INT(11) — 외래 키 → 학생.Student ID — NOT NULL
  • Thread ID (thread_id) — INT(11) — 외래 키 → 커뮤니티 글.Thread ID — NOT NULL
  • Comment (comment) — TEXT
  • Datetime (posted_at) — TIMESTAMP

듣고있는 강의 (registrations)

  • Student ID (student_id) — INT(11) — 외래 키 → 학생.Student ID — NOT NULL
  • Lecture ID (lecture_id) — INT(11) — 외래 키 → 강의.Lecture ID — NOT NULL

매니저 (manager)

  • Manager ID (manager_id) — INT(11) — 기본 키 — NOT NULL
  • Field

상담신청 (Consultations)

  • Student ID (student_id) — INT(11) — 외래 키 → 학생.Student ID — NOT NULL
  • Instructor ID (insturctor_id) — INT(11) — 외래 키 → 강사.Instructor ID — NOT NULL
  • Date (request_datetime) — DATE
  • Status (status) — VARCHAR(20)
  • Content (content) — TEXT

수강신청 (enrollment)

  • Student ID (student_id) — INT(11) — 외래 키 → 학생.Student ID — NOT NULL
  • Lecture ID (lecture_id) — INT(11) — 외래 키 → 강의.Lecture ID — NOT NULL

출석 (attendances)

  • Student ID (student_id) — INT(11) — 외래 키 → 학생.Student ID — NOT NULL
  • Lecture ID (lecture_id) — INT(11) — 외래 키 → 강의.Lecture ID — NOT NULL
  • Attendence Date (attendance_date) — DATE
  • Status (status) — VARCHAR(20)

커뮤니티 글 (threads)

  • Thread ID (thread_id) — INT(11) — 기본 키 — NOT NULL
  • Writer ID (student_id) — INT(11) — 외래 키 → 학생.Student ID — NOT NULL
  • Title (title) — VARCHAR(255)
  • Body (body) — TEXT
  • Posted Datetime (posted_at) — TIMESTAMP

학생 (students)

  • Student ID (student_id) — INT(11) — 기본 키 — NOT NULL
  • Login ID (login_id) — VARCHAR(255)
  • Password (Field) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Birthday (birthday) — DATE
  • PhoneNum (phone) — VARCHAR(20)

희망수업 (wishlist)

  • Student ID (student_id) — INT(11) — 외래 키 → 학생.Student ID — NOT NULL
  • Lecture ID (lecture_id) — INT(11) — 외래 키 → 강의.Lecture ID — NOT NULL