article
article_id: int
article_title: varchar(100)
article_content: text
teacher_id: int
article_type: int
grade: int
author: char(20)
class
class_id: int
grade: int
class_num: int
teacher_id: int
lesson
lesson_id: int
class_id: int
article_id: int
active: int
post
post_id: int
lesson_id: int
post_content: text
student_id: int
post_type: int
post_article: text
post_time: timestamp
reply
reply_id: int
post_id: int
student_id: int
reply_content: text
reply_time: timestamp
student
s_id: int
s_name: varchar(20)
s_num: varchar(20)
s_password: varchar(20)
s_gender: int
class_id: int
supplement
supplement_id: int
lesson_id: int
movieAddress: varchar(255)
musicAddress: varchar(255)
supplement_content: text
time: timestamp
docAddress: varchar(255)
supplement_reply
replay_id: int
post_id: int
student_id: int
reply_content: text
reply_time: timestamp
teacher
t_id: int
t_name: varchar(20)
t_num: int
t_password: varchar(20)
test
test_id: int
lesson_id: int
test_content: text
time: timestamp
test_reply
replay_id: int
post_id: int
student_id: int
reply_content: text
reply_time: timestamp