x
Tables (7)
course
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- created_date — timestamp
- last_updated_date — timestamp
- is_deleted — boolean — NOT NULL
full_time_employee
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- salary — decimal(19,2)
part_time_employee
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- hourly_wage — decimal(19,2)
passport
- id — bigint — Primary key — NOT NULL
- number — varchar(255) — NOT NULL
review
- id — bigint — Primary key — NOT NULL
- description — varchar(255)
- rating — varchar(255)
- course_id — bigint — Foreign key → course.id — NOT NULL
student
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- city — varchar(255)
- line1 — varchar(255)
- line2 — varchar(255)
- id2 — bigint — Foreign key → passport.id — NOT NULL
student_course
- student_id — bigint — Foreign key → student.id — NOT NULL
- course_id — bigint — Foreign key → course.id — NOT NULL