系统数据结构设计(概要).doc

5系统数据结构设计5.1逻辑结构设计要点任务基本信息表字段名数据类型长度（字节）ProjectBuliderChar10ProjectCodeChar12ProjectNameChar10ProJectTypeChar10JoinDepartChar20ProjectTimeChar10ProjectDescribleChar10ProjectSelecteManChar19ExameManChar10任务成员信息表ProjectManagerChar10ProjectDevelopperChar10QAManChar10TestManChar10项目预算成本表TravleFeeChar10ExtenWorkChar10ScolarChar10TotalChar10项目任务表字段名数据类型长度（字节）ProjectCodeChar12ProjectNameChar10ProJectExcuterChar10BeforeProJectChar20DependentChar20ProjectTimeChar10ProjectHourChar10ProjectDescribleChar10ProjectClassChar10ProjectLiChengBeiChar10Remarkschar500ProjectFlowChar10任务审批表字段名数据类型长度（字节）SelectionChar10ProjectCodeChar12ProjectNameChar10ApplymentChar10StartDateChar10ProjectHourChar10EndDateChar10OperationChar10任务执行表字段名数据类型长度（字节）SelectionChar10ProjectCodeChar12ProjectNameChar10AccepterChar10StartDateChar10EndDate(Plan)Char10EndDate(Fact)Char10StatusChar10OperationChar10我的任务表字段名数据类型长度（字节）ProjectCodeChar12ProjectNameChar10MyTaskChar10StartDateChar10ProjectHourChar10EndDateChar10OperationChar10任务详情表字段名数据类型长度（字节）ProjectManageChar12textChar500AddtionChar10LogTimeChar10PrecentChar10OperationChar10任务问题表字段名数据类型长度（字节）ProblemNameChar12ProperityChar10ProblemDescribleChar500HadlerChar10EndHadleDateChar10AddtionTextChar10ReHadlerChar10AddtionSelectChar10任务处理表字段名数据类型长度（字节）ProjectNameChar12ProblemNameChar12AskerChar10HadleLineChar10ProperityChar10EndHadleDateChar10StatusChar10OperationChar105.2物理结构设计要点本系统内