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