OA 办公自动化管理系统数据库设计说明书 内部文档
目 录
1 引言.................................................................................................................................................3
1.1 预期的读者............................................................................................................................3
1.2 数据库................................................................................................................................... 3
1.3 目的和作用............................................................................................................................3
2 数据字典设计.................................................................................................................................3
3 数据库设计...................................................................................................................................12
3.1 E-R 图..................................................................................................................................12
3.2 系统物理结构设计..............................................................................................................13
3.3 表设计................................................................................................................................. 14
3.3.1 OA_AllEmployees (
所有员工表
)....................................................................................14
3.3.2 OA_Department(
部门表
)................................................................................................15
3.3.3 OA_Position(
职位表
).....................................................................................................15
3.3.4 OA_Power(
权限表
)........................................................................................................15
3.3.5 OA_EmployeePower(
员工—权限表
)[
中间表
].............................................................16
3.3.6 OA_Announcement(
公告表
)...........................................................................................16
3.3.7 OA_AnnouncementRange(
公告范围表
)[
中间表
].........................................................16
3.3.8 OA_AskForLeave(
请假表
).............................................................................................16
3.3.9 OA_Reimburse(
报销表
)..................................................................................................17
3.3.10 BaseInfo(
基本信息表
) [
数据字典表
][
表级多语言扩展
]..........................................17
3.4 表之间的关联设计..............................................................................................................18
3.5 存储过程设计......................................................................................................................18
3.6 触发器设计..........................................................................................................................19
第 2 页 共 21 页
