tes

Tables (4)

courses

  • id — BIGINT
  • category — VARCHAR(255) — NOT NULL
  • code — CHAR(36) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • introduction — TEXT — NOT NULL
  • instructor_id — BIGINT — NOT NULL
  • price — INT — NOT NULL
  • visibility — VARCHAR(255)
  • opened_at — TIMESTAMP
  • closed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

enrollments

  • id — BIGINT
  • student_id — BIGINT — NOT NULL
  • course_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

instructors

  • id — BIGINT
  • code — CHAR(36) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

students

  • id — BIGINT
  • code — CHAR(36) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP