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