course_registeration
Tables (4)
lesson (수업)
- id (신청id) — BIGINT — Primary key — NOT NULL
- student_id (학생id) — BIGINT — Foreign key → student.id — NOT NULL
- tutor_id (튜터id) — BIGINT — Foreign key → tutor.id — NOT NULL
- timeslot_id (타임슬롯 id) — BIGINT — Foreign key → timeslot.id — NOT NULL
- class_path (수업 길이) — ENUM(30분, 60분)
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
student (학생)
- id (학생id) — BIGINT — Primary key — NOT NULL
- name (학생 이름) — VARCHAR(100)
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
timeslot (시간대)
- id (타임슬롯 id) — BIGINT — Primary key — NOT NULL
- tutor_id (튜터id) — BIGINT — Foreign key → tutor.id — NOT NULL
- start_time (시작시간) — TIMESTAMP
- end_time (종료시간) — TIMESTAMP
- is_available (수업 가능여부) — BOOLEAN(TRUE/FALSE)
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
tutor (튜터)
- id (튜터id) — BIGINT — Primary key — NOT NULL
- name (튜터 이름) — VARCHAR(100)
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP