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