SystemSystem

Tables (3)

class (Untitled2)

  • c_id (Key) — varchar — Primary key — NOT NULL
  • c_name (class name) — varchar
  • score — int
  • Field — varchar
  • Field2

enrollment (Untitled3)

  • e_id (enroll number) — int — Primary key — NOT NULL
  • s_id (student id) — int — Foreign key → student.s_id — NOT NULL
  • c_id (Key) — varchar — Foreign key → class.c_id — NOT NULL
  • e_score (enroll score number) — char
  • Field

student (Untitled)

  • s_id (student id) — int — Primary key — NOT NULL
  • Field — varchar
  • email (student email) — varchar
  • phone (student phone number) — varchar
  • Field2