OTC

Tables (12)

article

  • Key (id) — int — Primary key — NOT NULL
  • Key (menber_id) — int — Foreign key → member.Key — NOT NULL
  • Key (classrom_id) — int — Foreign key → classroom.Key — NOT NULL
  • Field (title) — int
  • Field (content) — int
  • Field (article_type) — int
  • Field (hit) — int
  • Field (created_at) — timestamp
  • Field (created_by) — int
  • Field (modified_at) — timestamp
  • Field (modified_by) — int
  • Field (deleted_at) — timestamp

article_comment

  • Key (id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → member.Key — NOT NULL
  • Key (article_id) — int — Foreign key → article.Key — NOT NULL
  • Field (content) — varchar
  • Field (created_at) — timestamp
  • Field (modified_at) — timestamp
  • Field (deleted_at) — timestamp

attendence

  • Key (id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → member.Key — NOT NULL
  • Field (check_in) — timestamp
  • Field (check_out) — timestamp
  • Field (status) — int

classroom

  • Key (id) — int — Primary key — NOT NULL
  • Field (year) — int
  • Field (grade) — int
  • Field (class) — int

collection

  • Key (id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → member.Key — NOT NULL
  • Field (background_image) — list
  • Field (head_list) — list
  • Field (top_list) — list
  • Field (under_list) — list
  • Field (shoes_list) — list

item

  • Key (id) — int — Primary key — NOT NULL
  • Field (image_url) — varchar
  • Field (price) — int
  • Field (part_number) — int

lecture

  • Key (id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → member.Key — NOT NULL
  • Field (title) — varchar
  • Field (day_of_week) — int
  • Field (time_table) — int
  • Field (lecture_type) — int
  • Field (lecture_url) — varchar

like

  • Key (id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → member.Key — NOT NULL
  • Key (board_id) — int — Foreign key → article.Key — NOT NULL
  • Key (flag) — boolean

member

  • Key (id) — int — Primary key — NOT NULL
  • Key (role_id) — int — Foreign key → role.Key — NOT NULL
  • Key (classroom_id) — int — Foreign key → classroom.Key — NOT NULL
  • Field (member_id) — varchar
  • Field (password) — int
  • Field (name) — int
  • Field (birthday) — date
  • Field (email) — varchar
  • Field (point) — int
  • Field (deleted_at) — timestamp

proflie (profile)

  • Key (id) — int — Primary key — NOT NULL
  • Field (profile_image) — varchar
  • Field (background_image) — int
  • Field (position_head) — int
  • Field (position_top) — int
  • Field (position_under) — int
  • Field (position_shoes) — int
  • Key (member_id) — int — Foreign key → member.Key — NOT NULL

role

  • Key (id) — int — Primary key — NOT NULL
  • Field (role_name) — varchar

schedule

  • Key (id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → member.Key — NOT NULL
  • Key (lecture_id) — int — Foreign key → lecture.Key — NOT NULL
  • Field (schedule_date) — date