createwebedutables.sql

采用Eclispe开发平台

/*==============================================================*/
/* Table: t_question                                            */
/*==============================================================*/
create table t_question (
   QuestionId           int                  not null,
   CourseId             int                  null,
   QuestionType         int                  not null,
   ExamType             int                  null,
   Unit                 int                  null default 0,
   Chapter              int                  not null default -1,
   Section              int                  not null default -1,
   UBBContent           text                 null,
   Content              text                 not null,
   Answer               text                 null,
   EntranceFileName     varchar(32)          null,
   UsageLimit           int                  null,
   UsageCounter         int                  null,
   TimeLimit            int                  null,
   Factor               int                  null,
   ReferenceUrl         varchar(255)         null,
   LastUpdate           datetime             null,
   TeacherId            char(10)             null,
   Tag                  varchar(255)         null,
   constraint PK_T_QUESTION primary key  (QuestionId)
)
go


/*==============================================================*/
/* Table: t_question_choice                                     */
/*==============================================================*/
create table t_question_choice (
   QuestionId           int                  not null,
   ChoiceId             int                  not null,
   ChoiceContent        varchar(255)         not null,
   IsAnswer             char(1)              null,
   constraint PK_T_QUESTION_CHOICE primary key  (QuestionId, ChoiceId)
)
go


/*==============================================================*/
/* Table: t_question_file                                       */
/*==============================================================*/
create table t_question_file (
   QuestionId           int                  not null,
   FileId               int                  not null,
   FileName             varchar(64)          not null,
   FileType             varchar(64)          null,
   FileSize             int                  null,
   FileContent          image                null,
   constraint PK_T_QUESTION_FILE primary key  (FileId)
)
go


/*==============================================================*/
/* Table: t_question_point                                      */
/*==============================================================*/
create table t_question_point (
   QuestionId           int                  not null,
   PointId              int                  not null,
   PointContent         varchar(64)          not null,
   Mark                 int                  null,
   constraint PK_T_QUESTION_POINT primary key  (QuestionId, PointId)
)
go


/*==============================================================*/
/* Table: t_school                                              */
/*==============================================================*/
create table t_school (
   SchoolId             char(4)              not null,
   SchoolName           varchar(128)         not null,
   State                int                  null,
   Province             varchar(18)          null,
   City                 varchar(16)          null,
   JoinType             int                  null,
   ContractNumber       varchar(32)          null,
   ContractDate         datetime             null,
   ValidityEnd          datetime             null,
   JuridicalPerson      varchar(16)          null,
   ContactPerson        varchar(16)          null,
   CorrespondenceAddress varchar(128)         null,
   ContractPlace        varchar(16)          null,
   Director             varchar(16)          null,
   TechnicalPrincipal   varchar(16)          null,
   MarketPrinciple      varchar(16)          null,
   EmplopymentPrinciple varchar(16)          null,
   RecruitTelephone     varchar(13)          null,
   Email                varchar(32)          null,
   WebSite              varchar(32)          null,
   BriefIntroduction    varchar(255)         null,
   Tag                  varchar(255)         null,
   constraint PK_T_SCHOOL primary key  (SchoolId)
)
go


/*==============================================================*/
/* Table: t_student                                             */
/*==============================================================*/
create table t_student (
   UserId               int                  not null,
   ClassId              int                  null default 0,
   University           varchar(32)          null,
   GraduationDate       datetime             null,
   Major                varchar(16)          null,
   Profession           varchar(8)           null,
   EnglishLevel         varchar(16)          null,
   EnglishTraining      varchar(255)         null,
   SoftwareLevel        varchar(16)          null,
   SoftwareTraining     varchar(255)         null,
   IsProgram            char(1)              null,
   ProjectManagement    varchar(128)         null,
   Hardware             varchar(128)         null,
   Software             varchar(128)         null,
   SystemProgram        varchar(128)         null,
   Network              varchar(128)         null,
   System               varchar(128)         null,
   Computer             varchar(128)         null,
   OS                   varchar(128)         null,
   DatabaseSkill        varchar(128)         null,
   ProgramLanguage      varchar(128)         null,
   Mark                 int                  null,
   Political            varchar(16)          null,
   StrongSuit           varchar(32)          null,
   NeedDorm             char(1)              null,
   Certification        varchar(32)          null,
   IsReceiveInfo        char(1)              null,
   IsPublic             char(1)              null,
   constraint PK_T_STUDENT primary key  (UserId)
)
go


