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