⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 erp数1.htm

📁 OA数据库源SQL语句完整OA数据库源SQL语句完整OA数据库源SQL语句完整OA数据库源SQL语句完整
💻 HTM
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
   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 />

</p>
</td></tr>
</table><br />
<h2>
<a name="14">名片_名片夹</a> 
</h2>
<h3>
<a name="15">表格[名片_名片夹]的卡片</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#14">名片_名片夹</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#14">MP_CardType</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="16">表格[名片_名片夹]的列清单</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">type
</p>
</td>
</tr>
<tr>
<td>
<p align="left">所属用户ID
</p>
</td>
<td>
<p align="left">uid
</p>
</td>
</tr>
</table><br />
<h3>
<a name="17">表格[名片_名片夹]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<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 />

</p>
</td></tr>
</table><br />
<h2>
<a name="18">名片_联系人</a> 
</h2>
<h3>
<a name="19">表格[名片_联系人]的卡片</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#18">名片_联系人</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#18">MP_Contact</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="20">表格[名片_联系人]的列清单</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">类别ID
</p>
</td>
<td class="TD2">
<p align="left">typeid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">姓名
</p>
</td>
<td>
<p align="left">name
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">性别
</p>
</td>
<td class="TD2">
<p align="left">sex
</p>
</td>
</tr>
<tr>
<td>
<p align="left">公司
</p>
</td>
<td>
<p align="left">company
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">家庭电话
</p>
</td>
<td class="TD2">
<p align="left">homePhone
</p>
</td>
</tr>
<tr>
<td>
<p align="left">办公电话
</p>
</td>
<td>
<p align="left">officePhone
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">家庭住址
</p>
</td>
<td class="TD2">
<p align="left">homeAddress
</p>
</td>
</tr>
<tr>
<td>
<p align="left">邮编
</p>
</td>
<td>
<p align="left">homeZipcode
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">办公地址
</p>
</td>
<td class="TD2">
<p align="left">officeAddress
</p>
</td>
</tr>
<tr>
<td>
<p align="left">办公邮编
</p>
</td>
<td>
<p align="left">officeZipcode
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">手机
</p>
</td>
<td class="TD2">
<p align="left">mobile
</p>
</td>
</tr>
<tr>
<td>
<p align="left">Email1
</p>
</td>
<td>
<p align="left">email1
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">Email2
</p>
</td>
<td class="TD2">
<p align="left">email2
</p>
</td>
</tr>
<tr>
<td>
<p align="left">其他信息
</p>
</td>
<td>
<p align="left">other
</p>
</td>
</tr>
</table><br />
<h3>
<a name="21">表格[名片_联系人]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<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 />

</p>
</td></tr>
</table><br />
<h2>
<a name="22">基础_基础数据</a> 
</h2>
<h3>
<a name="23">表格[基础_基础数据]的卡片</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#22">基础_基础数据</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#22">JC_BasicDataValue</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="24">表格[基础_基础数据]的列清单</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">type
</p>
</td>
</tr>
<tr>
<td>
<p align="left">名称
</p>
</td>
<td>
<p align="left">name
</p>
</td>
</tr>
</table><br />
<h3>
<a name="25">表格[基础_基础数据]的代码预览</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 />

</p>
</td></tr>
</table><br />
<h2>
<a name="26">审批_审批单据的共同信息</a> 
</h2>
<h3>
<a name="27">表格[审批_审批单据的共同信息]的卡片</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#26">审批_审批单据的共同信息</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#26">LC_BusinessDocument</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="28">表格[审批_审批单据的共同信息]的列清单</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">docNo
</p>
</td>
</tr>
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -