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)