kkang

Tables (6)

class (강좌)

  • PK (id) — serial — Primary key — NOT NULL
  • 강좌명 (class_name) — varchar — NOT NULL
  • 가격 (price) — int
  • class_id
  • teacher_id — int

class_detatil (강좌상세정보)

  • PK (id) — serial — Primary key — NOT NULL
  • FK (class_id) — serial — Foreign key → class.PK — NOT NULL
  • 강좌정보 (class_info) — varchar
  • 목차 (index) — varchar
  • 교재 (book) — varchar

codemaster (회사, 과목, 수준)

  • 회사 (company) — varchar
  • 과목 (subject) — varchar
  • 수준 (level) — varchar
  • 완강 (iscomplete) — bool
  • 무료,유료 (isfree) — bool

teacher (강사)

  • PK (id) — Primary key — NOT NULL
  • FK (teacher_id) — serial — Foreign key → class.PK — NOT NULL
  • 특징 (feature) — varchar
  • 이름 (name) — varchar

user (사용자)

  • PK (id) — serial — Primary key — NOT NULL
  • user_id — unique
  • 이름 (name) — varchar
  • email — varchar
  • 패스워드 (passwd) — varchar
  • 생년월일 (birth) — int
  • 성별 (issex) — bool
  • 휴대전화 (phone) — int
  • 학교 (school) — varchar
  • 권한 (permission) — char

user_log (log)

  • PK (id) — serial — Primary key — NOT NULL
  • FK (user_id) — Unique — Foreign key → user.PK — NOT NULL
  • (timeline) — datetime
  • (ip) — char
  • (what) — char
  • (act) — char