createwebedutables.sql

采用Eclispe开发平台

   AnnounceId           int                  not null,
   ParentId             int                  null,
   BoardId              int                  null,
   CourseId             int                  null,
   ClassId              int                  null,
   UserId               int                  null,
   Topic                varchar(64)          null,
   Content              text                 null,
   SentTime             datetime             null,
   Address              varchar(15)          null,
   ReplyTime            datetime             null,
   ReplyCounter         int                  null default 0,
   constraint PK_T_BBS_ANNOUNCE primary key  (AnnounceId)
)
go


/*==============================================================*/
/* Table: t_bbs_board                                           */
/*==============================================================*/
create table t_bbs_board (
   BoardId              int                  not null,
   BoardName            varchar(64)          null,
   Description          varchar(128)         null,
   BoardMaster          int                  null,
   constraint PK_T_BBS_BOARD primary key  (BoardId)
)
go


/*==============================================================*/
/* Table: t_class                                               */
/*==============================================================*/
create table t_class (
   SchoolId             char(4)              null,
   ClassId              int                  not null,
   ClassName            varchar(64)          not null,
   State                int                  null default 1,
   NumberOfStudent      int                  not null,
   Semester             varchar(32)          not null,
   Monitor              int                  null,
   Tag                  varchar(255)         null,
   constraint PK_T_CLASS primary key  (ClassId)
)
go


/*==============================================================*/
/* Table: t_class_course                                        */
/*==============================================================*/
create table t_class_course (
   ClassId              int                  not null,
   CourseId             int                  not null,
   State                int                  null,
   StartDate            datetime             null,
   PlannedEndDate       datetime             null,
   EndDate              datetime             null,
   TeacherId            int                  not null,
   constraint PK_T_CLASS_COURSE primary key  (ClassId, CourseId)
)
go


/*==============================================================*/
/* Table: t_course                                              */
/*==============================================================*/
create table t_course (
   CourseId             int                  not null,
   CourseCode           varchar(8)           not null,
   CourseName           varchar(32)          not null,
   CourseDuration       int                  not null,
   CourseState          int                  not null,
   CourseUrl            varchar(255)         not null,
   VersionNumber        varchar(16)          null,
   Tag                  varchar(255)         null,
   constraint PK_T_COURSE primary key  (CourseId)
)
go


/*==============================================================*/
/* Table: t_course_developer                                    */
/*==============================================================*/
create table t_course_developer (
   UserId               int                  not null,
   constraint PK_T_COURSE_DEVELOPER primary key  (UserId)
)
go


/*==============================================================*/
/* Table: t_course_history                                      */
/*==============================================================*/
create table t_course_history (
   LogId                int                  not null,
   CourseId             int                  not null,
   Teacher              varchar(32)          not null,
   AddTime              datetime             not null,
   Content              varchar(255)         null,
   Name                 varchar(32)          null,
   Chapter              int                  null,
   Unit                 int                  null,
   constraint PK_T_COURSE_HISTORY primary key  (LogId)
)
go


/*==============================================================*/
/* Table: t_exam                                                */
/*==============================================================*/
create table t_exam (
   ExamId               int                  not null,
   CourseId             int                  null,
   ExamName             varchar(64)          null,
   ExamType             int                  null,
   Unit                 int                  null,
   Chapter              int                  null,
   Section              int                  null,
   QuestionType         int                  null,
   NumberOfQuestion     int                  null,
   State                int                  null default 0,
   InstanceLimit        int                  null,
   PassMark             int                  null,
   Duration             int                  null,
   Tag                  varchar(255)         null,
   constraint PK_T_EXAM primary key  (ExamId)
)
go


/*==============================================================*/
/* Table: t_exam_assigned                                       */
/*==============================================================*/
create table t_exam_assigned (
   AssignmentId         int                  not null,
   ExamId               int                  not null,
   StartTime            datetime             null,
   EndTime              datetime             null,
   TeacherId            int                  null,
   Tag                  varchar(255)         null,
   constraint PK_T_EXAM_ASSIGNED primary key  (AssignmentId)
)
go


/*==============================================================*/
/* Table: t_exam_assigned_paper                                 */
/*==============================================================*/
create table t_exam_assigned_paper (
   AssignmentId         int                  not null,
   PaperId              int                  not null,
   constraint PK_T_EXAM_ASSIGNED_PAPER primary key  (AssignmentId, PaperId)
)
go


