Ants企业费用管理数据库设计说明书编写:日期:审核:日期:数据库设计说明书Ants企业费用管理数据库设计说明书内部文档目录1引言..........................................................................................................................................41.1预期的读者......................................................................................................................41.2数据库..............................................................................................................................41.3目的和作用......................................................................................................................42数据库设计..............................................................................................................................42.1物理数据模型设计...........................................................................................................42.2表设计..............................................................................................................................42.2.1TableName(表名的解释)..........................................................................................42.3表之间的关联设计...........................................................................................................72.4存储过程设计..................................................................................................................72.5触发器设计......................................................................................................................7第2页共7页Ants企业费用管理数据库设计说明书内部文档1引言1.1数据库数据库管理系统Oracle版本信息:10g企业版。数据库IP地址:172.18.2.70端口号:1521Oracle_SID:orcl1.2目的和作用将数据分析的结果进一步整理,形成最终的计算机模型,以便数据库开发人员建立物理数据库,方便其他项目小组人员查阅参考。第3页共7页Ants企业费用管理数据库设计说明书内部文档2数据库设计2.1物理数据模型设计2.2表设计2.2.1TableName(表名的解释)第4页共7页FK_U_RoleFK_RC_CFK_RC_RFK_BC_BFK_R_UFK_R_BFK_BC_CFK_L_UFK_L_DFK_R_PFK_U_DFK_E_BUDGET_REFERENCE_E_USERFK_E_BUDGET_REFERENCE_E_PROCESE_USERuserIduserNumuserNamepasswordroleIddepartmentIdINTEGERVARCHAR(10)VARCHAR(50)VARCHAR(16)INTEGERINTEGER
E_ROLEroleIdroleNumroelNameINTEGERVARCHAR(10)VARCHAR(50)E_DEPARTMENTdepartmentIddepartmentNumdepartmentNameINTEGERVArRCHAR(10)VARCHAR(50)E_CHARGEchargeIdchargeNumchargeNameINTEGERVARCHAR(10)VARCHAR(50)E_BUDGETbudgetIduserIdprocessIdbudgetNamestartTimeendTimetotalAmount...INTEGERINTEGERINTEGERVARCHAR(50)DATEDATENUMBER(*,2)BudgetChargeidbudgetIdchargeIdamountINTEGERINTEGERINTEGERNUMBER(*,2)E_REIMreimIduserIdbudgetIdprocessIdreimTimetotalAmountreimDescoccurTimeusagepidstateINTEGERINTEGERINTEGERINTEGERDATENUMBER(*,2)VARCHAR(200)VARCHAR(20)VARCHAR(50)VARCHAR(10)INTEGERReimChargeidchargeIdreimIdamountspecINTEGERINTEGERINTEGERNUMBER(*,2)VARCHAR(200)E_LEADERiduserIddepartmentIdINTEGERINTEGERINTEGERE_PROCESSprocessIddefIddefNameverisonstatedeployIdINTEGERNUMBER(6)VARCHAR(50)VARCHAR(100)INTEGERVARCHARAnts企业费用管理数据库设计说明书内部文档表名:E_USER(用户表,员工表)字段名数据类型是否为空默认值备注userIdINTEGER否主键,表索引,自动生成userNumCAHR(10)否员工编号,由用户输入userNameVARCHARE(50)否用户姓名passwordV...