db1

Tables (10)

ASSIGNMENT (Untitled3)

  • assignment_id (Key) — INT — Primary key — NOT NULL
  • course_id (Field) — INT
  • title (Field2) — VARCHAR
  • description (Field3) — TEXT
  • due_date (Field4) — DATE
  • status (Field5) — VARCHAR

ASSIGNMENT

  • assignment_id — INT
  • course_id — INT — Foreign key → COURSE.course_id
  • title — VARCHAR(100)
  • description — TEXT
  • due_date — DATE
  • status — VARCHAR(20)

COURSE (Untitled2)

  • course_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
  • user_id (Field) — INT
  • course_name (Field2) — VARCHAR
  • professor (Field3) — VARCHAR
  • class_time (Field4) — VARCHAR

COURSE

  • course_id — INT
  • user_id — INT — Foreign key → USER.user_id
  • course_name — VARCHAR(100)
  • professor — VARCHAR(50)
  • class_time — VARCHAR(50)

EXAM (Untitled4)

  • exam_id (Key) — INT — Primary key — NOT NULL
  • course_id (Field) — INT
  • exam_type (Field2) — VARCHAR
  • exam_date (Field3) — DATE

EXAM

  • exam_id — INT
  • course_id — INT — Foreign key → COURSE.course_id
  • exam_type — VARCHAR(50)
  • exam_date — DATE

TEAM_PROJECT (Untitled5)

  • project_id (Key) — INT — Primary key — NOT NULL
  • course_id (Field) — INT
  • project_name (Field2) — VARCHAR
  • presentation_date (Field3) — DATE
  • member_info (Field4) — TEXT

TEAM_PROJECT

  • project_id — INT
  • course_id — INT — Foreign key → COURSE.course_id
  • project_name — VARCHAR(100)
  • presentation_date — DATE
  • member_info — TEXT

USER (Untitled)

  • user_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • email (Field2) — VARCHAR
  • password (Field3) — VARCHAR

USER

  • user_id — INT
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • password — VARCHAR(100)