백오피스

테이블 (3)

Untitled (Teacher)

  • Key (teacher_id) — long — 기본 키 — NOT NULL
  • Field (teacher_name) — varchar(50)
  • Field (career) — Integer
  • Field (company) — varchar(100)
  • Field (phone_number) — varchar(50)
  • Field (bio) — String

Untitled (Lecture)

  • Key (lecture_id) — long — 기본 키 — NOT NULL
  • Key (teacher_id) — long — 외래 키 → Untitled.Key — NOT NULL
  • Field (lecture_name) — varchar(50)
  • Field (price) — Interger
  • Field (summary) — String
  • Field (category) — varchar(50)
  • Field (created_at) — LocalDateTime
  • Field (modified_at)

User (User(Admin))

  • Key (user_id) — long — 기본 키 — NOT NULL
  • Field (email) — varchar(50)
  • Field (password) — varchar(50)
  • Field (department) — varchar(50)
  • Field (authority) — varchar(50)