sd

Tables (3)

Lecture (...)

  • Key (lectureId) — bigint — Primary key — NOT NULL
  • 강의명 (lecture_name) — varchar
  • 가격 (price) — long
  • 소개 (introduction) — varchar
  • 카테고리 (category) — varchar
  • 등록일 (registrationDate) — timestamp
  • 강사 (teacher_name) — varchar
  • Key (teacherId) — bigint — Foreign key → Teacher.Key — NOT NULL

Teacher (..)

  • Key (teacherId) — bigint — Primary key — NOT NULL
  • 경력 (career) — int
  • 회사 (company) — varchar
  • 전화번호 (phone) — varchar
  • 소개 (introduction) — varchar
  • 이름 (teacher_name) — varchar

User (.)

  • Key (userId) — bigint — Primary key — NOT NULL
  • 이메일 (email) — varchar
  • 비밀번호 (password) — varchar
  • 부서 (dapartment) — varchar
  • 권한 (authority) — varchar