academic_db_pjt
Tables (5)
Untitled4 (department)
- Key2 (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar
- Field2 (created_at) — timestamp
- Key (id2) — bigint — Foreign key → Untitled4.Key — NOT NULL
- Key (id3) — bigint — Foreign key → Untitled4.Key — NOT NULL
Untitled4 (student)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar
- Field2 (department_id) — bigint
- Field3 (grade) — smallint
- Field4 (email) — varchar
- Field5 (phone) — varchar
- Field6 (admitted_at) — date
Untitled4 (course)
- Key (id) — bigint — Primary key — NOT NULL
- Field (title) — varchar
- Field2 (professor_id) — bigint
- Field3 (credit) — smallint
Untitled4 (enrollment)
- Key (id) — bigint — Primary key — NOT NULL
- Field (student_id) — bigint
- Field2 (course_id) — bigint
- Field3 (score) — numeric
- Field4 (enrolled_at) — timestamp
- Key (id3) — bigint — NOT NULL
Untitled4 (professor)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar
- Field2 (department_id) — bigint
- Field3 (email) — varchar
- Field4 (hired_at) — date