te

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

  • Key — Primary key — NOT NULL
  • 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