📄 erp数1.htm
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-936">
<title>Report 2
</title>
<link href="Blue_Theme.css" type="text/css" rel="stylesheet">
</head>
<!--This file has been automatically generated by PowerDesigner.-->
<body>
<h1>
<a name="3">代码总揽</a>
</h1>
<h3>
<a name="4">代码总览</a>
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Table: JC_BasicDataValue */<br />
/*==============================================================*/<br />
create table JC_BasicDataValue (<br />
oid int identity,<br />
type int null,<br />
name varchar(10) null,<br />
constraint PK_JC_BASICDATAVALUE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZZ_Department_Job */<br />
/*==============================================================*/<br />
create table ZZ_Department_Job (<br />
deptid int null,<br />
jobid int null<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZZ_Department */<br />
/*==============================================================*/<br />
create table ZZ_Department (<br />
oid int identity,<br />
parentoid int null,<br />
deptName varchar(20) null,<br />
phone varchar(20) null,<br />
email varchar(100) null,<br />
fax varchar(20) null,<br />
manager int null,<br />
address varchar(100) null,<br />
zipcode varchar(10) null,<br />
status char(1) null,<br />
description varchar(100) null,<br />
constraint PK_ZZ_DEPARTMENT primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: RC_Arrange */<br />
/*==============================================================*/<br />
create table RC_Arrange (<br />
oid int identity,<br />
uid int null,<br />
topic varchar(20) null,<br />
address varchar(100) null,<br />
arrangeDate datetime null,<br />
startTime datetime null,<br />
endTime datetime null,<br />
importance char(1) null,<br />
isNotify char(1) null,<br />
attend varchar(100) null,<br />
description varchar(200) null,<br />
constraint PK_RC_ARRANGE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: LC_Node */<br />
/*==============================================================*/<br />
create table LC_Node (<br />
oid int identity,<br />
parentid int null,<br />
name varchar(20) null,<br />
prenodeid int null,<br />
proposer int null,<br />
deptid int null,<br />
jobid int null,<br />
isByDept char(1) null,<br />
constraint PK_LC_NODE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZZ_Employee */<br />
/*==============================================================*/<br />
create table ZZ_Employee (<br />
oid int identity,<br />
deptid int null,<br />
empName varchar(20) null,<br />
sex char(1) null,<br />
birthday datetime null,<br />
school varchar(20) null,<br />
major varchar(10) null,<br />
degree int null,<br />
phone varchar(20) null,<br />
constraint PK_ZZ_EMPLOYEE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZZ_Exprience */<br />
/*==============================================================*/<br />
create table ZZ_Exprience (<br />
oid int not null,<br />
empid int identity,<br />
startDate datetime null,<br />
endDate datetime null,<br />
companyName varchar(20) null,<br />
deptName varchar(10) null,<br />
jobName varchar(10) null,<br />
proofer varchar(10) null,<br />
phone varchar(20) null,<br />
description varchar(500) null,<br />
constraint PK_ZZ_EXPRIENCE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZZ_Adjustment */<br />
/*==============================================================*/<br />
create table ZZ_Adjustment (<br />
oid int identity,<br />
empid int null,<br />
adjustDate datetime null,<br />
origindeptid int null,<br />
destdeptid int null,<br />
originjobid int null,<br />
destjobid int null,<br />
reason varchar(100) null,<br />
constraint PK_ZZ_ADJUSTMENT primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZZ_JobInfo */<br />
/*==============================================================*/<br />
create table ZZ_JobInfo (<br />
empid int not null,<br />
workDate datetime null,<br />
joinDate datetime null,<br />
fileDate datetime null,<br />
contractStart datetime null,<br />
contractEnd datetime null,<br />
assureDate datetime null,<br />
secretDate datetime null,<br />
constraint PK_ZZ_JOBINFO primary key (empid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: MP_CardType */<br />
/*==============================================================*/<br />
create table MP_CardType (<br />
oid int identity,<br />
type varchar(10) null,<br />
uid int null,<br />
constraint PK_MP_CARDTYPE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: MP_Contact */<br />
/*==============================================================*/<br />
create table MP_Contact (<br />
oid int identity,<br />
typeid int null,<br />
name varchar(20) null,<br />
sex char(1) null,<br />
company varchar(20) null,<br />
homePhone varchar(20) null,<br />
officePhone varchar(20) null,<br />
homeAddress varchar(100) null,<br />
homeZipcode varchar(20) null,<br />
officeAddress varchar(100) null,<br />
officeZipcode varchar(20) null,<br />
mobile varchar(20) null,<br />
email1 varchar(100) null,<br />
email2 varchar(100) null,<br />
other varchar(100) null,<br />
constraint PK_MP_CONTACT primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: BX_Informal */<br />
/*==============================================================*/<br />
create table BX_Informal (<br />
oid int identity,<br />
docNo varchar(20) null,<br />
flowid int null,<br />
payee int null,<br />
booker int null,<br />
creator int null,<br />
proposer int null,<br />
deptid int null,<br />
reason varchar(100) null,<br />
bookDate decimal(2) null,<br />
applyAmount decimal(2) null,<br />
bookAmount decimal(2) null,<br />
createDate datetime null,<br />
submitDate datetime null,<br />
status char(1) null,<br />
constraint PK_BX_INFORMAL primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: QX_Role */<br />
/*==============================================================*/<br />
create table QX_Role (<br />
oid int identity,<br />
roleName varchar(10) null,<br />
description varchar(100) null,<br />
constraint PK_QX_ROLE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: QX_Role_User */<br />
/*==============================================================*/<br />
create table QX_Role_User (<br />
roleid int null,<br />
uid int null<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZZ_Account */<br />
/*==============================================================*/<br />
create table ZZ_Account (<br />
uid int not null,<br />
username varchar(20) null,<br />
password varchar(20) null,<br />
email varchar(100) null,<br />
inactive char(1) null,<br />
constraint PK_ZZ_ACCOUNT primary key (uid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: QX_Role_Function */<br />
/*==============================================================*/<br />
create table QX_Role_Function (<br />
roleid int null,<br />
functionid int null<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: QX_Function */<br />
/*==============================================================*/<br />
create table QX_Function (<br />
oid int identity,<br />
functionName varchar(20) null,<br />
class varchar(100) null,<br />
method varchar(50) null,<br />
constraint PK_QX_FUNCTION primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: LC_Flow */<br />
/*==============================================================*/<br />
create table LC_Flow (<br />
oid int identity,<br />
flowName varchar(20) null,<br />
docType varchar(8) null,<br />
describe varchar(20) null,<br />
constraint PK_LC_FLOW primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: LC_Approval */<br />
/*==============================================================*/<br />
create table LC_Approval (<br />
oid int identity,<br />
docType varchar(8) null,<br />
docid int null,<br />
flowid int null,<br />
nodeid int null,<br />
approvaluid int null,<br />
status char(1) null,<br />
opinion varchar(50) null,<br />
submitDate datetime null,<br />
approvalDate datetime null,<br />
constraint PK_LC_APPROVAL primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: LC_BusinessDocument */<br />
/*==============================================================*/<br />
create table LC_BusinessDocument (<br />
oid int not null,<br />
docNo varchar(20) null,<br />
creator int null,<br />
proposer int null,<br />
deptid int null,<br />
createDate datetime null,<br />
submitDate datetime null,<br />
status char(1) null,<br />
flowid int null,<br />
constraint PK_LC_BUSINESSDOCUMENT primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: BX_InformalDetail */<br />
/*==============================================================*/<br />
create table BX_InformalDetail (<br />
oid int identity,<br />
parentid int null,<br />
typeid int null,<br />
applyAmount decimal(6) null,<br />
amount decimal(6) null,<br />
planid int null,<br />
constraint PK_BX_INFORMALDETAIL primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: BX_InformalType */<br />
/*==============================================================*/<br />
create table BX_InformalType (<br />
oid int identity,<br />
name varchar(20) null,<br />
isActice char(1) null,<br />
constraint PK_BX_INFORMALTYPE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: BX_InformalAccessary */<br />
/*==============================================================*/<br />
create table BX_InformalAccessary (<br />
oid int identity,<br />
parentid int null,<br />
content binary null,<br />
description varchar(50) null,<br />
constraint PK_BX_INFORMALACCESSARY primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: XX_InfoType */<br />
/*==============================================================*/<br />
create table XX_InfoType (<br />
oid int identity,<br />
parentoid int null,<br />
typeName varchar(20) null,<br />
pulisher varchar(200) null,<br />
modifier varchar(200) null,<br />
sort int null,<br />
constraint PK_XX_INFOTYPE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: XX_Information */<br />
/*==============================================================*/<br />
create table XX_Information (<br />
oid int identity,<br />
typeid int null,<br />
title varchar(50) null,<br />
content varchar(4096) null,<br />
publishDate datetime null,<br />
closeDate datetime null,<br />
creator int null,<br />
imagepath varchar(100) null,<br />
imagedesc varchar(50) null,<br />
accpath varchar(100) null,<br />
accdesc varchar(50) null,<br />
constraint PK_XX_INFORMATION primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: GJ_Links */<br />
/*==============================================================*/<br />
create table GJ_Links (<br />
oid int identity,<br />
linkname varchar(20) null,<br />
url varchar(50) null,<br />
constraint PK_GJ_LINKS primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: GJ_City */<br />
/*==============================================================*/<br />
create table GJ_City (<br />
oid int identity,<br />
citycode varchar(10) null,<br />
regioncode char(4) null,<br />
zipcode char(6) null,<br />
constraint PK_GJ_CITY primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_AssetPurchaseApplyDetails */<br />
/*==============================================================*/<br />
create table ZC_AssetPurchaseApplyDetails (<br />
oid int identity(1 , 1),<br />
parentid int null,<br />
assetName varchar(50) null,<br />
assetNumber varchar(30) null,<br />
guige varchar(50) null,<br />
shengou int null,<br />
unitPrice decimal(6,1) null,<br />
quantity int null,<br />
purchaseDate datetime null,<br />
constraint PK_ZC_ASSETPURCHASEAPPLYDETAIL primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_AssetBaojia */<br />
/*==============================================================*/<br />
create table ZC_AssetBaojia (<br />
oid int identity,<br />
parentid int null,<br />
price decimal(6,1) null,<br />
linkman varchar(10) null,<br />
linkPhone varchar(15) null,<br />
remark varchar(100) null,<br />
constraint PK_ZC_ASSETBAOJIA primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_Asset */<br />
/*==============================================================*/<br />
create table ZC_Asset (<br />
oid int identity,<br />
type int null,<br />
assetCode varchar(50) null,<br />
assetNumber varchar(50) null,<br />
assetNanme varchar(50) null,<br />
guige varchar(30) null,<br />
produceTime datetime null,<br />
depositary varchar(50) null,<br />
keeper int null,<br />
price decimal(5,1) null,<br />
regDate datetime null,<br />
addType int null,<br />
remark varchar(200) null,<br />
jinban int null,<br />
creator int null,<br />
createDate datetime null,<br />
status char(1) null,<br />
constraint PK_ZC_ASSET primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_AssetMoveLog */<br />
/*==============================================================*/<br />
create table ZC_AssetMoveLog (<br />
oid int identity,<br />
assetId int null,<br />
formerPlace int null,<br />
targetPlace int null,<br />
moveDate datetime null,<br />
moveReason int null,<br />
zerenren int null,<br />
handler int null,<br />
remark varchar(200) null,<br />
constraint PK_ZC_ASSETMOVELOG primary key (oid)<br />
)<br />
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -