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)