Lv.3

Tables (3)

Instructor

  • instructorId — BIGINT — Primary key — NOT NULL
  • instructorName — VARCHAR
  • experience — BIGINT
  • company (companny) — VARCHAR
  • phoneNumber — VARCHAR
  • biography — VARCHAR

Lecture

  • lectureId — BIGINT — Primary key — NOT NULL
  • lectureName — VARCHAR
  • price — BIGINT
  • introduction — VARCHAR
  • category — ENUM('SPRING', 'REACT','NODE')
  • instructorId — BIGINT
  • createdAt — DATETIME

User

  • userId — BIGINT — Primary key — NOT NULL
  • username — VARCHAR
  • email — VARCHAR
  • password — VARCHAR
  • department — ENUM('CURRICULUM', 'MARKETING', 'DEVELOPMENT')
  • role — ENUM('MANAGER', 'STAFF')