/*==============================================================*/
/* Table: t_student_course                                      */
/*==============================================================*/
create table t_student_course (
   UserId               int                  not null,
   CourseId             int                  not null,
   State                int                  not null,
   constraint PK_T_STUDENT_COURSE primary key  (UserId, CourseId)
)
go


/*==============================================================*/
/* Table: t_teacher                                             */
/*==============================================================*/
create table t_teacher (
   UserId               int                  not null,
   Major                varchar(16)          null,
   Political            varchar(8)           null,
   TechnicalPost        varchar(8)           null,
   Specialty            varchar(16)          null,
   Education            varchar(8)           null,
   EListen              int                  null,
   ESpeak               int                  null,
   ERead                int                  null,
   EWrite               int                  null,
   Experience           varchar(32)          null,
   Program              varchar(255)         null,
   Paper                varchar(255)         null,
   Others               varchar(255)         null,
   constraint PK_T_TEACHER primary key  (UserId)
)
go


/*==============================================================*/
/* Table: t_teacher_award                                       */
/*==============================================================*/
create table t_teacher_award (
   TeacherAwardId       int                  not null,
   UserId               int                  null,
   AwardName            varchar(64)          null,
   Tag                  varchar(255)         null,
   AwardDate            datetime             null,
   constraint PK_T_TEACHER_AWARD primary key  (TeacherAwardId)
)
go


/*==============================================================*/
/* Table: t_teacher_evaluation                                  */
/*==============================================================*/
create table t_teacher_evaluation (
   TeacherEvaluationId  int                  not null,
   UserId               int                  not null,
   Mentor               varchar(16)          not null,
   EvaluationTime       datetime             not null,
   Content              text                 null,
   constraint PK_T_TEACHER_EVALUATION primary key  (TeacherEvaluationId)
)
go


/*==============================================================*/
/* Table: t_teacher_exam                                        */
/*==============================================================*/
create table t_teacher_exam (
   TeacherExamId        int                  not null,
   UserId               int                  null,
   ExamName             varchar(32)          null,
   ExamDate             datetime             null,
   ExamContent          varchar(255)         null,
   Mark                 int                  null,
   Tag                  varchar(255)         null,
   constraint PK_T_TEACHER_EXAM primary key  (TeacherExamId)
)
go


/*==============================================================*/
/* Table: t_teacher_log                                         */
/*==============================================================*/
create table t_teacher_log (
   TeacherLogId         int                  not null,
   UserId               int                  null,
   CourseName           varchar(32)          null,
   ClassName            varchar(32)          null,
   StartDate            datetime             null,
   EndDate              datetime             null,
   PlannedDuration      int                  null,
   Duration             int                  null,
   Place                varchar(32)          null,
   Tag                  varchar(255)         null,
   constraint PK_T_TEACHER_LOG primary key  (TeacherLogId)
)
go


/*==============================================================*/
/* Table: t_teacher_training                                    */
/*==============================================================*/
create table t_teacher_training (
   TeacherTrainingId    int                  not null,
   UserId               int                  not null,
   TrainingName         varchar(64)          null,
   TrainingDate         datetime             null,
   TrainingPlace        varchar(64)          null,
   TrainingContent      varchar(255)         null,
   Mark                 int                  null,
   Tag                  varchar(255)         null,
   constraint PK_T_TEACHER_TRAINING primary key  (TeacherTrainingId)
)
go


/*==============================================================*/
/* Table: t_user                                                */
/*==============================================================*/
create table t_user (
   UserId               int                  not null,
   SchoolId             char(4)              not null,
   UserName             varchar(16)          not null,
   LoginName            varchar(16)          not null,
   LoginPassword        varchar(16)          not null,
   NeedChangePassword   char(1)              not null default 'Y',
   State                int                  not null default 1,
   Gender               char(2)              not null,
   UserType             int                  not 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,
   LeaveTime            datetime             null,
   Deleter              int                  null,
   Tag                  varchar(255)         null,
   constraint PK_T_USER primary key  (UserId)
)
go


/*==============================================================*/
/* Index: LoginName_AK                                          */
/*==============================================================*/
create unique  index LoginName_AK on t_user (
LoginName
)
go