lecture
Tables (4)
LECTURE (특강)
- LECTURE_ID (Key) — BIGINT — Primary key — NOT NULL
- TEACHER_ID (강사ID) — BIGINT — Foreign key → TEACHER.TEACHER_ID — NOT NULL
- NAME (강의명) — VARCHAR
- CAPACITY (현재신청인원) — INT
- MAX_CAPACITY (신청최대인원) — INT
- START_DT (시작일시) — DATETIME
- END_DT (종료일시) — DATETIME
LECTURE_REGISTRATION (특강 신청자)
- LECTURE_REGISTRATION_ID (Key) — BIGINT — Primary key — NOT NULL
- LECTURE_ID (강의 ID) — BIGINT — Foreign key → LECTURE.LECTURE_ID — NOT NULL
- USER_ID (유저 ID) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
- REG_DT (신청일시) — BIGINT
TEACHER (강사)
- TEACHER_ID (Key) — BIGINT — Primary key — NOT NULL
- NAME (강사명) — VARCHAR
- EMAIL (이메일) — VARCHAR
USERS (사용자)
- USER_ID (Key) — BIGINT — Primary key — NOT NULL
- NAME (유저명) — VARCHAR
- EMAIL (이메일) — VARCHAR
- PASSWORD (패스워드) — VARCHAR
- REG_DT (등록일시) — DATETIME
- MOD_DT (수정일시) — DATETIME