te
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
- Key — Primary key — NOT NULL
- 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