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