school

Tables (3)

Teacher (teacher)

  • pk (t_id) — varchar(32) — Primary key — NOT NULL
  • Field (t_name) — varchar(32)

class

  • pk (c_id) — varchar(32) — Primary key — NOT NULL
  • Field (c_name) — varchar(32)

student

  • pk (s_id) — varchar(32) — Primary key — NOT NULL
  • Field (s_name) — varchar(32)
  • fk (hrt_id) — varchar(32) — Foreign key → Teacher.pk — NOT NULL
  • fk (c_id) — varchar(32) — Foreign key → class.pk — NOT NULL