📄 erp数1.htm
字号:
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_AssetMoveApply */<br />
/*==============================================================*/<br />
create table ZC_AssetMoveApply (<br />
oid int identity,<br />
docNo varchar(20) null,<br />
flowid int null,<br />
moveReason int null,<br />
moveDate datetime null,<br />
remark varchar(50) 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 />
constraint PK_ZC_ASSETMOVEAPPLY primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_AssetPurchaseApply */<br />
/*==============================================================*/<br />
create table ZC_AssetPurchaseApply (<br />
oid int identity,<br />
docNo varchar(20) null,<br />
flowid int null,<br />
creator int null,<br />
proposer int null,<br />
deptid int null,<br />
reason varchar(100) null,<br />
createDate datetime null,<br />
submitDate datetime null,<br />
status char(1) null,<br />
remark varchar(50) null,<br />
constraint PK_ZC_ASSETPURCHASEAPPLY primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_AssetMoveDetails */<br />
/*==============================================================*/<br />
create table ZC_AssetMoveDetails (<br />
oid int identity,<br />
parentid int null,<br />
assetId int null,<br />
formPlace int null,<br />
yuanRen int null,<br />
targetPlace int null,<br />
moveDate datetime null,<br />
remark varchar(200) null,<br />
constraint PK_ZC_ASSETMOVEDETAILS primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_AssetType */<br />
/*==============================================================*/<br />
create table ZC_AssetType (<br />
oid int identity,<br />
code char(2) null,<br />
typeName varchar(30) null,<br />
status char(1) null<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_Pandianjilu */<br />
/*==============================================================*/<br />
create table ZC_Pandianjilu (<br />
oid int identity,<br />
parentid int null,<br />
leibie int null,<br />
yingyu int null,<br />
shiji int null,<br />
panyin int null,<br />
pankui int null,<br />
leijipanying int null,<br />
leijipankui int null,<br />
pandianren int null,<br />
creator int null,<br />
createDate datetime null,<br />
constraint PK_ZC_PANDIANJILU primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: ZC_Pandian */<br />
/*==============================================================*/<br />
create table ZC_Pandian (<br />
oid int identity,<br />
year int null,<br />
quarter int null,<br />
pandianren int null,<br />
creator int null,<br />
createDate datetime null,<br />
constraint PK_ZC_PANDIAN primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: KH_CustomerFavorite */<br />
/*==============================================================*/<br />
create table KH_CustomerFavorite (<br />
oid int identity,<br />
customerid int null,<br />
productid int null,<br />
status int null,<br />
constraint PK_KH_CUSTOMERFAVORITE primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: KH_Customer */<br />
/*==============================================================*/<br />
create table KH_Customer (<br />
oid int identity,<br />
customerName varchar(20) null,<br />
companyType int null,<br />
vocation int null,<br />
city varchar(20) null,<br />
address varchar(100) null,<br />
zipcode char(6) null,<br />
phone varchar(20) null,<br />
fax varchar(20) null,<br />
email varchar(50) null,<br />
url varchar(50) null,<br />
bank varchar(20) null,<br />
account varchar(20) null,<br />
credit int null,<br />
introduce varchar(500) null,<br />
constraint PK_KH_CUSTOMER primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: KH_CustomerContact */<br />
/*==============================================================*/<br />
create table KH_CustomerContact (<br />
oid int identity,<br />
customerid int null,<br />
contactName varchar(20) null,<br />
phone varchar(20) null,<br />
email varchar(50) null,<br />
job varchar(10) null,<br />
address varchar(50) null,<br />
zipcode char(6) null,<br />
constraint PK_KH_CUSTOMERCONTACT primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: KH_Product */<br />
/*==============================================================*/<br />
create table KH_Product (<br />
oid int identity,<br />
linkname varchar(20) null,<br />
url varchar(20) null,<br />
describe varchar(100) null,<br />
packdesc varchar(100) null,<br />
memo varchar(200) null,<br />
picture varchar(50) null,<br />
constraint PK_KH_PRODUCT primary key (oid)<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: KH_ContactRecord */<br />
/*==============================================================*/<br />
create table KH_ContactRecord (<br />
oid int identity,<br />
favoriteid int null,<br />
empid int null,<br />
contactDate datetime null,<br />
reason varchar(50) null,<br />
result varchar(100) null,<br />
constraint PK_KH_CONTACTRECORD primary key (oid)<br />
)<br />
go<br />
</p>
</td></tr>
</table><br />
<h1>
<a name="5">ERP系统数据字典</a>
</h1>
<h2>
<a name="6">信息_信息</a>
</h2>
<h3>
<a name="7">表格[信息_信息]的卡片</a>
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#6">信息_信息</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#6">XX_Information</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="8">表格[信息_信息]的列清单</a>
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left">主键
</p>
</td>
<td>
<p align="left">oid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">信息类别
</p>
</td>
<td class="TD2">
<p align="left">typeid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">信息标题
</p>
</td>
<td>
<p align="left">title
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">内容
</p>
</td>
<td class="TD2">
<p align="left">content
</p>
</td>
</tr>
<tr>
<td>
<p align="left">发布日期
</p>
</td>
<td>
<p align="left">publishDate
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">停止发布日期
</p>
</td>
<td class="TD2">
<p align="left">closeDate
</p>
</td>
</tr>
<tr>
<td>
<p align="left">发布人
</p>
</td>
<td>
<p align="left">creator
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">图片路径
</p>
</td>
<td class="TD2">
<p align="left">imagepath
</p>
</td>
</tr>
<tr>
<td>
<p align="left">图片说明
</p>
</td>
<td>
<p align="left">imagedesc
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">附件路径
</p>
</td>
<td class="TD2">
<p align="left">accpath
</p>
</td>
</tr>
<tr>
<td>
<p align="left">附件说明
</p>
</td>
<td>
<p align="left">accdesc
</p>
</td>
</tr>
</table><br />
<h3>
<a name="9">表格[信息_信息]的代码预览</a>
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<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 />
</p>
</td></tr>
</table><br />
<h2>
<a name="10">信息_信息栏目</a>
</h2>
<h3>
<a name="11">表格[信息_信息栏目]的卡片</a>
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#10">信息_信息栏目</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#10">XX_InfoType</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="12">表格[信息_信息栏目]的列清单</a>
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left">主键
</p>
</td>
<td>
<p align="left">oid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">上级栏目
</p>
</td>
<td class="TD2">
<p align="left">parentoid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">栏目名称
</p>
</td>
<td>
<p align="left">typeName
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">发布权限
</p>
</td>
<td class="TD2">
<p align="left">pulisher
</p>
</td>
</tr>
<tr>
<td>
<p align="left">修改权限
</p>
</td>
<td>
<p align="left">modifier
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">显示顺序
</p>
</td>
<td class="TD2">
<p align="left">sort
</p>
</td>
</tr>
</table><br />
<h3>
<a name="13">表格[信息_信息栏目]的代码预览</a>
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Table: XX_InfoType */<br />
/*==============================================================*/<br />
create table XX_InfoType (<br />
oid int identity,<br />
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -