School

students, teachers, courses, classes and results. 9 tables, 32 columns, no data.

The map

Each line runs from a linking column (N) to the key it points at (1). The same tables are listed below as text.

The tables

students

id bigintPK
full_name varchar(200) required
born_on date
email varchar(255)

teachers

id bigintPK
full_name varchar(200) required
email varchar(255)

departments

id bigintPK
name varchar(200) required
head_teacher_id bigint→ teachers

courses

id bigintPK
title varchar(200) required
teacher_id bigint→ teachers required
department_id bigint→ departments required

classrooms

id bigintPK
room_code varchar(20) required
seats integer required

sessions

id bigintPK
course_id bigint→ courses required
classroom_id bigint→ classrooms required
starts_at timestamptz required

enrolments

id bigintPK
student_id bigint→ students required
course_id bigint→ courses required
grade numeric(12,2)

attendance

id bigintPK
student_id bigint→ students required
session_id bigint→ sessions required
present boolean required

audit_log

at timestamptz required
who varchar(100) required
what text

What you could look at in SSDO

Ask what depends on students.
enrolments joins students and courses: see it as a link table on the Map.
audit_log has no primary key: Review describes what that means.

Create a free workspace and open this sample All samples

PK is a primary key. “→ table” is a link (a foreign key) to that table. This page is a description of a structure we wrote; it holds no rows.