meat4
Tables (13)
Assignment
- assignment_id — INT
- section_id — INT — Foreign key → Section.section_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- file_url — VARCHAR(255)
- deadline — DATETIME
Attendance
- attendance_id — INT
- enrollment_id — INT — Foreign key → Enrollment.enrollment_id — NOT NULL
- section_id — INT — Foreign key → Section.section_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- check_time — DATETIME
AuditLog
- audit_log_id — INT
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- action — VARCHAR(100) — NOT NULL
- target_type — VARCHAR(100)
- target_id — INT
- created_at — DATETIME — NOT NULL
Comment
- comment_id — INT
- post_id — INT — Foreign key → Post.post_id — NOT NULL
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- content — TEXT — NOT NULL
- is_answer — BOOLEAN
- created_at — DATETIME — NOT NULL
Course
- course_id — INT
- instructor_id — INT — Foreign key → Member.member_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- category — VARCHAR(100)
- thumbnail_url — VARCHAR(255)
- capacity — INT
- start_date — DATE
- end_date — DATE
- is_active — BOOLEAN
Enrollment
- enrollment_id — INT
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- course_id — INT — Foreign key → Course.course_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- enrolled_at — DATETIME — NOT NULL
- completion_date — DATETIME
Grade
- grade_id — INT
- enrollment_id — INT — Foreign key → Enrollment.enrollment_id — NOT NULL
- assignment_score — DECIMAL(5,2)
- attendance_score — DECIMAL(5,2)
- exam_score — DECIMAL(5,2)
- attitude_score — DECIMAL(5,2)
- total_score — DECIMAL(5,2)
- is_passed — BOOLEAN
Member
- member_id — INT
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- email — VARCHAR(100)
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
Memo
- memo_id — INT
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- content — TEXT
- target_date — DATE
Post
- post_id — INT
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- course_id — INT — Foreign key → Course.course_id
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- type — VARCHAR(20) — NOT NULL
- is_private — BOOLEAN
- view_count — INT
Profile
- member_id — INT — Foreign key → Member.member_id
- profile_img_url — VARCHAR(255)
- bio — TEXT
Section
- section_id — INT
- course_id — INT — Foreign key → Course.course_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content_url — VARCHAR(255)
- file_url — VARCHAR(255)
- order_no — INT
- section_date — DATE
Submission
- submission_id — INT
- assignment_id — INT — Foreign key → Assignment.assignment_id — NOT NULL
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- content — TEXT
- file_url — VARCHAR(255)
- submitted_at — DATETIME
- score — DECIMAL(5,2)
- feedback — TEXT