tes
Tables (4)
courses
- id — BIGINT
- category — VARCHAR(255) — NOT NULL
- code — CHAR(36) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- introduction — TEXT — NOT NULL
- instructor_id — BIGINT — NOT NULL
- price — INT — NOT NULL
- visibility — VARCHAR(255)
- opened_at — TIMESTAMP
- closed_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
enrollments
- id — BIGINT
- student_id — BIGINT — NOT NULL
- course_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
instructors
- id — BIGINT
- code — CHAR(36) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
students
- id — BIGINT
- code — CHAR(36) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP