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