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