데이파이브
테이블 (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