SchoolOs

Tables (4)

sos_community (교사 관리자)

  • idx — int(11) — Primary key — NOT NULL
  • scs_idx_best (scs_idx) — int(11) — Foreign key → sos_community_student.idx — NOT NULL
  • pay — int(11)
  • auth_update — char(1)
  • auth_insert — char(1)
  • auth_delete — char(1)
  • auth_read — char(1)
  • reg_datetime — datetime
  • modify_datetime — datetime

sos_community_like (커뮤니티 좋아요)

  • idx — int(11) — Primary key — NOT NULL
  • scs_idx — int(11) — Foreign key → sos_community_student.idx — NOT NULL
  • sms_idx — int(11)
  • datetime — datetime

sos_community_rating (커뮤니티 별점)

  • idx — int(11) — Primary key — NOT NULL
  • scs_idx — int(11) — Foreign key → sos_community_student.idx — NOT NULL
  • sms_idx — int(11)
  • rating — int(11)
  • datetime — datetime

sos_community_student (학생 커뮤니티)

  • idx — int(11) — Primary key — NOT NULL
  • sms_id — int(11)
  • subject — varchar(255)
  • content — text
  • category — char(1)
  • reg_datetime — datetime
  • modify_datetime — datetime
  • del — char(1)
  • hit — int(11)
  • like — int(11)