x

Tables (7)

course

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • created_date — timestamp
  • last_updated_date — timestamp
  • is_deleted — boolean — NOT NULL

full_time_employee

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • salary — decimal(19,2)

part_time_employee

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • hourly_wage — decimal(19,2)

passport

  • id — bigint — Primary key — NOT NULL
  • number — varchar(255) — NOT NULL

review

  • id — bigint — Primary key — NOT NULL
  • description — varchar(255)
  • rating — varchar(255)
  • course_id — bigint — Foreign key → course.id — NOT NULL

student

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • city — varchar(255)
  • line1 — varchar(255)
  • line2 — varchar(255)
  • id2 — bigint — Foreign key → passport.id — NOT NULL

student_course

  • student_id — bigint — Foreign key → student.id — NOT NULL
  • course_id — bigint — Foreign key → course.id — NOT NULL