----------鼎桥部件表(tb_dqassembly)-------------
drop table if exists tb_dqassembly;
create table tb_dqassembly
(
id int unsigned not null auto_increment primary key, //部件编号--主键
hwcode varchar(24), //华为编码--2013-3-18
dqcode varchar(30), //鼎桥编码--2013-3-18
goodsline varchar(50), //产品线
goods varchar(50), //产品
defaultunit varchar(30), //默认单位
resource varchar(30), //来源
template varchar(30), //模板
organise varchar(30), //组织
lifetime varchar(30), //生命周期
/*IBA管理属性*/
sortteanname varchar(50), //分类组名--2013-3-22
smallsortname varchar(50), //小类名称--2013-3-22 14:14
smallSortCode varchar(50), //小类代码
machinetype varchar(50), //机型
parttype varchar(30), //PART类型
bantype varchar(30), //板类型
innertype varchar(50), //对内型号
outtername varchar(50), //对外名称
outterenname varchar(50), //对外英文名称
drawingedition varchar(16), //图纸版本
isenvironment varchar(16), //是否满足环保要求
isnobittern varchar(16), //是否无卤
tackexplain varchar(200) //附加说明
author varchar(30), //创建者--2013-3-22
edition varchar(50), //版本--2013-3-22
status varchar(30), //流程状态--2013-3-22
assemblystatus varchar(30), //部件状态--2013-3-22 14:14
instance varchar(30), //状况--2013-3-22 14:14
createtime varchar(50), //创建时间--2013-3-22 14:14
lastupdatetime varchar(50), //上次修改时间--2013-3-22 14:14
updateperson varchar(30), //修改者--2013-3-22 14:14
sortinfo varchar(50), //分类信息--2013-3-22 14:14
/*规格属性(暂时不添加到数据库)*/
specattribute varchar(100), //规格--2013-3-22 14:14
assemblylength double, //长度--2013-3-22 14:14
assemblyweight double, //净重--2013-3-22 14:14
pintotal int, //PIN总数--2013-3-25 9:24
layercount int, //层数--2013-3-25 9:24
workshoptypeflag varchar(50), //厂家型号标识--2013-3-25 9:24
serialmode varchar(50), //工艺组装方式--2013-3-25 9:24
plyscale varchar(30), //厚径比--2013-3-25 9:24
spellboard varchar(50), //拼版信息--2013-3-25 9:24
isbackboard varchar(16), //是否背板--2013-3-25 9:24
isequipment varchar(16), //是否存在压接器件--2013-3-25 9:24
isflagboard varchar(16), //是否射频板--2013-3-25 9:24
isplumbum varchar(16), //是否无铅--2013-3-25 9:24
ispedance varchar(16), //是否阻抗控制--2013-3-25 9:24
standlevel varchar(30), //适用的刚性印制板检验标准等级--2013-3-25 9:24
especialart varchar(50), //特殊工艺--2013-3-25 9:24
especialask varchar(30), //特殊要求--2013-3-25 9:24
outtypesize varchar(30), //外型尺寸--2013-3-25 9:24
broachaccount int, //钻孔总数--2013-3-25 9:24
minaperture float(12,2), //最小孔径--2013-3-25 9:24
minspace float(12,2), //最小线间距--2013-3-25 9:24
minwidth float(12,2), //最小线宽--2013-3-25 9:24
endecrible varchar(150) //英文描述--2013-3-25 9:24
);
---------------新物料选型认证申请单(tb_newMateAppBill)----------------
drop table if exists tb_newMateAppBill;
create table tb_newMateAppBill
(
id int unsigned not null auto_increment primary key, //主键
applyid varchar(30), //申请单编号
goodsline varchar(50), //产品线
goods varchar(50), //产品
roadsignedition varchar(50), //路标版本
edition varchar(50), //版本
smallSortCode varchar(30), //小类代码
taskname varchar(30), //任务名称
actor varchar(30), //参与者
routerchoose varchar(30), //路由选择
taskvariable varchar(30), //任务变量
begintime varchar(30), //启动时间
endtime varchar(30), //结束时间
lastlimit varchar(30)， //最后期限
assemblyid int //鼎桥部件--作为外键
);
--分析部件表tb_dqassembly跟新物料选型认证申请单tb_newMateAppBill的关联关系：
一个申请单可以对应多个部件
这样就构成了一对多的关联关系
1. 新物料选型认证申请单tb_newMateAppBill
package com.tdtech.pdm.create.pojo;
import java.io.Serializable;
/**
* 新物料选型认证POJO--对应数据表tb_newMateAppBill
* @author tWX162737
*
*/
public class NewMateAppBillPojo implements Serializable{
private Integer id; //主键
private String applyid; //申请单编号
private String goodsline; //产品线
private String goods; //产品
private String roadsignedition; //路标版本
private String edition; //版本
private String smallSortCode; //部件的小类代码
public NewMateAppBillPojo(){
}
public NewMateAppBillPojo(Integer id, String applyid, String goodsline,
String goods, String roadsignedition, String edition,
String smallSortCode) {
this.id = id;
this.applyid = applyid;
this.goodsline = goodsline;
this.goods = goods;
this.roadsignedition = roadsignedition;
this.edition = edition;
this.smallSortCode = smallSortCode;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getApplyid() {
return applyid;
}
public void setApplyid(String applyid) {
this.applyid = applyid;
}
public String getGoodsline() {
return goodsline;
}
public void setGoodsline(String goodsline) {
this.goodsline = goodsline;
}
public String getGoods() {
return goods;
}
public void setGoods(String goods) {
this.goods = goods;
}
public String getRoadsignedition() {
return roadsignedition;
}
public void setRoadsignedition(String roadsignedition) {
this.roadsignedition = roadsignedition;
}
public String getEdition() {
return edition;
}
public void setEdition(String edition) {
this.edition = edition;
}
public String getSmallSortCode() {
return smallSortCode;
}
public void setSmallSortCode(String smallSortCode) {
this.smallSortCode = smallSortCode;
}
}
2.部件表tb_dqassembly
package com.tdtech.pdm.create.pojo;
import java.io.Serializable;
/**
* 鼎桥部件Pojo类--对应表tb_dqassembly
* @author tWX162737
*
*/
public class DQAssemblyPojo implements Serializable {
private int id; //主键
private String hwcode; //华为编码
private String dqcode; //鼎桥编码
private String goodsline; //产品线
private String goods; //产品
private String defaultunit; //默认单位
private String resource; //来源
private String template; //模板
private String organise; //组织
private String lifetime; //生命周期
private String smallSortCode;
private String machinetype;
private String parttype;
private String bantype;
private String innertype;
private String outtername;
private String outterenname;
private String drawingedition;
private String isenvironment;
private String isnobittern;
private String tackexplain;
private String sortteanname; //分类组名--2013-3-22
private String smallsortname; //小类名称--2013-3-22 14:14
private String author; //作者--2013-3-22
private String edition ; //版本--2013-3-22
private String status ; //流程状态--2013-3-22
private String assemblystatus ; //部件状态--2013-3-22 14:14
private String instance ; //状况--2013-3-22 14:14
private String createtime ; //创建时间--2013-3-22 14:14
private String lastupdatetime ; //上次修改时间--2013-3-22 14:14
private String updateperson ; //修改者--2013-3-22 14:14
private String sortinfo ; //分类信息--2013-3-22 14:14
private Integer pintotal; //PIN总数--2013-3-25 9:24
private Integer layercount; //层数--2013-3-25 9:24
private String workshoptypeflag ; //厂家型号标识--2013-3-25 9:24
private String serialmode ; //工艺组装方式--2013-3-25 9:24
private String plyscale ; //厚径比--2013-3-25 9:24
private String spellboard ; //拼版信息--2013-3-25 9:24
private String isbackboard ; //是否背板--2013-3-25 9:24
private String isequipment; //是否存在压接器件--2013-3-25 9:24
private String isflagboard; //是否射频板--2013-3-25 9:24
private String isplumbum; //是否无铅--2013-3-25 9:24
private String ispedance; //是否阻抗控制--2013-3-25 9:24
private String standlevel; //适用的刚性印制板检验标准等级--2013-3-25 9:24
private String especialart; //特殊工艺--2013-3-25 9:24
private String especialask; //特殊要求--2013-3-25 9:24
private String outtypesize; //外型尺寸--2013-3-25 9:24
private Integer broachaccount; //钻孔总数--2013-3-25 9:24
private Float minaperture; //最小孔径--2013-3-25 9:24
private Float minspace; //最小线间距--2013-3-25 9:24
private Float minwidth; //最小线宽--2013-3-25 9:24
private String endecrible; //英文描述--2013-3-25 9:24
/**
* 无参构造方法
*/
public DQAssemblyPojo(){
}
/**
* 全参构造方法
* @param id
* @param goodsline
* @param goods
* @param defaultunit
* @param resource
* @param template
* @param organise
* @param lifetime
*/
public DQAssemblyPojo(int id, String hwcode, String dqcode,
String goodsline, String goods, String defaultunit,
String resource, String template, String organise, String lifetime,
String smallSortCode, String machinetype, String parttype,
String bantype, String innertype, String outtername,
String outterenname, String drawingedition, String isenvironment,
String isnobittern, String tackexplain, String sortteanname,
String smallsortname, String author, String edition, String status,
String assemblystatus, String instance, String createtime,
String lastupdatetime, String updateperson, String sortinfo,
Integer pintotal, Integer layercount, String workshoptypeflag,
String serialmode, String plyscale, String spellboard,
String isbackboard, String isequipment, String isflagboard,
String isplumbum, String ispedance, String standlevel,
String especialart, String especialask, String outtypesize,
Integer broachaccount, Float minaperture, Float minspace,
Float minwidth, String endecrible) {
this.id = id;
this.hwcode = hwcode;
this.dqcode = dqcode;
this.goodsline = goodsline;
this.goods = goods;
this.defaultunit = defaultunit;
this.resource = resource;
this.template = template;
this.organise = organise;
this.lifetime = lifetime;
this.smallSortCode = smallSortCode;
this.machinetype = machinetype;
this.parttype = parttype;
this.bantype = bantype;
this.innertype = innertype;
this.outtername = outtername;
this.outterenname = outterenname;
this.drawingedition = drawingedition;
this.isenvironment = isenvironment;
this.isnobittern = isnobittern;
this.tackexplain = tackexplain;
this.sortteanname = sortteanname;
this.smallsortname = smallsortname;
this.author = author;
this.edition = edition;
this.status = status;
this.assemblystatus = assemblystatus;
this.instance = instance;
this.createtime = createtime;
this.lastupdatetime = lastupdatetime;
this.updateperson = updateperson;
this.sortinfo = sortinfo;
this.pintotal = pintotal;
this.layercount = layercount;
this.workshoptypeflag = workshoptypeflag;
this.serialmode = serialmode;
this.plyscale = plyscale;
this.spellboard = spellboard;
this.isbackboard = isbackboard;
this.isequipment = isequipment;
this.isflagboard = isflagboard;
this.isplumbum = isplumbum;
this.ispedance = ispedance;
this.standlevel = standlevel;
this.especialart = especialart;
this.especialask = especialask;
this.outtypesize = outtypesize;
this.broachaccount = broachaccount;
this.minaperture = minaperture;
this.minspace = minspace;
this.minwidth = minwidth;
this.endecrible = endecrible;
}
/**
* setter与getter方法
* @return
*/
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getGoodsline() {
return goodsline;
}
public String getHwcode() {
return hwcode;
}
public void setHwcode(String hwcode) {
this.hwcode = hwcode;
}
public String getDqcode() {
return dqcode;
}
public void setDqcode(String dqcode) {
this.dqcode = dqcode;
}
public void setGoodsline(String goodsline) {
this.goodsline = goodsline;
}
public String getGoods() {
return goods;
}
public void setGoods(String goods) {
this.goods = goods;
}
public String getDefaultunit() {
return defaultunit;
}
public void setDefaultunit(String defaultunit) {
this.defaultunit = defaultunit;
}
public String getResource() {
return resource;
}
public void setResource(String resource) {
this.resource = resource;
}
public String getTemplate() {
return template;
}
public void setTemplate(String template) {
this.template = template;
}
public String getOrganise() {
return organise;
}
public void setOrganise(String organise) {
this.organise = organise;
}
public String getLifetime() {
return lifetime;
}
public void setLifetime(String lifetime) {
this.lifetime = lifetime;
}
public String getSmallSortCode() {
return smallSortCode;
}
public void setSmallSortCode(String smallSortCode) {
this.smallSortCode = smallSortCode;
}
public String getMachinetype() {
return machinetype;
}
public void setMachinetype(String machinetype) {
this.machinetype = machinetype;
}
public String getParttype() {
return parttype;
}
public void setParttype(String parttype) {
this.parttype = parttype;
}
public String getBantype() {
return bantype;
}
public void setBantype(String bantype) {
this.bantype = bantype;
}
public String getInnertype() {
return innertype;
}
public void setInnertype(String innertype) {
this.innertype = innertype;
}
public String getOuttername() {
return outtername;
}
public void setOuttername(String outtername) {
this.outtername = outtername;
}
public String getOutterenname() {
return outterenname;
}
public void setOutterenname(String outterenname) {
this.outterenname = outterenname;
}
public String getDrawingedition() {
return drawingedition;
}
public void setDrawingedition(String drawingedition) {
this.drawingedition = drawingedition;
}
public String getIsenvironment() {
return isenvironment;
}
public void setIsenvironment(String isenvironment) {
this.isenvironment = isenvironment;
}
public String getIsnobittern() {
return isnobittern;
}
public void setIsnobittern(String isnobittern) {
this.isnobittern = isnobittern;
}
public String getTackexplain() {
return tackexplain;
}
public void setTackexplain(String tackexplain) {
this.tackexplain = tackexplain;
}
public String getSortteanname() {
return sortteanname;
}
public void setSortteanname(String sortteanname) {
this.sortteanname = sortteanname;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getEdition() {
return edition;
}
public void setEdition(String edition) {
this.edition = edition;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
public String getAssemblystatus() {
return assemblystatus;
}
public void setAssemblystatus(String assemblystatus) {
this.assemblystatus = assemblystatus;
}
public String getInstance() {
return instance;
}
public void setInstance(String instance) {
this.instance = instance;
}
public String getCreatetime() {
return createtime;
}
public void setCreatetime(String createtime) {
this.createtime = createtime;
}
public String getLastupdatetime() {
return lastupdatetime;
}
public void setLastupdatetime(String lastupdatetime) {
this.lastupdatetime = lastupdatetime;
}
public String getUpdateperson() {
return updateperson;
}
public void setUpdateperson(String updateperson) {
this.updateperson = updateperson;
}
public String getSortinfo() {
return sortinfo;
}
public void setSortinfo(String sortinfo) {
this.sortinfo = sortinfo;
}
public String getSmallsortname() {
return smallsortname;
}
public void setSmallsortname(String smallsortname) {
this.smallsortname = smallsortname;
}
public String getWorkshoptypeflag() {
return workshoptypeflag;
}
public void setWorkshoptypeflag(String workshoptypeflag) {
this.workshoptypeflag = workshoptypeflag;
}
public String getSerialmode() {
return serialmode;
}
public void setSerialmode(String serialmode) {
this.serialmode = serialmode;
}
public String getPlyscale() {
return plyscale;
}
public void setPlyscale(String plyscale) {
this.plyscale = plyscale;
}
public String getSpellboard() {
return spellboard;
}
public void setSpellboard(String spellboard) {
this.spellboard = spellboard;
}
public String getIsbackboard() {
return isbackboard;
}
public void setIsbackboard(String isbackboard) {
this.isbackboard = isbackboard;
}
public String getIsequipment() {
return isequipment;
}
public void setIsequipment(String isequipment) {
this.isequipment = isequipment;
}
public String getIsflagboard() {
return isflagboard;
}
public void setIsflagboard(String isflagboard) {
this.isflagboard = isflagboard;
}
public String getIsplumbum() {
return isplumbum;
}
public void setIsplumbum(String isplumbum) {
this.isplumbum = isplumbum;
}
public String getIspedance() {
return ispedance;
}
public void setIspedance(String ispedance) {
this.ispedance = ispedance;
}
public String getStandlevel() {
return standlevel;
}
public void setStandlevel(String standlevel) {
this.standlevel = standlevel;
}
public String getEspecialart() {
return especialart;
}
public void setEspecialart(String especialart) {
this.especialart = especialart;
}
public String getEspecialask() {
return especialask;
}
public void setEspecialask(String especialask) {
this.especialask = especialask;
}
public String getOuttypesize() {
return outtypesize;
}
public void setOuttypesize(String outtypesize) {
this.outtypesize = outtypesize;
}
public String getEndecrible() {
return endecrible;
}
public void setEndecrible(String endecrible) {
this.endecrible = endecrible;
}
public Integer getPintotal() {
return pintotal;
}
public void setPintotal(Integer pintotal) {
this.pintotal = pintotal;
}
public Integer getLayercount() {
return layercount;
}
public void setLayercount(Integer layercount) {
this.layercount = layercount;
}
public Integer getBroachaccount() {
return broachaccount;
}
public void setBroachaccount(Integer broachaccount) {
this.broachaccount = broachaccount;
}
public Float getMinaperture() {
return minaperture;
}
public void setMinaperture(Float minaperture) {
this.minaperture = minaperture;
}
public Float getMinspace() {
return minspace;
}
public void setMinspace(Float minspace) {
this.minspace = minspace;
}
public Float getMinwidth() {
return minwidth;
}
public void setMinwidth(Float minwidth) {
this.minwidth = minwidth;
}
}
3. NewMateAppBillPojo.hbm.xml
4. DQAssemblyPojo.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.tdtech.pdm.create.pojo">
<class name="DQAssemblyPojo" table="tb_dqassembly">
<id name="id">
<generator class="native"></generator>
</id>
<property name="hwcode"></property>
<property name="dqcode"></property>
<!-- 常规信息 -->
<property name="goodsline"></property>
<property name="goods"></property>
<property name="defaultunit"></property>
<property name="resource"></property>
<property name="template"></property>
<property name="organise"></property>
<property name="lifetime"></property>
<!-- IBA管理属性 -->
<property name="smallSortCode"></property>
<property name="machinetype"></property>
<property name="parttype"></property>
<property name="bantype"></property>
<property name="innertype"></property>
<property name="outtername"></property>
<property name="outterenname"></property>
<property name="drawingedition"></property>
<property name="isenvironment"></property>
<property name="isnobittern"></property>
<property name="tackexplain"></property>
<!-- 2013-3-22 -->
<property name="sortteanname"></property>
<property name="smallsortname"></property>
<property name="author"></property>
<property name="edition"></property>
<property name="status"></property>
<property name="assemblystatus"></property>
<property name="instance"></property>
<property name="createtime"></property>
<property name="lastupdatetime"></property>
<property name="updateperson"></property>
<property name="sortinfo"></property>
<!-- 2013-3-25 -->
<property name="pintotal"></property>
<property name="layercount"></property>
<property name="workshoptypeflag"></property>
<property name="serialmode"></property>
<property name="plyscale"></property>
<property name="spellboard"></property>
<property name="isbackboard"></property>
<property name="isequipment"></property>
<property name="isflagboard"></property>
<property name="isplumbum"></property>
<property name="ispedance"></property>
<property name="standlevel"></property>
<property name="especialart"></property>
<property name="especialask"></property>
<property name="outtypesize"></property>
<property name="broachaccount"></property>
<property name="minaperture"></property>
<property name="minspace"></property>
<property name="minwidth"></property>
<property name="endecrible"></property>
</class>
</hibernate-mapping>
|
