开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
西部信托数据库设计.DDL
资源名称：OA.rar　[点击查看]
上传用户：mingda
上传日期：2017-06-20
资源大小：27691k
文件大小：100k
源码类别：

OA系统

开发平台：

Java

西部信托数据库设计.DDL：源码内容
  1. /*    此 SQL DDL 脚本由 Microsoft Visual Studio（发布日期:LOCAL BUILD）生成。                              */
  3. /*    所用驱动程序：Microsoft Visual Studio － Microsoft SQL Server 驱动程序。                             */
  4. /*    文档：E:HomePageWestTI_OAdoc西部信托数据库设计.vsd。                                             */
  5. /*    创建时间：2003年12月1日 9:46。                                                                   */
  6. /*    操作：来自 Visio 生成向导。                                                                       */
  7. /*    已连接的数据源：没有连接。                                                                           */
  8. /*    已连接的服务器：没有连接。                                                                           */
  9. /*    已连接的数据库：不适用。                                                                            */
  13. /* 创建 WestTI_OA 数据库。                                                                          */
  14. use master  
  16. go
  18. create database "WestTI_OA"  
  20. go
  22. use "WestTI_OA"  
  24. go
  26. /* 创建新表 "ApproveRecordInfo"。                                                                  */
  27. /* "ApproveRecordInfo" : Table of 审批记录信息表                                                     */
  28. /*  "ID" : ID 标识 审批记录信息表                                                                      */
  29. /*  "FlowTacheID" : 流程环节ID 属于 审批记录信息表                                                         */
  30. /*  "DocumentID" : 公文ID 属于 审批记录信息表                                                            */
  31. /*  "ApproveUserID" : 审批用户ID 属于 审批记录信息表                                                       */
  32. /*  "ApproveTime" : 审批时间 属于 审批记录信息表                                                           */
  33. /*  "ApproveFromIP" : 审批来源IP地址 属于 审批记录信息表                                                     */
  34. /*  "IsRead" : 是否查阅 属于 审批记录信息表                                                                */  
  35. create table "ApproveRecordInfo" ( 
  36. "ID" int identity not null,
  37. "FlowTacheID" int null,
  38. "DocumentID" int null,
  39. "ApproveUserID" int null,
  40. "ApproveTime" datetime null,
  41. "ApproveFromIP" varchar(300) null,
  42. "IsRead" varchar(300) null)  
  44. go
  46. alter table "ApproveRecordInfo"
  47. add constraint "ApproveRecordInfo_PK" primary key ("ID")   
  50. go
  52. /* 创建新表 "DocFieldsValue"。                                                                     */
  53. /* "DocFieldsValue" : Table of 公文字段值信息表                                                       */
  54. /*  "ID" : ID 标识 公文字段值信息表                                                                     */
  55. /*  "DocumentID" : 公文ID 部分标识 公文字段值信息表                                                         */
  56. /*  "DocTempletFieldsID" : 公文模板字段ID 属于 公文字段值信息表                                               */
  57. /*  "FieldValue" : 字段值 属于 公文字段值信息表                                                            */
  58. /*  "ApproveFlowID" : 审批流程记录ID 属于 公文字段值信息表                                                    */  
  59. create table "DocFieldsValue" ( 
  60. "ID" int identity not null,
  61. "DocumentID" int null,
  62. "DocTempletFieldsID" int null,
  63. "FieldValue" varchar(8000) null,
  64. "ApproveFlowID" int null)  
  66. go
  68. alter table "DocFieldsValue"
  69. add constraint "DocFieldsValue_PK" primary key ("ID")   
  72. go
  74. /* 创建新表 "Document"。                                                                           */
  75. /* "Document" : Table of 公文报表信息表                                                              */
  76. /*  "ID" : ID 标识 公文报表信息表                                                                      */
  77. /*  "DocumentName" : 公文名称 属于 公文报表信息表                                                          */
  78. /*  "DocFlowTempletID" : 公文流转模板ID 属于 公文报表信息表                                                  */
  79. /*  "BuildTime" : 生成时间 属于 公文报表信息表                                                             */
  80. /*  "BuildUserID" : 生成用户ID 属于 公文报表信息表                                                         */
  81. /*  "FillUserID" : 填表用户ID 属于 公文报表信息表                                                          */
  82. /*  "IsPigeonholed" : 是否已经归档 属于 公文报表信息表                                                       */
  83. /*  "CurrentFlowTacheID" : 当前流程环节ID 属于 公文报表信息表                                                */
  84. /*  "IsReminded" : 是否已经提醒 属于 公文报表信息表                                                          */
  85. /*  "RemindTime" : 提醒时间 属于 公文报表信息表                                                            */  
  86. create table "Document" ( 
  87. "ID" int identity not null,
  88. "DocumentName" varchar(300) null,
  89. "DocFlowTempletID" int null,
  90. "BuildTime" datetime null,
  91. "BuildUserID" int null,
  92. "FillUserID" int null,
  93. "IsPigeonholed" bit null,
  94. "CurrentFlowTacheID" int null,
  95. "IsReminded" bit null,
  96. "RemindTime" datetime null)  
  98. go
  100. alter table "Document"
  101. add constraint "Document_PK" primary key ("ID")   
  104. go
  106. /* 创建新表 "DocTempletMoveFlow"。                                                                 */
  107. /* "DocTempletMoveFlow" : Table of 公文流转模板信息表                                                  */
  108. /*  "ID" : ID 标识 公文流转模板信息表                                                                    */
  109. /*  "Name" : 公文流转模板名称 属于 公文流转模板信息表                                                            */
  110. /*  "DocTempletID" : 公文模板ID 属于 公文流转模板信息表                                                      */
  111. /*  "DocTempletTableName" : 公文模板表名称 属于 公文流转模板信息表                                              */
  112. /*  "MoveFlowID" : 流转流程ID 属于 公文流转模板信息表                                                        */
  113. /*  "UpdateUserID" : 更新用户ID 属于 公文流转模板信息表                                                      */
  114. /*  "UpdateTime" : 更新时间 属于 公文流转模板信息表                                                          */
  115. /*  "UpdateFromIP" : 更新来自IP地址 属于 公文流转模板信息表                                                    */
  116. /*  "ApproveUserID" : 审核用户ID 属于 公文流转模板信息表                                                     */
  117. /*  "ApproveTime" : 审核时间 属于 公文流转模板信息表                                                         */
  118. /*  "StopUseTime" : 停用时间 属于 公文流转模板信息表                                                         */
  119. /*  "StarUseTime" : 启用时间 属于 公文流转模板信息表                                                         */
  120. /*  "IsUseful" : 是否可用 属于 公文流转模板信息表                                                            */
  121. /*  "WritableUserIDs" : 可写用户IDs 属于 公文流转模板信息表                                                  */
  122. /*  "WritableDepartIDs" : 可写部门IDs 属于 公文流转模板信息表                                                */
  123. /*  "ReadOnlyUserIDs" : 只读用户IDs 属于 公文流转模板信息表                                                  */
  124. /*  "ReadOnlyDepartIDs" : 只读部门IDs 属于 公文流转模板信息表                                                */  
  125. create table "DocTempletMoveFlow" ( 
  126. "ID" int identity not null,
  127. "Name" varchar(300) null,
  128. "DocTempletID" int null,
  129. "DocTempletTableName" varchar(300) null,
  130. "MoveFlowID" int null,
  131. "UpdateUserID" int null,
  132. "UpdateTime" datetime null,
  133. "UpdateFromIP" varchar(300) null,
  134. "ApproveUserID" int null,
  135. "ApproveTime" datetime null,
  136. "StopUseTime" datetime null,
  137. "StarUseTime" datetime null,
  138. "IsUseful" bit null,
  139. "WritableUserIDs" varchar(300) null,
  140. "WritableDepartIDs" varchar(300) null,
  141. "ReadOnlyUserIDs" varchar(300) null,
  142. "ReadOnlyDepartIDs" varchar(300) null)  
  144. go
  146. alter table "DocTempletMoveFlow"
  147. add constraint "DocTempletMoveFlow_PK" primary key ("ID")   
  150. go
  152. /* 创建新表 "FlowTacheInfo"。                                                                      */
  153. /* "FlowTacheInfo" : Table of 流程环节信息表                                                         */
  154. /*  "ID" : ID 标识 流程环节信息表                                                                      */
  155. /*  "TacheName" : 环节名称 属于 流程环节信息表                                                             */
  156. /*  "FromTacheID" : 来自环节ID 属于 流程环节信息表                                                         */
  157. /*  "TacheStatus" : 环节状态 属于 流程环节信息表                                                           */
  158. /*  "TacheDescription" : 环节描述 属于 流程环节信息表                                                      */
  159. /*  "ApproveUserIDs" : 审批用户IDs 属于 流程环节信息表                                                     */
  160. /*  "TacheType" : 环节类型 属于 流程环节信息表                                                             */
  161. /*  "FlowID" : 流程ID 属于 流程环节信息表                                                                */
  162. /*  "UpdateUserID" : 更新用户ID 属于 流程环节信息表                                                        */
  163. /*  "UpdateTime" : 更新时间 属于 流程环节信息表                                                            */
  164. /*  "UpdateFromIP" : 更新来源IP地址 属于 流程环节信息表                                                      */
  165. /*  "IsRecordRead" : 是否记录查阅 属于 流程环节信息表                                                        */
  166. /*  "RemindInterval" : 提醒时间间隔 属于 流程环节信息表                                                      */
  167. /*  "MaxWaitTime" : 最大停留时间 属于 流程环节信息表                                                         */
  168. /*  "IsFromDefault" : 是否环节默认 属于 流程环节信息表                                                       */
  169. /*  "IsFinishedByRead" : 查阅是否自动完成该环节 属于 流程环节信息表                                               */  
  170. create table "FlowTacheInfo" ( 
  171. "ID" int identity not null,
  172. "TacheName" varchar(300) null,
  173. "FromTacheID" varchar(300) null,
  174. "TacheStatus" varchar(300) null,
  175. "TacheDescription" varchar(300) null,
  176. "ApproveUserIDs" varchar(300) null,
  177. "TacheType" varchar(300) null,
  178. "FlowID" int null,
  179. "UpdateUserID" int null,
  180. "UpdateTime" datetime null,
  181. "UpdateFromIP" varchar(300) null,
  182. "IsRecordRead" bit null,
  183. "RemindInterval" int null,
  184. "MaxWaitTime" int null,
  185. "IsFromDefault" bit null,
  186. "IsFinishedByRead" bit null)  
  188. go
  190. alter table "FlowTacheInfo"
  191. add constraint "FlowTacheInfo_PK" primary key ("ID")   
  194. go
  196. /* 创建新表 "MoveFlowInfo"。                                                                       */
  197. /* "MoveFlowInfo" : Table of 流转流程信息表                                                          */
  198. /*  "ID" : ID 标识 流转流程信息表                                                                      */
  199. /*  "FlowName" : 流程名称 属于 流转流程信息表                                                              */
  200. /*  "BuildTime" : 创建时间 属于 流转流程信息表                                                             */
  201. /*  "BuildUserID" : 创建用户ID 属于 流转流程信息表                                                         */
  202. /*  "FlowContent" : 流程说明 属于 流转流程信息表                                                           */
  203. /*  "WritableUserIDs" : 可写用户IDs 属于 流转流程信息表                                                    */
  204. /*  "WritableDepartIDs" : 可写部门IDs 属于 流转流程信息表                                                  */  
  205. create table "MoveFlowInfo" ( 
  206. "ID" int identity not null,
  207. "FlowName" varchar(300) null,
  208. "BuildTime" datetime null,
  209. "BuildUserID" int null,
  210. "FlowContent" varchar(600) null,
  211. "WritableUserIDs" varchar(300) null,
  212. "WritableDepartIDs" varchar(300) null)  
  214. go
  216. alter table "MoveFlowInfo"
  217. add constraint "MoveFlowInfo_PK" primary key ("ID")   
  220. go
  222. /* 创建新表 "DocTempletFields"。                                                                   */
  223. /* "DocTempletFields" : Table of 公文模板字段信息表                                                    */
  224. /*  "ID" : ID 标识 公文模板字段信息表                                                                    */
  225. /*  "FieldName" : 字段名称 属于 公文模板字段信息表                                                           */
  226. /*  "FieldType" : 字段类型 属于 公文模板字段信息表                                                           */
  227. /*  "EnglishAb" : 英文缩写 属于 公文模板字段信息表                                                           */
  228. /*  "OrderNumber" : 排序编号 属于 公文模板字段信息表                                                         */
  229. /*  "Event" : 激活事件 属于 公文模板字段信息表                                                               */
  230. /*  "Options" : 选项内容 属于 公文模板字段信息表                                                             */
  231. /*  "FieldContent" : 字段填写说明 属于 公文模板字段信息表                                                      */
  232. /*  "IsMustFill" : 是否必须填写 属于 公文模板字段信息表                                                        */
  233. /*  "WritableUserIDs" : 可写用户IDs 属于 公文模板字段信息表                                                  */
  234. /*  "ReadableUserIDs" : 可读用户IDs 属于 公文模板字段信息表                                                  */
  235. /*  "IsUseful" : 是否可用 属于 公文模板字段信息表                                                            */
  236. /*  "SearchType" : 搜索类型 属于 公文模板字段信息表                                                          */
  237. /*  "SearchFieldsInForm" : 搜索对应字段 属于 公文模板字段信息表                                                */
  238. /*  "TempletID" : 模板ID 属于 公文模板字段信息表                                                           */
  239. /*  "MaxLength" : 字段最大长度 属于 公文模板字段信息表                                                         */
  240. /*  "DefaultValue" : 默认值 属于 公文模板字段信息表                                                         */  
  241. create table "DocTempletFields" ( 
  242. "ID" int identity not null,
  243. "FieldName" varchar(300) null,
  244. "FieldType" varchar(300) null,
  245. "EnglishAb" varchar(300) null,
  246. "OrderNumber" int null,
  247. "Event" varchar(300) null,
  248. "Options" varchar(600) null,
  249. "FieldContent" varchar(300) null,
  250. "IsMustFill" bit null,
  251. "WritableUserIDs" varchar(300) null,
  252. "ReadableUserIDs" varchar(300) null,
  253. "IsUseful" bit null,
  254. "SearchType" varchar(300) null,
  255. "SearchFieldsInForm" varchar(300) null,
  256. "TempletID" int null,
  257. "MaxLength" int null,
  258. "DefaultValue" varchar(300) null)  
  260. go
  262. alter table "DocTempletFields"
  263. add constraint "DocTempletFields_PK" primary key ("ID")   
  266. go
  268. /* 创建新表 "DocumentTemplet"。                                                                    */
  269. /* "DocumentTemplet" : Table of 公文模板信息表                                                       */
  270. /*  "ID" : ID 标识 公文模板信息表                                                                      */
  271. /*  "TempletName" : 模板名称 属于 公文模板信息表                                                           */
  272. /*  "BuildTime" : 模板创建时间 属于 公文模板信息表                                                           */
  273. /*  "BuildUserID" : 创建用户ID 属于 公文模板信息表                                                         */
  274. /*  "TempletNumber" : 模板编号 属于 公文模板信息表                                                         */
  275. /*  "EnglishAb" : 英文缩写 属于 公文模板信息表                                                             */
  276. /*  "WritableUserIDs" : 可写用户IDs 属于 公文模板信息表                                                    */
  277. /*  "WritableDepartIDs" : 可写部门IDs 属于 公文模板信息表                                                  */
  278. /*  "ReadOnlyUserIDs" : 只读用户IDs 属于 公文模板信息表                                                    */
  279. /*  "ReadOnlyDeprtIDs" : 只读部门IDs 属于 公文模板信息表                                                   */
  280. /*  "PrintHTMLCode" : 打印HTML代码 属于 公文模板信息表                                                     */
  281. /*  "SysDirID" : 系统目录ID 属于 公文模板信息表                                                            */
  282. /*  "IsAutoBuild" : 是否自动生成 属于 公文模板信息表                                                         */
  283. /*  "TypesetHTMLCode" : 排版格式HTML代码 属于 公文模板信息表                                                 */
  284. /*  "FormEvent" : 表单事件 属于 公文模板信息表                                                             */
  285. /*  "JavaScriptCode" : 嵌套JavaScript代码 属于 公文模板信息表                                              */  
  286. create table "DocumentTemplet" ( 
  287. "ID" int identity not null,
  288. "TempletName" varchar(300) null,
  289. "BuildTime" datetime null,
  290. "BuildUserID" int null,
  291. "TempletNumber" varchar(300) null,
  292. "EnglishAb" varchar(300) null,
  293. "WritableUserIDs" varchar(300) null,
  294. "WritableDepartIDs" varchar(300) null,
  295. "ReadOnlyUserIDs" varchar(300) null,
  296. "ReadOnlyDeprtIDs" varchar(300) null,
  297. "PrintHTMLCode" text null,
  298. "SysDirID" int null,
  299. "IsAutoBuild" bit null,
  300. "TypesetHTMLCode" text null,
  301. "FormEvent" varchar(300) null,
  302. "JavaScriptCode" text null)  
  304. go
  306. alter table "DocumentTemplet"
  307. add constraint "DocumentTemplet_PK" primary key ("ID")   
  310. go
  312. /* 创建新表 "PactInfo"。                                                                           */
  313. /* "PactInfo" : Table of 合同信息表                                                                */
  314. /*  "ID" : ID 标识 合同信息表                                                                        */
  315. /*  "PactNumber" : 合同编号 属于 合同信息表                                                              */
  316. /*  "IntrustFund" : 信托资金 属于 合同信息表                                                             */
  317. /*  "PactTermStart" : 合同期限开始时间 属于 合同信息表                                                       */
  318. /*  "PactTermEnd" : 合同期限结束时间 属于 合同信息表                                                         */
  319. /*  "FirstSideName" : 甲方名称 属于 合同信息表                                                           */
  320. /*  "FirstSideIDCardNumber" : 甲方身份证或营业执照 属于 合同信息表                                             */
  321. /*  "FirstSideCorporation" : 甲方法定代表人 属于 合同信息表                                                 */
  322. /*  "FirstSideAddress" : 甲方地址 属于 合同信息表                                                        */
  323. /*  "FirstSideTel" : 甲方电话 属于 合同信息表                                                            */
  324. /*  "FirstSideDeputy" : 甲方代理人 属于 合同信息表                                                        */
  325. /*  "FirstSideSignTime" : 甲方签字日期 属于 合同信息表                                                     */
  326. /*  "SecondSideName" : 乙方名称 属于 合同信息表                                                          */
  327. /*  "SecondSideIDCardNumber" : 乙方身份证或者营业执照 属于 合同信息表                                           */
  328. /*  "SecondSideCorporation" : 乙方法定代表人 属于 合同信息表                                                */
  329. /*  "SecondSideAddress" : 乙方地址 属于 合同信息表                                                       */
  330. /*  "SecondSideTel" : 乙方电话 属于 合同信息表                                                           */
  331. /*  "SecondSideDeputy" : 乙方代理人 属于 合同信息表                                                       */
  332. /*  "SecondSideSignTime" : 乙方签字日期 属于 合同信息表                                                    */
  333. /*  "PactTitle" : 合同标题 属于 合同信息表                                                               */
  334. /*  "PactContent" : 合同内容 属于 合同信息表                                                             */
  335. /*  "AddTime" : 增加时间 属于 合同信息表                                                                 */
  336. /*  "AddUserID" : 增加用户ID 属于 合同信息表                                                             */  
  337. create table "PactInfo" ( 
  338. "ID" int identity not null,
  339. "PactNumber" varchar(60) null,
  340. "IntrustFund" money null,
  341. "PactTermStart" datetime null,
  342. "PactTermEnd" datetime null,
  343. "FirstSideName" varchar(160) null,
  344. "FirstSideIDCardNumber" varchar(60) null,
  345. "FirstSideCorporation" varchar(60) null,
  346. "FirstSideAddress" varchar(160) null,
  347. "FirstSideTel" varchar(60) null,
  348. "FirstSideDeputy" varchar(60) null,
  349. "FirstSideSignTime" datetime null,
  350. "SecondSideName" varchar(160) null,
  351. "SecondSideIDCardNumber" varchar(60) null,
  352. "SecondSideCorporation" varchar(60) null,
  353. "SecondSideAddress" varchar(160) null,
  354. "SecondSideTel" varchar(60) null,
  355. "SecondSideDeputy" varchar(60) null,
  356. "SecondSideSignTime" datetime null,
  357. "PactTitle" varchar(160) null,
  358. "PactContent" text null,
  359. "AddTime" datetime null,
  360. "AddUserID" int null)  
  362. go
  364. alter table "PactInfo"
  365. add constraint "PactInfo_PK" primary key ("ID")   
  368. go
  370. /* 创建新表 "PactTempletInfo"。                                                                    */
  371. /* "PactTempletInfo" : Table of 合同模板信息表                                                       */
  372. /*  "ID" : ID 标识 合同模板信息表                                                                      */
  373. /*  "TempletName" : 模版名称 属于 合同模板信息表                                                           */
  374. /*  "TempletContent" : 模板内容 属于 合同模板信息表                                                        */
  375. /*  "BuildTime" : 建立时间 属于 合同模板信息表                                                             */
  376. /*  "BuildUserID" : 建立用户ID 属于 合同模板信息表                                                         */
  377. /*  "PactType" : 合同类型 属于 合同模板信息表                                                              */  
  378. create table "PactTempletInfo" ( 
  379. "ID" int identity not null,
  380. "TempletName" varchar(60) null,
  381. "TempletContent" text null,
  382. "BuildTime" datetime null,
  383. "BuildUserID" int null,
  384. "PactType" int null)  
  386. go
  388. alter table "PactTempletInfo"
  389. add constraint "PactTempletInfo_PK" primary key ("ID")   
  392. go
  394. /* 创建新表 "CahierInfo"。                                                                         */
  395. /* "CahierInfo" : Table of 会议记录信息表                                                            */
  396. /*  "ID" : ID 标识 会议记录信息表                                                                      */
  397. /*  "BoardroomApplyID" : 会议申请ID 属于 会议记录信息表                                                    */
  398. /*  "MeetingNumber" : 会议编号 属于 会议记录信息表                                                         */
  399. /*  "MeetingName" : 会议名称 属于 会议记录信息表                                                           */
  400. /*  "StartTime" : 开始时间 属于 会议记录信息表                                                             */
  401. /*  "EndTime" : 结束时间 属于 会议记录信息表                                                               */
  402. /*  "Compere" : 主持人 属于 会议记录信息表                                                                */
  403. /*  "MeetingContent" : 会议说明 属于 会议记录信息表                                                        */
  404. /*  "BoardroomID" : 会议室ID 属于 会议记录信息表                                                          */
  405. /*  "ConfereePersonnel" : 参会人员 属于 会议记录信息表                                                     */
  406. /*  "NoteUserID" : 笔记用户ID 属于 会议记录信息表                                                          */
  407. /*  "SummaryTitle" : 纪要主题 属于 会议记录信息表                                                          */
  408. /*  "SummaryContent" : 会议纪要内容 属于 会议记录信息表                                                      */
  409. /*  "AllowableUserIDs" : 允许察看的用户ID 属于 会议记录信息表                                                 */
  410. /*  "AllowableDepartIDs" : 允许察看的部门 属于 会议记录信息表                                                 */  
  411. create table "CahierInfo" ( 
  412. "ID" int identity not null,
  413. "BoardroomApplyID" int null,
  414. "MeetingNumber" varchar(60) null,
  415. "MeetingName" varchar(60) null,
  416. "StartTime" datetime null,
  417. "EndTime" datetime null,
  418. "Compere" varchar(60) null,
  419. "MeetingContent" varchar(200) null,
  420. "BoardroomID" int null,
  421. "ConfereePersonnel" varchar(300) null,
  422. "NoteUserID" int null,
  423. "SummaryTitle" varchar(60) null,
  424. "SummaryContent" text null,
  425. "AllowableUserIDs" varchar(300) null,
  426. "AllowableDepartIDs" varchar(200) null)  
  428. go
  430. alter table "CahierInfo"
  431. add constraint "CahierInfo_PK" primary key ("ID")   
  434. go
  436. /* 创建新表 "BoardroomApplyInfo"。                                                                 */
  437. /* "BoardroomApplyInfo" : Table of 会议室申请信息表                                                   */
  438. /*  "ID" : ID 标识 会议室申请信息表                                                                     */
  439. /*  "Title" : 会议主题 属于 会议室申请信息表                                                                */
  440. /*  "PlanStartTime" : 预计开始时间 属于 会议室申请信息表                                                      */
  441. /*  "PlanEndTime" : 预计结束时间 属于 会议室申请信息表                                                        */
  442. /*  "ApplyUserID" : 申请用户ID 属于 会议室申请信息表                                                        */
  443. /*  "ApplyTime" : 申请时间 属于 会议室申请信息表                                                            */
  444. /*  "IsConfirmed" : 是否批准 属于 会议室申请信息表                                                          */
  445. /*  "ConfirmUserID" : 批准用户ID 属于 会议室申请信息表                                                      */
  446. /*  "ConfirmTime" : 批准时间 属于 会议室申请信息表                                                          */
  447. /*  "ConfirmInfo" : 批准信息 属于 会议室申请信息表                                                          */
  448. /*  "BoardroomID" : 会议室ID 属于 会议室申请信息表                                                         */
  449. /*  "PersonnelAmount" : 参会人数 属于 会议室申请信息表                                                      */  
  450. create table "BoardroomApplyInfo" ( 
  451. "ID" int identity not null,
  452. "Title" varchar(200) null,
  453. "PlanStartTime" datetime null,
  454. "PlanEndTime" datetime null,
  455. "ApplyUserID" int null,
  456. "ApplyTime" datetime null,
  457. "IsConfirmed" bit null,
  458. "ConfirmUserID" int null,
  459. "ConfirmTime" datetime null,
  460. "ConfirmInfo" varchar(200) null,
  461. "BoardroomID" int null,
  462. "PersonnelAmount" int null)  
  464. go
  466. alter table "BoardroomApplyInfo"
  467. add constraint "BoardroomApplyInfo_PK" primary key ("ID")   
  470. go
  472. /* 创建新表 "BoardroomInfo"。                                                                      */
  473. /* "BoardroomInfo" : Table of 会议室信息表                                                          */
  474. /*  "ID" : ID 标识 会议室信息表                                                                       */
  475. /*  "BoardroomName" : 会议室名称 属于 会议室信息表                                                         */
  476. /*  "BoardroomNumber" : 会议室编号 属于 会议室信息表                                                       */
  477. /*  "Address" : 会议室地址 属于 会议室信息表                                                               */
  478. /*  "PersonnelAmount" : 容纳人数 属于 会议室信息表                                                        */
  479. /*  "IsUseful" : 是否可用 属于 会议室信息表                                                               */
  480. /*  "State" : 状态 属于 会议室信息表                                                                    */  
  481. create table "BoardroomInfo" ( 
  482. "ID" int identity not null,
  483. "BoardroomName" varchar(60) null,
  484. "BoardroomNumber" varchar(60) null,
  485. "Address" varchar(60) null,
  486. "PersonnelAmount" int null,
  487. "IsUseful" bit null,
  488. "State" varchar(60) null)  
  490. go
  492. alter table "BoardroomInfo"
  493. add constraint "BoardroomInfo_PK" primary key ("ID")   
  496. go
  498. /* 创建新表 "ApproveRecord"。                                                                      */
  499. /* "ApproveRecord" : Table of 批准记录表                                                           */
  500. /*  "ID" : ID 标识 批准记录表                                                                        */
  501. /*  "RecordID" : 记录ID 属于 批准记录表                                                                */
  502. /*  "ApproveType" : 批准类型 属于 批准记录表                                                             */
  503. /*  "ApproveUserID" : 审批用户ID 属于 批准记录表                                                         */
  504. /*  "IsAgreed" : 是否同意 属于 批准记录表                                                                */
  505. /*  "Content" : 审批说明 属于 批准记录表                                                                 */
  506. /*  "ApproveTime" : 审批时间 属于 批准记录表                                                             */
  507. /*  "ApproveLevel" : 审批级别 属于 批准记录表                                                            */  
  508. create table "ApproveRecord" ( 
  509. "ID" int identity not null,
  510. "RecordID" int null,
  511. "ApproveType" varchar(60) null,
  512. "ApproveUserID" int null,
  513. "IsAgreed" bit null,
  514. "Content" varchar(255) null,
  515. "ApproveTime" datetime null,
  516. "ApproveLevel" int null)  
  518. go
  520. alter table "ApproveRecord"
  521. add constraint "ApproveRecord_PK" primary key ("ID")   
  524. go
  526. /* 创建新表 "StyleInfo"。                                                                          */
  527. /* "StyleInfo" : Table of 风格信息表                                                               */
  528. /*  "ID" : ID 标识 风格信息表                                                                        */
  529. /*  "Name" : 风格名称 属于 风格信息表                                                                    */
  530. /*  "ExamplePicURL" : 示例图片URL 属于 风格信息表                                                        */
  531. /*  "LogoPicURL" : 徽标图片URL 属于 风格信息表                                                           */
  532. /*  "BannerPicURL" : 横幅图片URL 属于 风格信息表                                                         */
  533. /*  "TopBackGroundURL" : 顶部背景图片URL 属于 风格信息表                                                   */
  534. /*  "TopBackColor" : 顶部背景颜色 属于 风格信息表                                                          */
  535. /*  "BackColor" : 背景颜色 属于 风格信息表                                                               */
  536. /*  "TitleColor" : 标题颜色 属于 风格信息表                                                              */
  537. /*  "SingleColor" : 单行颜色 属于 风格信息表                                                             */
  538. /*  "DoubleColor" : 双行颜色 属于 风格信息表                                                             */  
  539. create table "StyleInfo" ( 
  540. "ID" int identity not null,
  541. "Name" varchar(60) null,
  542. "ExamplePicURL" varchar(200) null,
  543. "LogoPicURL" varchar(200) null,
  544. "BannerPicURL" varchar(200) null,
  545. "TopBackGroundURL" varchar(200) null,
  546. "TopBackColor" varchar(60) null,
  547. "BackColor" varchar(60) null,
  548. "TitleColor" varchar(60) null,
  549. "SingleColor" varchar(60) null,
  550. "DoubleColor" varchar(60) null)  
  552. go
  554. alter table "StyleInfo"
  555. add constraint "StyleInfo_PK" primary key ("ID")   
  558. go
  560. /* 创建新表 "PayInfo"。                                                                            */
  561. /* "PayInfo" : Table of 工资信息表                                                                 */
  562. /*  "ID" : ID 标识 工资信息表                                                                        */
  563. /*  "PersonnelID" : 员工ID 属于 工资信息表                                                             */
  564. /*  "PayTypeID" : 工资条目ID 属于 工资信息表                                                             */
  565. /*  "Pay" : 工资金额 属于 工资信息表                                                                     */
  566. /*  "PayYear" : 工资年份 属于 工资信息表                                                                 */
  567. /*  "PayMonth" : 工资月份 属于 工资信息表                                                                */
  568. /*  "IsConfirmed" : 是否已确认 属于 工资信息表                                                            */
  569. /*  "ConfirmInfo" : 确认信息 属于 工资信息表                                                             */  
  570. create table "PayInfo" ( 
  571. "ID" int identity not null,
  572. "PersonnelID" int null,
  573. "PayTypeID" int null,
  574. "Pay" money null,
  575. "PayYear" int null,
  576. "PayMonth" int null,
  577. "IsConfirmed" bit null,
  578. "ConfirmInfo" varchar(60) null)  
  580. go
  582. alter table "PayInfo"
  583. add constraint "PayInfo_PK" primary key ("ID")   
  586. go
  588. /* 创建新表 "BasePayInfo"。                                                                        */
  589. /* "BasePayInfo" : Table of 基本工资信息表                                                           */
  590. /*  "ID" : ID 标识 基本工资信息表                                                                      */
  591. /*  "PersonnelID" : 员工ID 属于 基本工资信息表                                                           */
  592. /*  "PayTypeID" : 工资条目ID 属于 基本工资信息表                                                           */
  593. /*  "Pay" : 工资金额 属于 基本工资信息表                                                                   */  
  594. create table "BasePayInfo" ( 
  595. "ID" int identity not null,
  596. "PersonnelID" int null,
  597. "PayTypeID" int null,
  598. "Pay" money null)  
  600. go
  602. alter table "BasePayInfo"
  603. add constraint "BasePayInfo_PK" primary key ("ID")   
  606. go
  608. /* 创建新表 "PayTypeInfo"。                                                                        */
  609. /* "PayTypeInfo" : Table of 工资条目信息表                                                           */
  610. /*  "ID" : ID 标识 工资条目信息表                                                                      */
  611. /*  "TypeName" : 条目名称 属于 工资条目信息表                                                              */
  612. /*  "OrderNumber" : 排序编号 属于 工资条目信息表                                                           */  
  613. create table "PayTypeInfo" ( 
  614. "ID" int identity not null,
  615. "TypeName" varchar(60) null,
  616. "OrderNumber" int null)  
  618. go
  620. alter table "PayTypeInfo"
  621. add constraint "PayTypeInfo_PK" primary key ("ID")   
  624. go
  626. /* 创建新表 "SignTypeInfo"。                                                                       */
  627. /* "SignTypeInfo" : Table of 签到类型信息表                                                          */
  628. /*  "ID" : ID 标识 签到类型信息表                                                                      */
  629. /*  "TypeName" : 类型名称 属于 签到类型信息表                                                              */
  630. /*  "StartTime" : 签到开始时间 属于 签到类型信息表                                                           */
  631. /*  "EndTime" : 签到结束时间 属于 签到类型信息表                                                             */
  632. /*  "BeforeBeign" : 早签到描述 属于 签到类型信息表                                                          */
  633. /*  "AfterEnd" : 晚签到描述 属于 签到类型信息表                                                             */
  634. /*  "Remark" : 备注 属于 签到类型信息表                                                                  */
  635. /*  "WorkDay" : 签到工作日 属于 签到类型信息表                                                              */
  636. /*  "NoSignUserIDs" : 不用签到用户ID 属于 签到类型信息表                                                     */  
  637. create table "SignTypeInfo" ( 
  638. "ID" int identity not null,
  639. "TypeName" varchar(100) null,
  640. "StartTime" varchar(50) null,
  641. "EndTime" varchar(50) null,
  642. "BeforeBeign" varchar(200) null,
  643. "AfterEnd" varchar(200) null,
  644. "Remark" varchar(250) null,
  645. "WorkDay" varchar(60) null,
  646. "NoSignUserIDs" varchar(250) null)  
  648. go
  650. alter table "SignTypeInfo"
  651. add constraint "SignTypeInfo_PK" primary key ("ID")   
  654. go
  656. /* 创建新表 "SignInfo"。                                                                           */
  657. /* "SignInfo" : Table of 签到信息表                                                                */
  658. /*  "ID" : ID 标识 签到信息表                                                                        */
  659. /*  "UserID" : 用户ID 属于 签到信息表                                                                  */
  660. /*  "SignTypeID" : 签到类型ID 属于 签到信息表                                                            */
  661. /*  "SignTime" : 签到时间 属于 签到信息表                                                                */
  662. /*  "SignIP" : 签到IP地址 属于 签到信息表                                                                */
  663. /*  "IsNormal" : 是否正常 属于 签到信息表                                                                */
  664. /*  "Remark" : 备注 属于 签到信息表                                                                    */
  665. /*  "EditUserID" : 修改记录用户ID 属于 签到信息表                                                          */
  666. /*  "EditIP" : 修改记录IP 属于 签到信息表                                                                */  
  667. create table "SignInfo" ( 
  668. "ID" int identity not null,
  669. "UserID" int null,
  670. "SignTypeID" int null,
  671. "SignTime" datetime null,
  672. "SignIP" varchar(100) null,
  673. "IsNormal" bit null,
  674. "Remark" varchar(200) null,
  675. "EditUserID" int null,
  676. "EditIP" varchar(100) null)  
  678. go
  680. alter table "SignInfo"
  681. add constraint "SignInfo_PK" primary key ("ID")   
  684. go
  686. /* 创建新表 "RoleModuleRight"。                                                                    */
  687. /* "RoleModuleRight" : Table of 角色功能模块权限表                                                     */
  688. /*  "ID" : ID 标识 角色功能模块权限表                                                                    */
  689. /*  "ModuleID" : 功能模块ID 属于 角色功能模块权限表                                                          */
  690. /*  "RoleID" : 角色ID 属于 角色功能模块权限表                                                              */  
  691. create table "RoleModuleRight" ( 
  692. "ID" int identity not null,
  693. "ModuleID" int null,
  694. "RoleID" int null)  
  696. go
  698. alter table "RoleModuleRight"
  699. add constraint "RoleModuleRight_PK" primary key ("ID")   
  702. go
  704. /* 创建新表 "ModuleInfo"。                                                                         */
  705. /* "ModuleInfo" : Table of 功能模块信息表                                                            */
  706. /*  "ID" : ID 标识 功能模块信息表                                                                      */
  707. /*  "ModuleName" : Mo 属于 功能模块信息表                                                              */  
  708. create table "ModuleInfo" ( 
  709. "ID" int identity not null,
  710. "ModuleName" varchar(60) null)  
  712. go
  714. alter table "ModuleInfo"
  715. add constraint "ModuleInfo_PK" primary key ("ID")   
  718. go
  720. /* 创建新表 "PublicResShare"。                                                                     */
  721. /* "PublicResShare" : Table of 公物共享                                                           */
  722. /*  "ID" : ID 标识 公物共享                                                                         */
  723. /*  "AssetID" : 资产ID 属于 公物共享                                                                  */
  724. /*  "StartTime" : 计划开始时间 属于 公物共享                                                              */
  725. /*  "EndTime" : 计划结束时间 属于 公物共享                                                                */
  726. /*  "Purpose" : 用途 属于 公物共享                                                                    */
  727. /*  "UserID" : 申请用户ID 属于 公物共享                                                                 */
  728. /*  "IsPlan" : 是否计划 属于 公物共享                                                                   */  
  729. create table "PublicResShare" ( 
  730. "ID" int identity not null,
  731. "AssetID" int null,
  732. "StartTime" datetime null,
  733. "EndTime" datetime null,
  734. "Purpose" varchar(60) null,
  735. "UserID" int null,
  736. "IsPlan" bit null) ON 'PRIMARY'  
  738. go
  740. alter table "PublicResShare"
  741. add constraint "PublicResShare_PK" primary key clustered ("ID")   
  744. go
  746. /* 创建新表 "PageRights"。                                                                         */
  747. /* "PageRights" : Table of 页面访问权限表                                                            */
  748. /*  "ID" : ID 标识 页面访问权限表                                                                      */
  749. /*  "PageURL" : 页面地址 属于 页面访问权限表                                                               */
  750. /*  "ModuleID" : 功能模块ID 属于 页面访问权限表                                                            */  
  751. create table "PageRights" ( 
  752. "ID" int identity not null,
  753. "PageURL" varchar(100) null,
  754. "ModuleID" int null) ON 'PRIMARY'  
  756. go
  758. alter table "PageRights"
  759. add constraint "PageRights_PK" primary key clustered ("ID")   
  762. go
  764. /* 创建新表 "OnlineMessage"。                                                                      */
  765. /* "OnlineMessage" : Table of 在线消息表                                                           */
  766. /*  "ID" : ID 标识 在线消息表                                                                        */
  767. /*  "Title" : 标题 属于 在线消息表                                                                     */
  768. /*  "SendTime" : 发送时间 属于 在线消息表                                                                */
  769. /*  "Content" : 信息内容 属于 在线消息表                                                                 */
  770. /*  "SendUserID" : 发送用户ID 属于 在线消息表                                                            */
  771. /*  "RecieveUserID" : 接收用户ID 属于 在线消息表                                                         */
  772. /*  "IsReaded" : 是否已读 属于 在线消息表                                                                */
  773. /*  "IsSenderDel" : 是否已被发送者删除 属于 在线消息表                                                        */
  774. /*  "IsRecieverDel" : 是否已被接收者删除 属于 在线消息表                                                      */
  775. /*  "IsSecret" : 是否密送 属于 在线消息表                                                                */
  776. /*  "IsPigeonhole" : 是否已经归档 属于 在线消息表                                                          */
  777. /*  "MessageID" : 信息标识 属于 在线消息表                                                               */
  778. /*  "IsReminded" : 是否已经提醒 属于 在线消息表                                                            */  
  779. create table "OnlineMessage" ( 
  780. "ID" int identity not null,
  781. "Title" varchar(60) null,
  782. "SendTime" datetime null,
  783. "Content" text null,
  784. "SendUserID" int null,
  785. "RecieveUserID" int null,
  786. "IsReaded" bit null,
  787. "IsSenderDel" bit null,
  788. "IsRecieverDel" bit null,
  789. "IsSecret" bit null,
  790. "IsPigeonhole" bit null,
  791. "MessageID" int null,
  792. "IsReminded" bit null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  794. go
  796. alter table "OnlineMessage"
  797. add constraint "OnlineMessage_PK" primary key clustered ("ID")   
  800. go
  802. /* 创建新表 "MailServerInfo"。                                                                     */
  803. /* "MailServerInfo" : Table of 邮件服务器信息表                                                       */
  804. /*  "ID" : 邮件邮件ID 标识 邮件服务器信息表                                                                 */
  805. /*  "ServerName" : 服务器名称 属于 邮件服务器信息表                                                          */
  806. /*  "POP3" : POP3服务器地址 属于 邮件服务器信息表                                                            */
  807. /*  "POP3User" : POP3用户名 属于 邮件服务器信息表                                                          */
  808. /*  "POP3Password" : POP3密码 属于 邮件服务器信息表                                                       */
  809. /*  "POP3Port" : POP3端口 属于 邮件服务器信息表                                                           */
  810. /*  "SMTPServer" : SMTP服务器 属于 邮件服务器信息表                                                        */
  811. /*  "SMTPUser" : SMTP用户名 属于 邮件服务器信息表                                                          */
  812. /*  "SMTPPassword" : SMTP密码 属于 邮件服务器信息表                                                       */
  813. /*  "LastTime" : 最后使用时间 属于 邮件服务器信息表                                                           */
  814. /*  "UserID" : 用户ID 属于 邮件服务器信息表                                                               */  
  815. create table "MailServerInfo" ( 
  816. "ID" int identity not null,
  817. "ServerName" varchar(60) null,
  818. "POP3" varchar(60) null,
  819. "POP3User" varchar(60) null,
  820. "POP3Password" varchar(60) null,
  821. "POP3Port" int null,
  822. "SMTPServer" varchar(60) null,
  823. "SMTPUser" varchar(60) null,
  824. "SMTPPassword" varchar(60) null,
  825. "LastTime" datetime null,
  826. "UserID" int null) ON 'PRIMARY'  
  828. go
  830. alter table "MailServerInfo"
  831. add constraint "MailServerInfo_PK" primary key clustered ("ID")   
  834. go
  836. /* 创建新表 "Favorites"。                                                                          */
  837. /* "Favorites" : Table of 收藏夹信息表                                                              */
  838. /*  "ID" : ID 标识 收藏夹信息表                                                                       */
  839. /*  "Name" : 收藏名称 属于 收藏夹信息表                                                                   */
  840. /*  "URL" : 网址 属于 收藏夹信息表                                                                      */
  841. /*  "LastViewTime" : 最后浏览时间 属于 收藏夹信息表                                                         */
  842. /*  "ViewTimes" : 浏览次数 属于 收藏夹信息表                                                              */
  843. /*  "KindsID" : 分类ID 属于 收藏夹信息表                                                                */
  844. /*  "IsOpen" : 是否公开 属于 收藏夹信息表                                                                 */  
  845. create table "Favorites" ( 
  846. "ID" int identity not null,
  847. "Name" varchar(60) null,
  848. "URL" varchar(100) null,
  849. "LastViewTime" datetime null,
  850. "ViewTimes" int null,
  851. "KindsID" int null,
  852. "IsOpen" bit null) ON 'PRIMARY'  
  854. go
  856. alter table "Favorites"
  857. add constraint "Favorites_PK" primary key clustered ("ID")   
  860. go
  862. /* 创建新表 "FavoritesKindInfo"。                                                                  */
  863. /* "FavoritesKindInfo" : Table of 收藏夹分类信息表                                                    */
  864. /*  "ID" : ID 标识 收藏夹分类信息表                                                                     */
  865. /*  "KindName" : 分类名称 属于 收藏夹分类信息表                                                             */
  866. /*  "UserID" : 用户ID 属于 收藏夹分类信息表                                                               */  
  867. create table "FavoritesKindInfo" ( 
  868. "ID" int identity not null,
  869. "KindName" varchar(60) null,
  870. "UserID" int null) ON 'PRIMARY'  
  872. go
  874. alter table "FavoritesKindInfo"
  875. add constraint "FavoritesKindInfo_PK" primary key clustered ("ID")   
  878. go
  880. /* 创建新表 "AssetInOutInfo"。                                                                     */
  881. /* "AssetInOutInfo" : Table of 设备入库出库记录                                                       */
  882. /*  "ID" : ID 标识 设备入库出库记录                                                                     */
  883. /*  "Operation" : 操作类型 属于 设备入库出库记录                                                            */
  884. /*  "StartTime" : 开始时间 属于 设备入库出库记录                                                            */
  885. /*  "EndTime" : 结束时间 属于 设备入库出库记录                                                              */
  886. /*  "OperateUserID" : 操作用户ID 属于 设备入库出库记录                                                      */
  887. /*  "Remark" : 备注 属于 设备入库出库记录                                                                 */
  888. /*  "OperateTime" : 操作时间 属于 设备入库出库记录                                                          */
  889. /*  "AssetID" : 资产ID 属于 设备入库出库记录                                                              */
  890. /*  "Amount" : 数量 属于 设备入库出库记录                                                                 */  
  891. create table "AssetInOutInfo" ( 
  892. "ID" int identity not null,
  893. "Operation" varchar(50) null,
  894. "StartTime" datetime null,
  895. "EndTime" datetime null,
  896. "OperateUserID" int null,
  897. "Remark" text null,
  898. "OperateTime" datetime null,
  899. "AssetID" int null,
  900. "Amount" float null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  902. go
  904. alter table "AssetInOutInfo"
  905. add constraint "AssetInOutInfo_PK" primary key clustered ("ID")   
  908. go
  910. /* 创建新表 "ErrandApplyAndRecord"。                                                               */
  911. /* "ErrandApplyAndRecord" : Table of 出差申请与记录                                                  */
  912. /*  "ID" : ID 标识 出差申请与记录                                                                      */
  913. /*  "PlanStartTime" : 计划开始时间 属于 出差申请与记录                                                       */
  914. /*  "PlanEndTime" : 计划结束时间 属于 出差申请与记录                                                         */
  915. /*  "RealStartTime" : 实际开始时间 属于 出差申请与记录                                                       */
  916. /*  "RealEndTime" : 实际结束时间 属于 出差申请与记录                                                         */
  917. /*  "CompanyTo" : 目的公司名称 属于 出差申请与记录                                                           */
  918. /*  "CityTo" : 目的城市 属于 出差申请与记录                                                                */
  919. /*  "ErrandTitle" : 出差事由 属于 出差申请与记录                                                           */
  920. /*  "ErrandContent" : 出差事由描述 属于 出差申请与记录                                                       */
  921. /*  "Personnels" : 出差人员 属于 出差申请与记录                                                            */
  922. /*  "Remark" : 备注 属于 出差申请与记录                                                                  */
  923. /*  "ApplyUserID" : 申请用户ID 属于 出差申请与记录                                                         */
  924. /*  "ApplyTime" : 申请时间 属于 出差申请与记录                                                             */
  925. /*  "ConfirmUserID" : 批准用户ID 属于 出差申请与记录                                                       */
  926. /*  "SysDirID" : 系统目录ID 属于 出差申请与记录                                                            */  
  927. create table "ErrandApplyAndRecord" ( 
  928. "ID" int identity not null,
  929. "PlanStartTime" datetime null,
  930. "PlanEndTime" datetime null,
  931. "RealStartTime" datetime null,
  932. "RealEndTime" datetime null,
  933. "CompanyTo" varchar(150) null,
  934. "CityTo" varchar(60) null,
  935. "ErrandTitle" varchar(150) null,
  936. "ErrandContent" text null,
  937. "Personnels" varchar(200) null,
  938. "Remark" text null,
  939. "ApplyUserID" int null,
  940. "ApplyTime" datetime null,
  941. "ConfirmUserID" int null,
  942. "SysDirID" int null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  944. go
  946. alter table "ErrandApplyAndRecord"
  947. add constraint "ErrandApplyAndRecord_PK" primary key clustered ("ID")   
  950. go
  952. /* 创建新表 "CalendarPlans"。                                                                      */
  953. /* "CalendarPlans" : Table of 日程计划                                                            */
  954. /*  "ID" : ID 标识 日程计划                                                                         */
  955. /*  "UserID" : 用户ID 属于 日程计划                                                                   */
  956. /*  "PlanTitle" : 计划主题 属于 日程计划                                                                */
  957. /*  "PlanContent" : 计划内容 属于 日程计划                                                              */
  958. /*  "AddTime" : 增加时间 属于 日程计划                                                                  */
  959. /*  "PlanBeginDate" : 计划开始时间 属于 日程计划                                                          */
  960. /*  "PlanEndDate" : 计划结束时间 属于 日程计划                                                            */
  961. /*  "RealBeginDate" : 实际开始时间 属于 日程计划                                                          */
  962. /*  "RealEndDate" : 实际结束时间 属于 日程计划                                                            */
  963. /*  "ImportLevel" : 重要等级 属于 日程计划                                                              */
  964. /*  "RemindInterval" : 提醒时间间隔 属于 日程计划                                                         */
  965. /*  "IsFinished" : 是否已经完成 属于 日程计划                                                             */
  966. /*  "Remark" : 备注 属于 日程计划                                                                     */  
  967. create table "CalendarPlans" ( 
  968. "ID" int identity not null,
  969. "UserID" int null,
  970. "PlanTitle" varchar(60) null,
  971. "PlanContent" text null,
  972. "AddTime" datetime null,
  973. "PlanBeginDate" datetime null,
  974. "PlanEndDate" datetime null,
  975. "RealBeginDate" datetime null,
  976. "RealEndDate" datetime null,
  977. "ImportLevel" int null,
  978. "RemindInterval" int null,
  979. "IsFinished" bit null,
  980. "Remark" text null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  982. go
  984. alter table "CalendarPlans"
  985. add constraint "CalendarPlans_PK" primary key clustered ("ID")   
  988. go
  990. /* 创建新表 "FieldsValue"。                                                                        */
  991. /* "FieldsValue" : Table of 文档字段值存放表                                                          */
  992. /*  "ID" : ID 标识 文档字段值存放表                                                                     */
  993. /*  "DocumentID" : 文档ID 属于 文档字段值存放表                                                           */
  994. /*  "FieldID" : 字段ID 属于 文档字段值存放表                                                              */
  995. /*  "FieldValue" : 字段值 属于 文档字段值存放表                                                            */  
  996. create table "FieldsValue" ( 
  997. "ID" int identity not null,
  998. "DocumentID" int null,
  999. "FieldID" int null,
  1000. "FieldValue" text null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  1002. go
  1004. alter table "FieldsValue"
  1005. add constraint "FieldsValue_PK" primary key clustered ("ID")   
  1008. go
  1010. /* 创建新表 "DocFieldsName"。                                                                      */
  1011. /* "DocFieldsName" : Table of 文档字段名称表                                                         */
  1012. /*  "ID" : ID 标识 文档字段名称表                                                                      */
  1013. /*  "FieldsName" : 字段名称 属于 文档字段名称表                                                            */
  1014. /*  "OrderBy" : 排序编号 属于 文档字段名称表                                                               */
  1015. /*  "FieldType" : 字段类型 属于 文档字段名称表                                                             */
  1016. /*  "DocumentTypeID" : 文档类型ID 属于 文档字段名称表                                                      */  
  1017. create table "DocFieldsName" ( 
  1018. "ID" int identity not null,
  1019. "FieldsName" varchar(60) null,
  1020. "OrderBy" int null,
  1021. "FieldType" varchar(60) null,
  1022. "DocumentTypeID" int null) ON 'PRIMARY'  
  1024. go
  1026. alter table "DocFieldsName"
  1027. add constraint "DocFieldsName_PK" primary key clustered ("ID")   
  1030. go
  1032. /* 创建新表 "DocumentTypeInfo"。                                                                   */
  1033. /* "DocumentTypeInfo" : Table of 文档类型信息表                                                      */
  1034. /*  "ID" : ID 标识 文档类型信息表                                                                      */
  1035. /*  "TypeName" : 类型名称 属于 文档类型信息表                                                              */
  1036. /*  "SysDirID" : 系统目录ID 属于 文档类型信息表                                                            */  
  1037. create table "DocumentTypeInfo" ( 
  1038. "ID" int identity not null,
  1039. "TypeName" varchar(60) null,
  1040. "SysDirID" int null) ON 'PRIMARY'  
  1042. go
  1044. alter table "DocumentTypeInfo"
  1045. add constraint "DocumentTypeInfo_PK" primary key clustered ("ID")   
  1048. go
  1050. /* 创建新表 "DocumentInfo"。                                                                       */
  1051. /* "DocumentInfo" : Table of 公文信息表                                                            */
  1052. /*  "ID" : ID 标识 公文信息表                                                                        */
  1053. /*  "DocumentName" : 公文名称 属于 公文信息表                                                            */
  1054. /*  "Content" : 公文内容 属于 公文信息表                                                                 */
  1055. /*  "PublishUserID" : 发布用户ID 属于 公文信息表                                                         */
  1056. /*  "PublishTime" : 发布时间 属于 公文信息表                                                             */
  1057. /*  "DocumentTypeID" : 文档类型ID 属于 公文信息表                                                        */
  1058. /*  "ReadUserIDs" : 阅读用户ID 属于 公文信息表                                                           */
  1059. /*  "EditUserIDs" : 修改用户ID 属于 公文信息表                                                           */  
  1060. create table "DocumentInfo" ( 
  1061. "ID" int identity not null,
  1062. "DocumentName" varchar(150) null,
  1063. "Content" text null,
  1064. "PublishUserID" int null,
  1065. "PublishTime" datetime null,
  1066. "DocumentTypeID" int null,
  1067. "ReadUserIDs" varchar(300) null,
  1068. "EditUserIDs" varchar(300) null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  1070. go
  1072. alter table "DocumentInfo"
  1073. add constraint "DocumentInfo_PK" primary key clustered ("ID")   
  1076. go
  1078. /* 创建新表 "VoteOptionsInfo"。                                                                    */
  1079. /* "VoteOptionsInfo" : Table of 投票选项信息表                                                       */
  1080. /*  "ID" : ID 标识 投票选项信息表                                                                      */
  1081. /*  "VoteID" : 投票ID 属于 投票选项信息表                                                                */
  1082. /*  "OptionContent" : 选项内容 属于 投票选项信息表                                                         */
  1083. /*  "Times" : 获得票数 属于 投票选项信息表                                                                 */  
  1084. create table "VoteOptionsInfo" ( 
  1085. "ID" int identity not null,
  1086. "VoteID" int null,
  1087. "OptionContent" varchar(255) null,
  1088. "Times" int null) ON 'PRIMARY'  
  1090. go
  1092. alter table "VoteOptionsInfo"
  1093. add constraint "VoteOptionsInfo_PK" primary key clustered ("ID")   
  1096. go
  1098. /* 创建新表 "VoteInfo"。                                                                           */
  1099. /* "VoteInfo" : Table of 在线投票信息表                                                              */
  1100. /*  "ID" : ID 标识 在线投票信息表                                                                      */
  1101. /*  "VoteName" : 投票名称 属于 在线投票信息表                                                              */
  1102. /*  "StartTime" : 开始时间 属于 在线投票信息表                                                             */
  1103. /*  "EndTime" : 结束时间 属于 在线投票信息表                                                               */
  1104. /*  "IsRadio" : 是否单选 属于 在线投票信息表                                                               */
  1105. /*  "SysDirID" : 系统目录ID 属于 在线投票信息表                                                            */
  1106. /*  "VoteTimes" : 投票次数 属于 在线投票信息表                                                             */
  1107. /*  "PublishTime" : 发布时间 属于 在线投票信息表                                                           */
  1108. /*  "PublishUserID" : 发布用户ID 属于 在线投票信息表                                                       */  
  1109. create table "VoteInfo" ( 
  1110. "ID" int identity not null,
  1111. "VoteName" varchar(60) null,
  1112. "StartTime" datetime null,
  1113. "EndTime" datetime null,
  1114. "IsRadio" bit null,
  1115. "SysDirID" int null,
  1116. "VoteTimes" int null,
  1117. "PublishTime" datetime null,
  1118. "PublishUserID" int null) ON 'PRIMARY'  
  1120. go
  1122. alter table "VoteInfo"
  1123. add constraint "VoteInfo_PK" primary key clustered ("ID")   
  1126. go
  1128. /* 创建新表 "BBSInfo"。                                                                            */
  1129. /* "BBSInfo" : Table of 在线论坛信息表                                                               */
  1130. /*  "ID" : ID 标识 在线论坛信息表                                                                      */
  1131. /*  "Title" : 标题 属于 在线论坛信息表                                                                   */
  1132. /*  "PublishTime" : 发布时间 属于 在线论坛信息表                                                           */
  1133. /*  "PublishUserID" : 发布用户ID 属于 在线论坛信息表                                                       */
  1134. /*  "FaceID" : 表情ID 属于 在线论坛信息表                                                                */
  1135. /*  "Content" : 内容 属于 在线论坛信息表                                                                 */
  1136. /*  "Station" : 帖子位置 属于 在线论坛信息表                                                               */
  1137. /*  "SysDirID" : 系统目录ID 属于 在线论坛信息表                                                            */
  1138. /*  "ViewTimes" : 浏览次数 属于 在线论坛信息表                                                             */  
  1139. create table "BBSInfo" ( 
  1140. "ID" int identity not null,
  1141. "Title" varchar(60) null,
  1142. "PublishTime" datetime null,
  1143. "PublishUserID" int null,
  1144. "FaceID" int null,
  1145. "Content" text null,
  1146. "Station" varchar(250) null,
  1147. "SysDirID" int null,
  1148. "ViewTimes" int null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  1150. go
  1152. alter table "BBSInfo"
  1153. add constraint "BBSInfo_PK" primary key clustered ("ID")   
  1156. go
  1158. /* 创建新表 "ArticleAttInfo"。                                                                     */
  1159. /* "ArticleAttInfo" : 文章相关附件信息表                                                               */
  1160. /*  "ID" : ID 标识 文章相关附件信息表                                                                    */
  1161. /*  "AttName" : 附件名称                                                                          */
  1162. /*  "AttURL" : 附件连接地址                                                                         */
  1163. /*  "FartherID" : 父级ID 属于 文章相关附件信息表                                                           */
  1164. /*  "FartherTable" : 父级表名称 属于 文章相关附件信息表                                                       */  
  1165. create table "ArticleAttInfo" ( 
  1166. "ID" int identity not null,
  1167. "AttName" varchar(150) null,
  1168. "AttURL" varchar(250) null,
  1169. "FartherID" int null,
  1170. "FartherTable" varchar(60) null) ON 'PRIMARY'  
  1172. go
  1174. alter table "ArticleAttInfo"
  1175. add constraint "ArticleAttInfo_PK" primary key clustered ("ID")   
  1178. go
  1180. /* 创建新表 "ArticleInfo"。                                                                        */
  1181. /* "ArticleInfo" : 新闻文章信息表                                                                    */
  1182. /*  "ID" : ID 标识 新闻文章信息表                                                                      */
  1183. /*  "Title" : 标题                                                                              */
  1184. /*  "Author" : 作者                                                                             */
  1185. /*  "Publisher" : 出版社                                                                         */
  1186. /*  "FromURL" : 来源网址                                                                          */
  1187. /*  "PublishDate" : 发表时间                                                                      */
  1188. /*  "Content" : 内容                                                                            */
  1189. /*  "ViewTimes" : 浏览次数                                                                        */
  1190. /*  "IsHot" : 是否热点文章                                                                          */
  1191. /*  "ThemeImage" : 主题图片 属于 新闻文章信息表                                                            */
  1192. /*  "KeyWords" : 关键字 属于 新闻文章信息表                                                               */
  1193. /*  "SysDirID" : 系统目录ID 属于 新闻文章信息表                                                            */
  1194. /*  "PublishUserID" : 发布用户ID 属于 新闻文章信息表                                                       */  
  1195. create table "ArticleInfo" ( 
  1196. "ID" int identity not null,
  1197. "Title" varchar(100) null,
  1198. "Author" varchar(50) null,
  1199. "Publisher" varchar(100) null,
  1200. "FromURL" varchar(150) null,
  1201. "PublishDate" datetime null,
  1202. "Content" text null,
  1203. "ViewTimes" int null,
  1204. "IsHot" bit null,
  1205. "ThemeImage" varchar(100) null,
  1206. "KeyWords" varchar(100) null,
  1207. "SysDirID" int null,
  1208. "PublishUserID" int null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  1210. go
  1212. alter table "ArticleInfo"
  1213. add constraint "ArticleInfo_PK" primary key clustered ("ID")   
  1216. go
  1218. /* 创建新表 "FamilyMember"。                                                                       */
  1219. /* "FamilyMember" : 家庭成员信息表                                                                   */
  1220. /*  "ID" : ID 标识 家庭成员信息表                                                                      */
  1221. /*  "Name" : 姓名                                                                               */
  1222. /*  "BirthDate" : 出生日期                                                                        */
  1223. /*  "Relation" : 关系                                                                           */
  1224. /*  "Place" : 职位                                                                              */
  1225. /*  "Commpany" : 工作单位                                                                         */
  1226. /*  "PersannelID" : 员工ID 属于 家庭成员信息表                                                           */  
  1227. create table "FamilyMember" ( 
  1228. "ID" int identity not null,
  1229. "Name" varchar(50) null,
  1230. "BirthDate" datetime null,
  1231. "Relation" varchar(50) null,
  1232. "Place" varchar(50) null,
  1233. "Commpany" varchar(50) null,
  1234. "PersannelID" int null) ON 'PRIMARY'  
  1236. go
  1238. alter table "FamilyMember"
  1239. add constraint "FamilyMember_PK" primary key clustered ("ID")   
  1242. go
  1244. /* 创建新表 "PlaceInfo"。                                                                          */
  1245. /* "PlaceInfo" : 职位信息表                                                                        */
  1246. /*  "ID" : ID 标识 职位信息表                                                                        */
  1247. /*  "PlaceName" : 职位名称                                                                        */
  1248. /*  "DepartmentID" : 所属部门ID 属于 职位信息表                                                          */  
  1249. create table "PlaceInfo" ( 
  1250. "ID" int identity not null,
  1251. "PlaceName" varchar(50) null,
  1252. "DepartmentID" int null) ON 'PRIMARY'  
  1254. go
  1256. alter table "PlaceInfo"
  1257. add constraint "PlaceInfo_PK" primary key clustered ("ID")   
  1260. go
  1262. /* 创建新表 "MarriageState"。                                                                      */
  1263. /* "MarriageState" : 婚姻状况分类信息表                                                                */
  1264. /*  "ID" : ID 标识 婚姻状况分类信息表                                                                    */
  1265. /*  "MarriageState" : 婚姻状况                                                                    */
  1266. /*  "OrderNumber" : 排序                                                                        */  
  1267. create table "MarriageState" ( 
  1268. "ID" int identity not null,
  1269. "MarriageState" varchar(50) null,
  1270. "OrderNumber" int null) ON 'PRIMARY'  
  1272. go
  1274. alter table "MarriageState"
  1275. add constraint "MarriageState_PK" primary key clustered ("ID")   
  1278. go
  1280. /* 创建新表 "EducationInfo"。                                                                      */
  1281. /* "EducationInfo" : 教育程度分类信息表                                                                */
  1282. /*  "ID" : ID 标识 教育程度分类信息表                                                                    */
  1283. /*  "Education" : 教育程度                                                                        */
  1284. /*  "OrderNumber" : 排序编号                                                                      */  
  1285. create table "EducationInfo" ( 
  1286. "ID" int identity not null,
  1287. "Education" varchar(50) null,
  1288. "OrderNumber" int null) ON 'PRIMARY'  
  1290. go
  1292. alter table "EducationInfo"
  1293. add constraint "EducationInfo_PK" primary key clustered ("ID")   
  1296. go
  1298. /* 创建新表 "PersonnelInfo"。                                                                      */
  1299. /* "PersonnelInfo" : 员工信息表                                                                    */
  1300. /*  "ID" : ID 标识 员工信息表                                                                        */
  1301. /*  "Name" : 员工姓名                                                                             */
  1302. /*  "Sex" : 性别                                                                                */
  1303. /*  "BirthDate" : 出生日期                                                                        */
  1304. /*  "Number" : 员工编号                                                                           */
  1305. /*  "OfficeTel" : 办公室电话                                                                       */
  1306. /*  "HomeTel" : 家庭电话或者手机号码                                                                    */
  1307. /*  "IDCard" : 身份证号码                                                                          */
  1308. /*  "HomeAddress" : 家庭住址                                                                      */
  1309. /*  "EMail" : E-mail                                                                          */
  1310. /*  "Resume" : 个人简历                                                                           */
  1311. /*  "Remark" : 备注                                                                             */
  1312. /*  "Remark1" : 备用字段1                                                                         */
  1313. /*  "DepartmentID" : 所属部门ID 属于 员工信息表                                                          */
  1314. /*  "EducationID" : 教育程度ID 属于 员工信息表                                                           */
  1315. /*  "MarriageID" : 婚姻状况ID 属于 员工信息表                                                            */
  1316. /*  "PlaceID" : 职位ID 属于 员工信息表                                                                 */
  1317. /*  "TechnicalPostID" : 职称ID 属于 员工信息表                                                         */
  1318. /*  "Photo" : 像片 属于 员工信息表                                                                     */  
  1319. create table "PersonnelInfo" ( 
  1320. "ID" int identity not null,
  1321. "Name" varchar(50) null,
  1322. "Sex" varchar(10) null,
  1323. "BirthDate" datetime null,
  1324. "Number" varchar(50) null,
  1325. "OfficeTel" varchar(60) null,
  1326. "HomeTel" varchar(60) null,
  1327. "IDCard" varchar(60) null,
  1328. "HomeAddress" varchar(100) null,
  1329. "EMail" varchar(60) null,
  1330. "Resume" varchar(10) null,
  1331. "Remark" varchar(10) null,
  1332. "Remark1" varchar(10) null,
  1333. "DepartmentID" int null,
  1334. "EducationID" int null,
  1335. "MarriageID" int null,
  1336. "PlaceID" int null,
  1337. "TechnicalPostID" int null,
  1338. "Photo" varchar(150) null) ON 'PRIMARY'  
  1340. go
  1342. alter table "PersonnelInfo"
  1343. add constraint "PersonelInfo_PK" primary key clustered ("ID")   
  1346. go
  1348. /* 创建新表 "DepartmentInfo"。                                                                     */
  1349. /* "DepartmentInfo" : 部门信息表                                                                   */
  1350. /*  "ID" : ID 在于 部门信息表                                                                        */
  1351. /*  "Name" : 名称                                                                               */
  1352. /*  "Station" : 所在位置                                                                          */
  1353. /*  "LevelNumber" : 级别                                                                        */
  1354. /*  "ChildrenAcount" : 子级目录个数 属于 部门信息表                                                        */
  1355. /*  "OrderNumber" : 顺序                                                                        */
  1356. /*  "OpenedICO" : 打开图标                                                                        */
  1357. /*  "CloseedICO" : 关闭图标                                                                       */
  1358. /*  "LinkUrl" : 连接地址                                                                          */
  1359. /*  "Target" : 打开连接的目标框架                                                                      */
  1360. /*  "IsLink" : 是否连接                                                                           */
  1361. /*  "Content" : 内容简介                                                                          */
  1362. /*  "IsShow" : 是否显示                                                                           */  
  1363. create table "DepartmentInfo" ( 
  1364. "ID" int identity not null,
  1365. "Name" varchar(50) null,
  1366. "Station" varchar(250) null,
  1367. "LevelNumber" int null,
  1368. "ChildrenAcount" int null,
  1369. "OrderNumber" int null,
  1370. "OpenedICO" varchar(150) null,
  1371. "CloseedICO" varchar(150) null,
  1372. "LinkUrl" varchar(150) null,
  1373. "Target" varchar(50) null,
  1374. "IsLink" bit null,
  1375. "Content" varchar(1000) null,
  1376. "IsShow" bit null) ON 'PRIMARY'  
  1378. go
  1380. alter table "DepartmentInfo"
  1381. add constraint "DepartmentInfo_PK" primary key clustered ("ID")   
  1384. go
  1386. /* 创建新表 "RoleInfo"。                                                                           */
  1387. /* "RoleInfo" : 用户角色信息表                                                                       */
  1388. /*  "ID" : ID 标识 用户角色信息表                                                                      */
  1389. /*  "RoleName" : 角色名称                                                                         */  
  1390. create table "RoleInfo" ( 
  1391. "ID" int identity not null,
  1392. "RoleName" varchar(50) null) ON 'PRIMARY'  
  1394. go
  1396. alter table "RoleInfo"
  1397. add constraint "RoleInfo_PK" primary key clustered ("ID")   
  1400. go
  1402. /* 创建新表 "UserInfo"。                                                                           */
  1403. /* "UserInfo" : 用户信息表                                                                         */
  1404. /*  "ID" : ID 部分标识 用户信息表                                                                      */
  1405. /*  "UserName" : 用户名称                                                                         */
  1406. /*  "Password" : 用户密码                                                                         */
  1407. /*  "PersonnelID" : 真实姓名                                                                      */
  1408. /*  "RoleID" : 角色ID 属于 用户信息表                                                                  */
  1409. /*  "FTPUserName" : FTP用户名 属于 用户信息表                                                           */
  1410. /*  "FTPPassword" : FTP密码 属于 用户信息表                                                            */
  1411. /*  "StyleID" : 用户风格ID 属于 用户信息表                                                               */  
  1412. create table "UserInfo" ( 
  1413. "ID" int identity not null,
  1414. "UserName" varchar(50) null,
  1415. "Password" varchar(50) null,
  1416. "PersonnelID" int null,
  1417. "RoleID" int null,
  1418. "FTPUserName" varchar(60) null,
  1419. "FTPPassword" varchar(60) null,
  1420. "StyleID" int null) ON 'PRIMARY'  
  1422. go
  1424. alter table "UserInfo"
  1425. add constraint "UserInfo_PK" primary key clustered ("ID")   
  1428. go
  1430. /* 创建新表 "TechnicalPostInfo"。                                                                  */
  1431. /* "TechnicalPostInfo" : 职称分类信息表                                                              */
  1432. /*  "ID" : ID 标识 职称分类信息表                                                                      */
  1433. /*  "TechnicalPost" : 职称名称                                                                    */
  1434. /*  "OrderNumber" : 排序                                                                        */  
  1435. create table "TechnicalPostInfo" ( 
  1436. "ID" int identity not null,
  1437. "TechnicalPost" varchar(50) null,
  1438. "OrderNumber" int null) ON 'PRIMARY'  
  1440. go
  1442. alter table "TechnicalPostInfo"
  1443. add constraint "TechnicalPostInfo_PK" primary key clustered ("ID")   
  1446. go
  1448. /* 创建新表 "SystemDirectory"。                                                                    */
  1449. /* "SystemDirectory" : 系统目录信息表                                                                */
  1450. /*  "ID" : ID 标识 属于 系统目录信息表                                                                   */
  1451. /*  "Name" : 名称                                                                               */
  1452. /*  "Station" : 所在位置                                                                          */
  1453. /*  "LevelNumber" : 级别                                                                        */
  1454. /*  "ChildrenAcount" : 子级目录个数 属于 系统目录信息表                                                      */
  1455. /*  "OrderNumber" : 顺序                                                                        */
  1456. /*  "OpenedICO" : 打开图标                                                                        */
  1457. /*  "CloseedICO" : 关闭图标                                                                       */
  1458. /*  "LinkUrl" : 连接地址                                                                          */
  1459. /*  "Target" : 打开连接的目标框架                                                                      */
  1460. /*  "IsLink" : 是否连接                                                                           */
  1461. /*  "Content" : 内容简介                                                                          */
  1462. /*  "IsShow" : 是否显示                                                                           */  
  1463. create table "SystemDirectory" ( 
  1464. "ID" int identity not null,
  1465. "Name" varchar(50) null,
  1466. "Station" varchar(250) null,
  1467. "LevelNumber" int null,
  1468. "ChildrenAcount" int null,
  1469. "OrderNumber" int null,
  1470. "OpenedICO" varchar(150) null,
  1471. "CloseedICO" varchar(150) null,
  1472. "LinkUrl" varchar(150) null,
  1473. "Target" varchar(50) null,
  1474. "IsLink" bit null,
  1475. "Content" varchar(1000) null,
  1476. "IsShow" bit null) ON 'PRIMARY'  
  1478. go
  1480. alter table "SystemDirectory"
  1481. add constraint "SystemDirectory_PK" primary key clustered ("ID")   
  1484. go
  1486. /* 创建新表 "AssetInfo"。                                                                          */
  1487. /* "AssetInfo" : 资产信息表                                                                        */
  1488. /*  "ID" : ID 标识 资产信息表                                                                        */
  1489. /*  "AssetName" : 资产名称 属于 资产信息表                                                               */
  1490. /*  "AssetNumber" : 资产编号 属于 资产信息表                                                             */
  1491. /*  "AddUserID" : 添加设备用户ID 属于 资产信息表                                                           */
  1492. /*  "AddTime" : 添加时间 属于 资产信息表                                                                 */
  1493. /*  "AssetTypeID" : 资产类型ID 属于 资产信息表                                                           */  
  1494. create table "AssetInfo" ( 
  1495. "ID" int identity not null,
  1496. "AssetName" varchar(150) null,
  1497. "AssetNumber" varchar(50) null,
  1498. "AddUserID" int null,
  1499. "AddTime" datetime null,
  1500. "AssetTypeID" int null) ON 'PRIMARY'  
  1502. go
  1504. alter table "AssetInfo"
  1505. add constraint "AssetInfo_PK" primary key clustered ("ID")   
  1508. go
  1510. /* 创建新表 "AssetTypeInfo"。                                                                      */
  1511. /* "AssetTypeInfo" : Table of 资产类型信息表                                                         */
  1512. /*  "ID" : ID 标识 资产类型信息表                                                                      */
  1513. /*  "TypeName" : 类型名称 属于 资产类型信息表                                                              */
  1514. /*  "SysDirID" : 系统目录ID 属于 资产类型信息表                                                            */  
  1515. create table "AssetTypeInfo" ( 
  1516. "ID" int identity not null,
  1517. "TypeName" varchar(60) null,
  1518. "SysDirID" int null) ON 'PRIMARY'  
  1520. go
  1522. alter table "AssetTypeInfo"
  1523. add constraint "AssetTypeInfo_PK" primary key clustered ("ID")   
  1526. go
  1528. /* 创建新表 "AssetFieldsName"。                                                                    */
  1529. /* "AssetFieldsName" : Table of 资产字段名称表                                                       */
  1530. /*  "ID" : ID 标识 资产字段名称表                                                                      */
  1531. /*  "FieldsName" : 字段名称 属于 资产字段名称表                                                            */
  1532. /*  "OrderBy" : 排序编号 属于 资产字段名称表                                                               */
  1533. /*  "FieldType" : 字段类型 属于 资产字段名称表                                                             */
  1534. /*  "AssetTypeID" : 资产类型ID 属于 资产字段名称表                                                         */  
  1535. create table "AssetFieldsName" ( 
  1536. "ID" int identity not null,
  1537. "FieldsName" varchar(60) null,
  1538. "OrderBy" int null,
  1539. "FieldType" varchar(60) null,
  1540. "AssetTypeID" int null) ON 'PRIMARY'  
  1542. go
  1544. alter table "AssetFieldsName"
  1545. add constraint "AssetFieldsName_PK" primary key clustered ("ID")   
  1548. go
  1550. /* 创建新表 "AssetFieldsValue"。                                                                   */
  1551. /* "AssetFieldsValue" : Table of 资产字段值存放表                                                     */
  1552. /*  "ID" : ID 标识 资产字段值存放表                                                                     */
  1553. /*  "AssetID" : 资产ID 属于 资产字段值存放表                                                              */
  1554. /*  "FieldID" : 字段ID 属于 资产字段值存放表                                                              */
  1555. /*  "FieldValue" : 字段值 属于 资产字段值存放表                                                            */  
  1556. create table "AssetFieldsValue" ( 
  1557. "ID" int identity not null,
  1558. "AssetID" int null,
  1559. "FieldID" int null,
  1560. "FieldValue" text null) ON 'PRIMARY' TEXTIMAGE_ON 'PRIMARY'  
  1562. go
  1564. alter table "AssetFieldsValue"
  1565. add constraint "AssetFieldsValue_PK" primary key clustered ("ID")   
  1568. go
  1570. /* 创建新表 "AddressKindInfo"。                                                                    */
  1571. /* "AddressKindInfo" : Table of 通讯录分类信息表                                                      */
  1572. /*  "ID" : ID 标识 通讯录分类信息表                                                                     */
  1573. /*  "KindName" : 分类名称 属于 通讯录分类信息表                                                             */
  1574. /*  "UserID" : 用户ID 属于 通讯录分类信息表                                                               */  
  1575. create table "AddressKindInfo" ( 
  1576. "ID" int identity not null,
  1577. "KindName" varchar(60) null,
  1578. "UserID" int null) ON 'PRIMARY'  
  1580. go
  1582. alter table "AddressKindInfo"
  1583. add constraint "AddressKindInfo_PK" primary key clustered ("ID")   
  1586. go
  1588. /* 创建新表 "AddressList"。                                                                        */
  1589. /* "AddressList" : Table of 通讯录信息表                                                            */
  1590. /*  "ID" : ID 标识 通讯录信息表                                                                       */
  1591. /*  "Name" : 姓名 属于 通讯录信息表                                                                     */
  1592. /*  "Sex" : 性别 属于 通讯录信息表                                                                      */
  1593. /*  "BirthDate" : 出生日期 属于 通讯录信息表                                                              */
  1594. /*  "Company" : 单位名称 属于 通讯录信息表                                                                */
  1595. /*  "KindsID" : 分类ID 属于 通讯录信息表                                                                */
  1596. /*  "IsOpen" : 是否公开 属于 通讯录信息表                                                                 */
  1597. /*  "Place" : 职位 属于 通讯录信息表                                                                    */
  1598. /*  "HomeTel" : 家庭电话 属于 通讯录信息表                                                                */
  1599. /*  "OfficeTel" : 公司电话 属于 通讯录信息表                                                              */
  1600. /*  "MobileNum" : 手机号码 属于 通讯录信息表                                                              */  
  1601. create table "AddressList" ( 
  1602. "ID" int identity not null,
  1603. "Name" varchar(60) null,
  1604. "Sex" varchar(20) null,
  1605. "BirthDate" datetime null,
  1606. "Company" varchar(60) null,
  1607. "KindsID" int null,
  1608. "IsOpen" bit null,
  1609. "Place" varchar(60) null,
  1610. "HomeTel" varchar(60) null,
  1611. "OfficeTel" varchar(60) null,
  1612. "MobileNum" varchar(60) null) ON 'PRIMARY'  
  1614. go
  1616. alter table "AddressList"
  1617. add constraint "AddressList_PK" primary key clustered ("ID")   
  1620. go
  1622. /* 在表 "ApproveRecordInfo" 中添加外键约束。                                                            */
  1623. alter table "ApproveRecordInfo"
  1624. add constraint "FlowTacheInfo_ApproveRecordInfo_FK1" foreign key (
  1625. "FlowTacheID")
  1626.  references "FlowTacheInfo" (
  1627. "ID")  
  1629. go
  1631. alter table "ApproveRecordInfo"
  1632. add constraint "UserInfo_ApproveRecordInfo_FK1" foreign key (
  1633. "ApproveUserID")
  1634.  references "UserInfo" (
  1635. "ID")  
  1637. go
  1639. /* 在表 "DocFieldsValue" 中添加外键约束。                                                               */
  1640. alter table "DocFieldsValue"
  1641. add constraint "Document_DocFieldsValue_FK1" foreign key (
  1642. "DocTempletFieldsID")
  1643.  references "Document" (
  1644. "ID")  
  1646. go
  1648. alter table "DocFieldsValue"
  1649. add constraint "ApproveRecordInfo_DocFieldsValue_FK1" foreign key (
  1650. "ApproveFlowID")
  1651.  references "ApproveRecordInfo" (
  1652. "ID")  
  1654. go
  1656. /* 在表 "Document" 中添加外键约束。                                                                     */
  1657. alter table "Document"
  1658. add constraint "UserInfo_Document_FK1" foreign key (
  1659. "BuildUserID")
  1660.  references "UserInfo" (
  1661. "ID")  
  1663. go
  1665. alter table "Document"
  1666. add constraint "UserInfo_Document_FK2" foreign key (
  1667. "FillUserID")
  1668.  references "UserInfo" (
  1669. "ID")  
  1671. go
  1673. alter table "Document"
  1674. add constraint "DocTempletMoveFlow_Document_FK1" foreign key (
  1675. "DocFlowTempletID")
  1676.  references "DocTempletMoveFlow" (
  1677. "ID")  
  1679. go
  1681. /* 在表 "DocTempletMoveFlow" 中添加外键约束。                                                           */
  1682. alter table "DocTempletMoveFlow"
  1683. add constraint "DocumentTemplet_DocTempletMoveFlow_FK1" foreign key (
  1684. "DocTempletID")
  1685.  references "DocumentTemplet" (
  1686. "ID")  
  1688. go
  1690. alter table "DocTempletMoveFlow"
  1691. add constraint "MoveFlowInfo_DocTempletMoveFlow_FK1" foreign key (
  1692. "MoveFlowID")
  1693.  references "MoveFlowInfo" (
  1694. "ID")  
  1696. go
  1698. /* 在表 "FlowTacheInfo" 中添加外键约束。                                                                */
  1699. alter table "FlowTacheInfo"
  1700. add constraint "MoveFlowInfo_FlowTacheInfo_FK1" foreign key (
  1701. "FlowID")
  1702.  references "MoveFlowInfo" (
  1703. "ID")  
  1705. go
  1707. alter table "FlowTacheInfo"
  1708. add constraint "UserInfo_FlowTacheInfo_FK1" foreign key (
  1709. "UpdateUserID")
  1710.  references "UserInfo" (
  1711. "ID")  
  1713. go
  1715. /* 在表 "MoveFlowInfo" 中添加外键约束。                                                                 */
  1716. alter table "MoveFlowInfo"
  1717. add constraint "UserInfo_MoveFlowInfo_FK1" foreign key (
  1718. "BuildUserID")
  1719.  references "UserInfo" (
  1720. "ID")  
  1722. go
  1724. /* 在表 "DocTempletFields" 中添加外键约束。                                                             */
  1725. alter table "DocTempletFields"
  1726. add constraint "DocumentTemplet_DocTempletFields_FK1" foreign key (
  1727. "TempletID")
  1728.  references "DocumentTemplet" (
  1729. "ID")  
  1731. go
  1733. /* 在表 "DocumentTemplet" 中添加外键约束。                                                              */
  1734. alter table "DocumentTemplet"
  1735. add constraint "UserInfo_DocumentTemplet_FK1" foreign key (
  1736. "BuildUserID")
  1737.  references "UserInfo" (
  1738. "ID")  
  1740. go
  1742. alter table "DocumentTemplet"
  1743. add constraint "SystemDirectory_DocumentTemplet_FK1" foreign key (
  1744. "SysDirID")
  1745.  references "SystemDirectory" (
  1746. "ID")  
  1748. go
  1750. /* 在表 "PactInfo" 中添加外键约束。                                                                     */
  1751. alter table "PactInfo"
  1752. add constraint "UserInfo_PactInfo_FK1" foreign key (
  1753. "AddUserID")
  1754.  references "UserInfo" (
  1755. "ID")  
  1757. go
  1759. /* 在表 "PactTempletInfo" 中添加外键约束。                                                              */
  1760. alter table "PactTempletInfo"
  1761. add constraint "UserInfo_PactTempletInfo_FK1" foreign key (
  1762. "BuildUserID")
  1763.  references "UserInfo" (
  1764. "ID")  
  1766. go
  1768. /* 在表 "CahierInfo" 中添加外键约束。                                                                   */
  1769. alter table "CahierInfo"
  1770. add constraint "BoardroomApplyInfo_CahierInfo_FK1" foreign key (
  1771. "BoardroomApplyID")
  1772.  references "BoardroomApplyInfo" (
  1773. "ID")  
  1775. go
  1777. alter table "CahierInfo"
  1778. add constraint "BoardroomInfo_CahierInfo_FK1" foreign key (
  1779. "BoardroomID")
  1780.  references "BoardroomInfo" (
  1781. "ID")  
  1783. go
  1785. alter table "CahierInfo"
  1786. add constraint "UserInfo_CahierInfo_FK1" foreign key (
  1787. "NoteUserID")
  1788.  references "UserInfo" (
  1789. "ID")  
  1791. go
  1793. /* 在表 "BoardroomApplyInfo" 中添加外键约束。                                                           */
  1794. alter table "BoardroomApplyInfo"
  1795. add constraint "BoardroomInfo_BoardroomApplyInfo_FK1" foreign key (
  1796. "BoardroomID")
  1797.  references "BoardroomInfo" (
  1798. "ID")  
  1800. go
  1802. alter table "BoardroomApplyInfo"
  1803. add constraint "UserInfo_BoardroomApplyInfo_FK1" foreign key (
  1804. "ApplyUserID")
  1805.  references "UserInfo" (
  1806. "ID")  
  1808. go
  1810. /* 在表 "ApproveRecord" 中添加外键约束。                                                                */
  1811. alter table "ApproveRecord"
  1812. add constraint "UserInfo_ApproveRecord_FK1" foreign key (
  1813. "ApproveUserID")
  1814.  references "UserInfo" (
  1815. "ID")  
  1817. go
  1819. /* 在表 "PayInfo" 中添加外键约束。                                                                      */
  1820. alter table "PayInfo"
  1821. add constraint "PayTypeInfo_PayInfo_FK1" foreign key (
  1822. "PayTypeID")
  1823.  references "PayTypeInfo" (
  1824. "ID")  
  1826. go
  1828. alter table "PayInfo"
  1829. add constraint "PersonnelInfo_PayInfo_FK1" foreign key (
  1830. "PersonnelID")
  1831.  references "PersonnelInfo" (
  1832. "ID")  
  1834. go
  1836. /* 在表 "BasePayInfo" 中添加外键约束。                                                                  */
  1837. alter table "BasePayInfo"
  1838. add constraint "PayTypeInfo_BasePayInfo_FK1" foreign key (
  1839. "PayTypeID")
  1840.  references "PayTypeInfo" (
  1841. "ID")  
  1843. go
  1845. alter table "BasePayInfo"
  1846. add constraint "PersonnelInfo_BasePayInfo_FK1" foreign key (
  1847. "PersonnelID")
  1848.  references "PersonnelInfo" (
  1849. "ID")  
  1851. go
  1853. /* 在表 "SignInfo" 中添加外键约束。                                                                     */
  1854. alter table "SignInfo"
  1855. add constraint "SignTypeInfo_SignInfo_FK1" foreign key (
  1856. "SignTypeID")
  1857.  references "SignTypeInfo" (
  1858. "ID")  
  1860. go
  1862. alter table "SignInfo"
  1863. add constraint "UserInfo_SignInfo_FK1" foreign key (
  1864. "UserID")
  1865.  references "UserInfo" (
  1866. "ID")  
  1868. go
  1870. alter table "SignInfo"
  1871. add constraint "UserInfo_SignInfo_FK2" foreign key (
  1872. "EditUserID")
  1873.  references "UserInfo" (
  1874. "ID")  
  1876. go
  1878. /* 在表 "RoleModuleRight" 中添加外键约束。                                                              */
  1879. alter table "RoleModuleRight"
  1880. add constraint "RoleInfo_RoleModuleRight_FK1" foreign key (
  1881. "RoleID")
  1882.  references "RoleInfo" (
  1883. "ID")  
  1885. go
  1887. alter table "RoleModuleRight"
  1888. add constraint "ModuleInfo_RoleModuleRight_FK1" foreign key (
  1889. "ModuleID")
  1890.  references "ModuleInfo" (
  1891. "ID")  
  1893. go
  1895. /* 在表 "PublicResShare" 中添加外键约束。                                                               */
  1896. alter table "PublicResShare"
  1897. add constraint "AssetInfo_PublicResShare_FK1" foreign key (
  1898. "AssetID")
  1899.  references "AssetInfo" (
  1900. "ID")  
  1902. go
  1904. alter table "PublicResShare"
  1905. add constraint "UserInfo_PublicResShare_FK1" foreign key (
  1906. "UserID")
  1907.  references "UserInfo" (
  1908. "ID")  
  1910. go
  1912. /* 在表 "PageRights" 中添加外键约束。                                                                   */
  1913. alter table "PageRights"
  1914. add constraint "ModuleInfo_PageRights_FK1" foreign key (
  1915. "ModuleID")
  1916.  references "ModuleInfo" (
  1917. "ID")  
  1919. go
  1921. /* 在表 "OnlineMessage" 中添加外键约束。                                                                */
  1922. alter table "OnlineMessage"
  1923. add constraint "UserInfo_OnlineMessage_FK1" foreign key (
  1924. "SendUserID")
  1925.  references "UserInfo" (
  1926. "ID")  
  1928. go
  1930. alter table "OnlineMessage"
  1931. add constraint "UserInfo_OnlineMessage_FK2" foreign key (
  1932. "RecieveUserID")
  1933.  references "UserInfo" (
  1934. "ID")  
  1936. go
  1938. /* 在表 "MailServerInfo" 中添加外键约束。                                                               */
  1939. alter table "MailServerInfo"
  1940. add constraint "UserInfo_MailServerInfo_FK1" foreign key (
  1941. "UserID")
  1942.  references "UserInfo" (
  1943. "ID")  
  1945. go
  1947. /* 在表 "Favorites" 中添加外键约束。                                                                    */
  1948. alter table "Favorites"
  1949. add constraint "FavoritesKindInfo_Favorites_FK1" foreign key (
  1950. "KindsID")
  1951.  references "FavoritesKindInfo" (
  1952. "ID")  
  1954. go
  1956. /* 在表 "FavoritesKindInfo" 中添加外键约束。                                                            */
  1957. alter table "FavoritesKindInfo"
  1958. add constraint "UserInfo_FavoritesKindInfo_FK1" foreign key (
  1959. "UserID")
  1960.  references "UserInfo" (
  1961. "ID")  
  1963. go
  1965. /* 在表 "AssetInOutInfo" 中添加外键约束。                                                               */
  1966. alter table "AssetInOutInfo"
  1967. add constraint "AssetInfo_AssetInOutInfo_FK1" foreign key (
  1968. "AssetID")
  1969.  references "AssetInfo" (
  1970. "ID")  
  1972. go
  1974. alter table "AssetInOutInfo"
  1975. add constraint "UserInfo_AssetInOutInfo_FK1" foreign key (
  1976. "OperateUserID")
  1977.  references "UserInfo" (
  1978. "ID")  
  1980. go
  1982. /* 在表 "ErrandApplyAndRecord" 中添加外键约束。                                                         */
  1983. alter table "ErrandApplyAndRecord"
  1984. add constraint "UserInfo_ErrandApplyAndRecord_FK1" foreign key (
  1985. "ApplyUserID")
  1986.  references "UserInfo" (
  1987. "ID")  
  1989. go
  1991. alter table "ErrandApplyAndRecord"
  1992. add constraint "UserInfo_ErrandApplyAndRecord_FK2" foreign key (
  1993. "ConfirmUserID")
  1994.  references "UserInfo" (
  1995. "ID")  
  1997. go
  1999. alter table "ErrandApplyAndRecord"
  2000. add constraint "SystemDirectory_ErrandApplyAndRecord_FK1" foreign key (
  2001. "SysDirID")
  2002.  references "SystemDirectory" (
  2003. "ID")  
  2005. go
  2007. /* 在表 "CalendarPlans" 中添加外键约束。                                                                */
  2008. alter table "CalendarPlans"
  2009. add constraint "UserInfo_CalendarPlans_FK1" foreign key (
  2010. "UserID")
  2011.  references "UserInfo" (
  2012. "ID")  
  2014. go
  2016. /* 在表 "FieldsValue" 中添加外键约束。                                                                  */
  2017. alter table "FieldsValue"
  2018. add constraint "DocumentInfo_FieldsValue_FK1" foreign key (
  2019. "DocumentID")
  2020.  references "DocumentInfo" (
  2021. "ID")  
  2023. go
  2025. alter table "FieldsValue"
  2026. add constraint "DocFieldsName_FieldsValue_FK1" foreign key (
  2027. "FieldID")
  2028.  references "DocFieldsName" (
  2029. "ID")  
  2031. go
  2033. /* 在表 "DocFieldsName" 中添加外键约束。                                                                */
  2034. alter table "DocFieldsName"
  2035. add constraint "DocumentTypeInfo_DocFieldsName_FK1" foreign key (
  2036. "DocumentTypeID")
  2037.  references "DocumentTypeInfo" (
  2038. "ID")  
  2040. go
  2042. /* 在表 "DocumentTypeInfo" 中添加外键约束。                                                             */
  2043. alter table "DocumentTypeInfo"
  2044. add constraint "SystemDirectory_DocumentTypeInfo_FK1" foreign key (
  2045. "SysDirID")
  2046.  references "SystemDirectory" (
  2047. "ID")  
  2049. go
  2051. /* 在表 "DocumentInfo" 中添加外键约束。                                                                 */
  2052. alter table "DocumentInfo"
  2053. add constraint "UserInfo_DocumentInfo_FK1" foreign key (
  2054. "PublishUserID")
  2055.  references "UserInfo" (
  2056. "ID")  
  2058. go
  2060. alter table "DocumentInfo"
  2061. add constraint "DocumentTypeInfo_DocumentInfo_FK1" foreign key (
  2062. "DocumentTypeID")
  2063.  references "DocumentTypeInfo" (
  2064. "ID")  
  2066. go
  2068. /* 在表 "VoteOptionsInfo" 中添加外键约束。                                                              */
  2069. alter table "VoteOptionsInfo"
  2070. add constraint "VoteInfo_VoteOptionsInfo_FK1" foreign key (
  2071. "VoteID")
  2072.  references "VoteInfo" (
  2073. "ID")  
  2075. go
  2077. /* 在表 "VoteInfo" 中添加外键约束。                                                                     */
  2078. alter table "VoteInfo"
  2079. add constraint "SystemDirectory_VoteInfo_FK1" foreign key (
  2080. "SysDirID")
  2081.  references "SystemDirectory" (
  2082. "ID")  
  2084. go
  2086. alter table "VoteInfo"
  2087. add constraint "UserInfo_VoteInfo_FK1" foreign key (
  2088. "PublishUserID")
  2089.  references "UserInfo" (
  2090. "ID")  
  2092. go
  2094. /* 在表 "BBSInfo" 中添加外键约束。                                                                      */
  2095. alter table "BBSInfo"
  2096. add constraint "SystemDirectory_BBSInfo_FK1" foreign key (
  2097. "SysDirID")
  2098.  references "SystemDirectory" (
  2099. "ID")  
  2101. go
  2103. alter table "BBSInfo"
  2104. add constraint "UserInfo_BBSInfo_FK1" foreign key (
  2105. "PublishUserID")
  2106.  references "UserInfo" (
  2107. "ID")  
  2109. go
  2111. /* 在表 "ArticleInfo" 中添加外键约束。                                                                  */
  2112. alter table "ArticleInfo"
  2113. add constraint "SystemDirectory_ArticleInfo_FK1" foreign key (
  2114. "SysDirID")
  2115.  references "SystemDirectory" (
  2116. "ID")  
  2118. go
  2120. alter table "ArticleInfo"
  2121. add constraint "UserInfo_ArticleInfo_FK1" foreign key (
  2122. "PublishUserID")
  2123.  references "UserInfo" (
  2124. "ID")  
  2126. go
  2128. /* 在表 "FamilyMember" 中添加外键约束。                                                                 */
  2129. alter table "FamilyMember"
  2130. add constraint "PersonelInfo_FamilyMember_FK1" foreign key (
  2131. "PersannelID")
  2132.  references "PersonnelInfo" (
  2133. "ID")  
  2135. go
  2137. /* 在表 "PersonnelInfo" 中添加外键约束。                                                                */
  2138. alter table "PersonnelInfo"
  2139. add constraint "MarriageState_PersonelInfo_FK1" foreign key (
  2140. "MarriageID")
  2141.  references "MarriageState" (
  2142. "ID")  
  2144. go
  2146. alter table "PersonnelInfo"
  2147. add constraint "PlaceInfo_PersonelInfo_FK1" foreign key (
  2148. "PlaceID")
  2149.  references "PlaceInfo" (
  2150. "ID")  
  2152. go
  2154. alter table "PersonnelInfo"
  2155. add constraint "EducationInfo_PersonelInfo_FK1" foreign key (
  2156. "EducationID")
  2157.  references "EducationInfo" (
  2158. "ID")  
  2160. go
  2162. alter table "PersonnelInfo"
  2163. add constraint "TechnicalPostInfo_PersonelInfo_FK1" foreign key (
  2164. "TechnicalPostID")
  2165.  references "TechnicalPostInfo" (
  2166. "ID")  
  2168. go
  2170. /* 在表 "UserInfo" 中添加外键约束。                                                                     */
  2171. alter table "UserInfo"
  2172. add constraint "RoleInfo_UserInfo_FK1" foreign key (
  2173. "RoleID")
  2174.  references "RoleInfo" (
  2175. "ID")  
  2177. go
  2179. alter table "UserInfo"
  2180. add constraint "PersonelInfo_UserInfo_FK1" foreign key (
  2181. "PersonnelID")
  2182.  references "PersonnelInfo" (
  2183. "ID")  
  2185. go
  2187. alter table "UserInfo"
  2188. add constraint "StyleInfo_UserInfo_FK1" foreign key (
  2189. "StyleID")
  2190.  references "StyleInfo" (
  2191. "ID")  
  2193. go
  2195. /* 在表 "AssetInfo" 中添加外键约束。                                                                    */
  2196. alter table "AssetInfo"
  2197. add constraint "AssetTypeInfo_AssetInfo_FK1" foreign key (
  2198. "AssetTypeID")
  2199.  references "AssetTypeInfo" (
  2200. "ID")  
  2202. go
  2204. alter table "AssetInfo"
  2205. add constraint "UserInfo_AssetInfo_FK1" foreign key (
  2206. "AddUserID")
  2207.  references "UserInfo" (
  2208. "ID")  
  2210. go
  2212. /* 在表 "AssetTypeInfo" 中添加外键约束。                                                                */
  2213. alter table "AssetTypeInfo"
  2214. add constraint "SystemDirectory_AssetTypeInfo_FK1" foreign key (
  2215. "SysDirID")
  2216.  references "SystemDirectory" (
  2217. "ID")  
  2219. go
  2221. /* 在表 "AssetFieldsName" 中添加外键约束。                                                              */
  2222. alter table "AssetFieldsName"
  2223. add constraint "AssetTypeInfo_AssetFieldsName_FK1" foreign key (
  2224. "AssetTypeID")
  2225.  references "AssetTypeInfo" (
  2226. "ID")  
  2228. go
  2230. /* 在表 "AssetFieldsValue" 中添加外键约束。                                                             */
  2231. alter table "AssetFieldsValue"
  2232. add constraint "AssetInfo_AssetFieldsValue_FK1" foreign key (
  2233. "AssetID")
  2234.  references "AssetInfo" (
  2235. "ID")  
  2237. go
  2239. alter table "AssetFieldsValue"
  2240. add constraint "AssetFieldsName_AssetFieldsValue_FK1" foreign key (
  2241. "FieldID")
  2242.  references "AssetFieldsName" (
  2243. "ID")  
  2245. go
  2247. /* 在表 "AddressKindInfo" 中添加外键约束。                                                              */
  2248. alter table "AddressKindInfo"
  2249. add constraint "UserInfo_AddressKindInfo_FK1" foreign key (
  2250. "UserID")
  2251.  references "UserInfo" (
  2252. "ID")  
  2254. go
  2256. /* 在表 "AddressList" 中添加外键约束。                                                                  */
  2257. alter table "AddressList"
  2258. add constraint "AddressKindInfo_AddressList_FK1" foreign key (
  2259. "KindsID")
  2260.  references "AddressKindInfo" (
  2261. "ID")  
  2263. go
  2266. /* 这是 Microsoft Visual Studio 生成的 SQL DDL 脚本的末尾。                                              */