GUKBIT v.1.1
Tables (8)
academy
- code — varchar — Primary key — NOT NULL
- name — varchar
- home_url — varchar
- region — varchar
- addr — varchar
- eval — double
- tel — varchar
auth_user_data
- Key (aid) — int — Primary key — NOT NULL
- 유저id (user_id) — varchar — Foreign key → user.유저id
- academy_code
- course_id
- Field (session) — int
board
- bid — int — Primary key — NOT NULL
- 유저id (author) — varchar — Foreign key → user.유저id
- date — Date
- view — Integer
- title — varchar
- content — varchar
- b_academy_code — varchar
- b_course_id — varchar
- visible — Boolean
- recommend — int
comment
- cid — int — Primary key — NOT NULL
- c_bid — int — Foreign key → board.bid — NOT NULL
- ccid (c_cid) — int
- c_author — varchar
- c_content — varchar
- c_date — Date
course
- cid — varchar — Primary key — NOT NULL
- academy_code — varchar — Foreign key → academy.code — NOT NULL
- Key (d_field_ss) — varchar — Foreign key → division.Key — NOT NULL
- id — varchar
- session — int
- name — varchar
- field_m — varchar
- field_s — varchar
- sep — varchar
- type — varchar
- start — date
- end — date
division
- Key (d_field_ss) — varchar — Primary key — NOT NULL
- div — varchar
rate
- rid — varchar — Primary key — NOT NULL
- course_id (c_cid) — varchar — Foreign key → course.cid — NOT NULL
- user_id — varchar — Foreign key → user.유저id — NOT NULL
- one_statement — varchar
- lecturers_eval — double
- curriculum_eval — double
- employment_eval — double
- culture_eval — double
- facility_eval — double
- advantage — varchar
- disadvantage — varchar
user
- 유저id (id) — varchar — Primary key — NOT NULL
- pw — varchar
- nickname — varchar
- email — varchar
- tel — varchar
- auth — Boolean
- rights — int
- image — Blob