spring-lv3

Tables (4)

Copy Of staff (CopyOfUntitled)

  • staff_id (아이디) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • team (부서) — VARCHAR(100)
  • auth (권한) — VARCHAR(100)

lecture (Untitled3)

  • lectuer_id (강의 아이디) — BIGINT — Primary key — NOT NULL
  • teacher_id (강사 아이디) — BIGINT — Foreign key → teacher.teacher_id — NOT NULL
  • lecture_name (강의명) — VARCHAR(255)
  • price (가격) — INT
  • class_intro (강의 소개) — VARCHAR(500)
  • regi_date (등록일) — DATE
  • category (카테고리) — VARCHAR(255)

staff (Untitled)

  • staff_id (아이디) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • team (부서) — VARCHAR(100)
  • auth (권한) — VARCHAR(100)

teacher (Untitled2)

  • teacher_id (강사 아이디) — BIGINT — Primary key — NOT NULL
  • teacher_name (강사) — VARCHAR(50)
  • career (경력) — INT
  • company (회사) — VARCHAR(255)
  • phone (전화번호) — VARCHAR(100)
  • teacher_intro (강사 소개) — VARCHAR(500)