/*==============================================================*/
/* Table: t_exam_assigned_student                               */
/*==============================================================*/
create table t_exam_assigned_student (
   AssignmentId         int                  not null,
   UserId               int                  not null,
   constraint PK_T_EXAM_ASSIGNED_STUDENT primary key  (AssignmentId, UserId)
)
go


/*==============================================================*/
/* Table: t_exam_question                                       */
/*==============================================================*/
create table t_exam_question (
   ExamId               int                  not null,
   PaperId              int                  not null,
   QuestionSeq          int                  not null,
   QuestionId           int                  not null,
   constraint PK_T_EXAM_QUESTION primary key  (ExamId, PaperId, QuestionSeq)
)
go


/*==============================================================*/
/* Table: t_exam_question_submit                                */
/*==============================================================*/
create table t_exam_question_submit (
   SubmitId             int                  not null,
   QuestionSeq          int                  not null,
   Answer               text                 null,
   Mark                 int                  not null default -1,
   PointMark            varchar(64)          null,
   TeacherComment       varchar(255)         null,
   constraint PK_T_EXAM_QUESTION_SUBMIT primary key  (SubmitId, QuestionSeq)
)
go


/*==============================================================*/
/* Table: t_exam_question_upload                                */
/*==============================================================*/
create table t_exam_question_upload (
   UploadId             int                  not null,
   SubmitId             int                  null,
   QuestionSeq          int                  null,
   FileName             varchar(32)          not null,
   FileSize             int                  null,
   FileType             varchar(32)          null,
   FileContent          image                null,
   constraint PK_T_EXAM_QUESTION_UPLOAD primary key  (UploadId)
)
go


/*==============================================================*/
/* Table: t_exam_submit                                         */
/*==============================================================*/
create table t_exam_submit (
   SubmitId             int                  not null,
   UserId               int                  not null,
   AssignmentId         int                  null,
   PaperId              int                  null,
   InstanceId           int                  not null,
   StartTime            datetime             null,
   SubmitTime           datetime             null,
   FeedBackTime         datetime             null,
   Mark                 int                  not null default -1,
   State                int                  null,
   FeedBack             varchar(255)         null,
   constraint PK_T_EXAM_SUBMIT primary key  (SubmitId)
)
go


/*==============================================================*/
/* Table: t_login_log                                           */
/*==============================================================*/
create table t_login_log (
   UserId               int                  not null,
   LoginTime            datetime             not null,
   LoginIP              varchar(16)          null,
   constraint PK_T_LOGIN_LOG primary key  (UserId, LoginTime)
)
go


/*==============================================================*/
/* Table: t_messages                                            */
/*==============================================================*/
create table t_messages (
   MessageId            int                  not null,
   UserId               int                  not null,
   MessageTo            int                  null,
   Topic                varchar(64)          null,
   Content              text                 null,
   MessageTime          datetime             null,
   IsNew                char(1)              not null default 'Y',
   MessageType          int                  null,
   SchoolId             char(4)              null,
   constraint PK_T_MESSAGES primary key  (MessageId)
)
go


/*==============================================================*/
/* Table: t_new_student                                         */
/*==============================================================*/
create table t_new_student (
   NewId                int                  not null,
   ClassId              int                  null,
   ClassName            varchar(128)         null,
   SchoolId             char(4)              not null,
   UserName             varchar(16)          not null,
   LoginName            varchar(16)          not null,
   LoginPassword        varchar(16)          not null,
   State                int                  not null default 1,
   Gender               char(2)              null,
   Nation               varchar(16)          null,
   Birthday             datetime             null,
   Education            varchar(8)           null,
   Address              varchar(64)          null,
   Zip                  char(6)              null,
   Phone                varchar(13)          null,
   Fax                  varchar(13)          null,
   Email                varchar(32)          null,
   Identification       varchar(18)          null,
   JoinTime             datetime             null,
   Creater              int                  null,
   Tag                  varchar(255)         null,
   UserId               int                  null,
   SubmitTime           datetime             null,
   Submitter            int                  null,
   constraint PK_T_NEW_STUDENT primary key  (NewId)
)
go