sample2342

Tables (6)

class_info

  • class_id (id) — BIGINT — Primary key
  • class_name (name) — CHAR(255)
  • class_capacity (capacity) — BIGINT

class_major (Untitled)

  • class_major_id (id) — BIGINT — Primary key — NOT NULL
  • major_id — BIGINT — Foreign key → major.major_id
  • class_id — BIGINT — Foreign key → class_info.class_id

class_student

  • class_id (id) — BIGINT — Primary key — NOT NULL

major

  • major_id (id) — BIGINT — Primary key

major_student

  • major_student_id (id) — BIGINT — Primary key — NOT NULL
  • major_id (id2) — BIGINT — Foreign key → major.major_id
  • student_id (id3) — BIGINT — Foreign key → student.student_id — NOT NULL

student

  • student_id (id) — BIGINT — Primary key — NOT NULL