Data Dictionary

《Data Dictionary》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、DataItemsDefinitionTableTable“Register”NameTypeLengthDescriptionm_IDvarchar10Usernameforregisterloginm_pwdvarchar10Passwordforregisterloginm_stuIDvarchar10StudentIDorstaffIDforregisterm_truenamevarchar10Realnameofregisterm_Emailvarchar20Emailofregisterm_qqvarchar16QQnumbero

2、fStudentm_typeint10forstudent1forteacher2foradministratorTable“Message”NameTypeLengthDescriptionsenderVarchar10thepeoplewhosendthemessagereceiverVarchar10ThepeoplewhoreceivethemessageMs_datedatetimeWhensendthemessageMs_contentTextThecontentofthemessageTable“course_material”

3、NameTypeLengthDescriptionA_IDvarchar10UsernameforadministratorloginA_pwdvarchar10PasswordforadministratorloginA_namevarchar10RealnameofadministratorA_Emailvarchar20EmailofadministratorA_Icardvarchar18IdentitycardnumberofadministratorTable“Course”NameTypeLengthDescriptionC_I

4、Dvarchar10NumberofcourseC_namevarchar20CoursenameTable“online_QA”NameTypeLengthDescriptionQA_IDvarchar8IDforonline_QAStart_timedatetimeWhenQAstartsEnd_timedatetimeWhenQAendscontentTextThecontentofQATable“course_bulletin”NameTypeLengthDescriptionCb_IDvarchar10IDforcourse_bul

5、letinCb_datedatetimeThetimecoursebulletinuploadCb_contentTextContentofcoursebulletinTable“Course_discuss”NameTypeLengthDescriptionCd_IDvarchar10IDforcoursediscussCd_namevarchar10IDforwhopublishthediscussCd_datedatetimeWhenpublishthediscussCd_contentTextContentofthediscussTa

6、ble“reply”NameTypeLengthDescriptionR_IDvarchar10ReplyIDR_whoVarchar10WhopublishthereplyR_datedatetimeWhenpublishthereplyR_contentTextThecontentofthereplyTable“own_course”NameTypeLengthDescriptionC_IDvarchar10ThecourseIDM_IDvarchar10ThepeoplewhoteachorlearnthiscourseTable“ow

7、n_QA”NameTypeLengthDescriptionQA_IDvarchar10TheQAIDC_IDvarchar10ThecoursewhichhasthisQATable“own_dis”NameTypeLengthDescriptionCd_IDvarchar10Thecourse_discussIDC_IDvarchar10ThecoursewhichhasthisdiscussTable“get_reply”NameTypeLengthDescriptionCd_IDvarchar10Thecourse_discussID

8、R_IDvarchar10ThereplywhichreplytothiscoursediscussTable“own_mt”NameTypeLengthDescr