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