skala_lum2
Tables (12)
Assignment
- assignment_id — Primary key — NOT NULL
- course_id — INT — Foreign key
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- deadline — DATETIME — NOT NULL
- slack_post_ts — VARCHAR(100)
- topic — VARCHAR(50)
- professorId (id2) — Foreign key → Professor.professor_id — NOT NULL
AssignmentRequirement
- requirement_id (Key2) — Primary key — NOT NULL
- assignment_id — INT — Foreign key
- content — VARCHAR(500) — NOT NULL
Course
- course_id — Primary key — NOT NULL
- course_name (반 이름) — VARCHAR(100) — NOT NULL
- GENERATION (기수) — VARCHAR(20)
- class_group (AI, Cloude) — VARCHAR(20)
Professor
- professor_id — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- password (Field)
Student
- student_id (Key) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- slack_user_id — VARCHAR(50) — NOT NULL
- password
- course_id — Foreign key → Course.course_id — NOT NULL
Submission
- submission_id — Primary key — NOT NULL
- student_id — INT — Foreign key
- content_text — TEXT
- file_url — TEXT
- file_name — VARCHAR(255)
- submitted_at — DATETIME
- slack_thread_ts — VARCHAR(100)
- status — VARCHAR(20)
- assignment_id (Key) — Foreign key → Assignment.assignment_id — NOT NULL
assignment
- assignment_id — SERIAL — Primary key
- class_id — INT — Foreign key → class.class_id
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- deadline — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
- topic — VARCHAR(100)
- professor_id — SERIAL — Foreign key → professor.professor_id
assignment_requirement
- requirement_id — SERIAL — Primary key
- assignment_id — INT — Foreign key → assignment.assignment_id
- content — VARCHAR(500) — NOT NULL
class (course)
- class_id — SERIAL — Primary key
- class_name — VARCHAR(100) — NOT NULL
- generation — INT
- class_group — VARCHAR(20) — NOT NULL
professor
- professor_id — SERIAL — Primary key
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(100)
student
- student_id — SERIAL — Primary key
- name — VARCHAR(50) — NOT NULL
- slack_user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255)
- class_id — INT — Foreign key → class.class_id
submission
- submission_id — SERIAL — Primary key
- student_id — INT — Foreign key → student.student_id
- assignment_id — INT — Foreign key → assignment.assignment_id
- content_text — TEXT
- file_url — TEXT
- file_name — VARCHAR(255)
- submitted_at — TIMESTAMP
- status — VARCHAR(20)
- slack_thread_ts — VARCHAR(100)