bakcoffice

Tables (3)

Admin

  • PK (admin_id) — Long — Primary key — NOT NULL
  • Field (email) — String
  • Field (password) — String
  • Field (department) — Enum
  • Field (role) — Enum
  • Field (created_at) — Date
  • Field (last_modified_at) — Date

Course

  • PK (course_id) — Long — Primary key — NOT NULL
  • FK (instructor_id) — Long — Foreign key → Instructor.PK — NOT NULL
  • Field (name) — String
  • Field (price) — Long
  • Field (introduction) — String
  • Field (category) — Enum
  • Field (registration_date) — Date
  • Field (created_at) — Date
  • Field (last_modified_at) — Date

Instructor (Instrcutor)

  • PK (instructor_id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (years_of_experience) — Int
  • Field (company) — String
  • Field (phone_number) — String
  • Field (introduction) — String
  • Field (created_at) — Date
  • Field (last_modified_at) — Date