LMS

Tables (13)

assignment (Untitled9)

  • id (Key) — Long — Primary key — NOT NULL
  • sec_id (Key2) — Long — Foreign key → section.id — NOT NULL
  • title (Field) — String
  • description (Field2) — String
  • deadline (Field3) — Date
  • point (Field4) — Numeric — 배점
  • writer (Field5) — String

assignment_file (Untitled12)

  • id (Key) — Long — Primary key — NOT NULL
  • fileUrl (Field) — String
  • assign_id (Key2) — Long — Foreign key → assignment.id — NOT NULL

course (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • dept_name (Field2) — String
  • credits (Field3) — Numeric
  • classification (Field4) — String
  • course_id (Field5) — String

learning (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • sec_id (Key2) — Long — Foreign key → section.id — NOT NULL
  • week_num (Field) — String
  • start (Field2) — Date
  • end (Field3) — Date
  • time (Field4) — String

learning_progress (Untitled11)

  • id (Key) — Long — Primary key — NOT NULL
  • learning_id (Key3) — Long — Foreign key → learning.id — NOT NULL
  • state (Field) — Boolean
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL

notification (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • sec_id (Key2) — Long — Foreign key → section.id — NOT NULL
  • title (Field) — String
  • description (Field2) — String
  • writer (Field3) — String

notification_file (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • fileUrl (Field) — String
  • noti_id (Key2) — Long — Foreign key → notification.id — NOT NULL

role (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

section (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • course_id (Key2) — Long — Foreign key → course.id — NOT NULL
  • semester (Field) — String
  • year (Field2) — String
  • upload_day (Field3) — Enum

submit (Untitled10)

  • id (Key) — Long — Primary key — NOT NULL
  • score (Field) — Numeric
  • state (Field2) — Boolean
  • comment (Field3) — String
  • writer (Field4) — String
  • assign_id (Key2) — Long — Foreign key → assignment.id — NOT NULL
  • user_id (Key3) — Long — Foreign key → user.id — NOT NULL

submit_file (CopyOfUntitled12)

  • id (Key) — Long — Primary key — NOT NULL
  • fileUrl (Field) — String
  • submit_id (Key2) — Long — Foreign key → submit.id — NOT NULL

user (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • inst_id (Field2) — String
  • user_id (Field3) — String
  • password (Field4) — String
  • email (Field5) — String
  • phone (Field6) — String
  • dept_name (Field7) — String

user_section (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL
  • sec_id (Key3) — Long — Foreign key → section.id — NOT NULL
  • role_id (Key4) — Long — Foreign key → role.id — NOT NULL