test
Tables (4)
course (수강신청)
- id (Key) — INT — Primary key — NOT NULL
- special_lecture_id (특강 아이디) — INT — Foreign key → special_lecture.id — NOT NULL
- student_phone (학생 전화번호) — VARCHAR(255) — Foreign key → student.phone — NOT NULL
instructor (강사)
- id (아이디) — VARCHAR(255) — Primary key — NOT NULL
- name (이름) — VARCHAR(50)
special_lecture (특강)
- id (아이디) — INT — Primary key — NOT NULL
- lecture_room (강의실) — VARCHAR(255)
- max_people (최대인원) — INT
- special_lecture_date (강의날짜) — DATE
- start_time (강의시간) — TIME
- title (강의명) — VARCHAR(100)
- instructor_id (강사 아이디) — VARCHAR(255) — Foreign key → instructor.id — NOT NULL
student (학생)
- phone (전화번호) — VARCHAR(255) — Primary key — NOT NULL
- name (이름) — VARCHAR(50)