inflab
테이블 (4)
course
- Instructor Id (id2) — NOT NULL, — 외래 키 → 강사.Instructor Id — NOT NULL
- id — bigint
- description — text — NOT NULL
- category — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- price — int — NOT NULL
- status — varchar(255) — NOT NULL
- student_number — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- instructor_id — bigint — 외래 키 — NOT NULL
enrollment
- course_id — bigint — 외래 키 → course.id — NOT NULL
- student_id — bigint — 외래 키 → student.id — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
student
- id — bigint
- email — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- introduction — varchar(255) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
강사 (instructor)
- Instructor Id (id) — NOT NULL, — 기본 키 — NOT NULL
- 이메일 (email) — NOT NULL — NOT NULL
- 강사명 (name) — NOT NULL — NOT NULL
- 소개 (introduction) — NOT NULL
- created_at — datetime
- updated_at — datetime
- Field