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