Lv4

Tables (4)

Comment

  • id — PK — Primary key — NOT NULL
  • comment
  • lectureId — FK

Instructor

  • id — PK — Primary key — NOT NULL
  • instructorName
  • experience
  • company
  • phoneNumber
  • biography

Lecture

  • id — PK — Primary key — NOT NULL
  • lectureName
  • price
  • introduction
  • category
  • instructorId (instructiorId)

User

  • id — PK — Primary key — NOT NULL
  • email
  • password
  • gender
  • phone_number
  • address
  • role