CDP协同开发平台 / 企业管理 / 物理模型图

--建表脚本--

create table T_CDP_BuildLog(

FId int not null  comment '主键id'

,FRemark nvarchar(255) default null  comment '构建描述'

,FStartTime datetime default null  comment '构建发起时间'

,FStatus int default null  comment '构建状态'

,FPackageName nvarchar(255) default null  comment '本次构建的包名称'

,FVersion nvarchar(50) default null  comment '本次构建的包版本'

,FBuildId nvarchar(50) default null  comment '构建编号'

,FProjectId int default null  comment '项目内码'

,FMessage ntext default null  comment '日志信息'

,primary key (FId)

) comment = '构建日志'

--查询--

select FId as "fid",FRemark as "fremark",FStartTime as "fstarttime",FStatus as "fstatus",FPackageName as "fpackagename",FVersion as "fversion",FBuildId as "fbuildid",FProjectId as "fprojectid",FMessage as "fmessage" from T_CDP_BuildLog

--查询(中文字段)--

select FId as "主键id",FRemark as "构建描述",FStartTime as "构建发起时间",FStatus as "构建状态",FPackageName as "本次构建的包名称",FVersion as "本次构建的包版本",FBuildId as "构建编号",FProjectId as "项目内码",FMessage as "日志信息" from T_CDP_BuildLog

--INSERT脚本--

insert into T_CDP_BuildLog(FId,FRemark,FStartTime,FStatus,FPackageName,FVersion,FBuildId,FProjectId,FMessage) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_BuildLog set FId=?,FRemark=?,FStartTime=?,FStatus=?,FPackageName=?,FVersion=?,FBuildId=?,FProjectId=?,FMessage=? where FId=?

--delete脚本--

delete from T_CDP_BuildLog where FId=?

--给字段加备注--

alter table T_CDP_BuildLog comment '构建日志';

alter table T_CDP_BuildLog modify column FId int not null  comment '主键id';

alter table T_CDP_BuildLog modify column FRemark nvarchar(255) default null  comment '构建描述';

alter table T_CDP_BuildLog modify column FStartTime datetime default null  comment '构建发起时间';

alter table T_CDP_BuildLog modify column FStatus int default null  comment '构建状态';

alter table T_CDP_BuildLog modify column FPackageName nvarchar(255) default null  comment '本次构建的包名称';

alter table T_CDP_BuildLog modify column FVersion nvarchar(50) default null  comment '本次构建的包版本';

alter table T_CDP_BuildLog modify column FBuildId nvarchar(50) default null  comment '构建编号';

alter table T_CDP_BuildLog modify column FProjectId int default null  comment '项目内码';

alter table T_CDP_BuildLog modify column FMessage ntext default null  comment '日志信息';

--建表脚本--

create table T_CDP_BusinessObject(

FID int not null  comment '内码'

,FProjectID int default null  comment '项目内码'

,FKey nvarchar(50) default null  comment 'key'

,FName nvarchar(50) default null  comment '名称'

,FSubSystemKey nvarchar(50) default null  comment '子系统key'

,FDescription nvarchar(255) default null  comment '描述'

,FModelType nvarchar(50) default null  comment '模式类型'

,FBaseObjectKey nvarchar(50) default null  comment '基对象key'

,FDevTypeValue int default 0  comment '开发类型'

,primary key (FID)

) comment = '业务对象'

--查询--

select FID as "fid",FProjectID as "fprojectid",FKey as "fkey",FName as "fname",FSubSystemKey as "fsubsystemkey",FDescription as "fdescription",FModelType as "fmodeltype",FBaseObjectKey as "fbaseobjectkey",FDevTypeValue as "fdevtypevalue" from T_CDP_BusinessObject

--查询(中文字段)--

select FID as "内码",FProjectID as "项目内码",FKey as "key",FName as "名称",FSubSystemKey as "子系统key",FDescription as "描述",FModelType as "模式类型",FBaseObjectKey as "基对象key",FDevTypeValue as "开发类型" from T_CDP_BusinessObject

--INSERT脚本--

insert into T_CDP_BusinessObject(FID,FProjectID,FKey,FName,FSubSystemKey,FDescription,FModelType,FBaseObjectKey,FDevTypeValue) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_BusinessObject set FID=?,FProjectID=?,FKey=?,FName=?,FSubSystemKey=?,FDescription=?,FModelType=?,FBaseObjectKey=?,FDevTypeValue=? where FID=?

--delete脚本--

delete from T_CDP_BusinessObject where FID=?

--给字段加备注--

alter table T_CDP_BusinessObject comment '业务对象';

alter table T_CDP_BusinessObject modify column FID int not null  comment '内码';

alter table T_CDP_BusinessObject modify column FProjectID int default null  comment '项目内码';

alter table T_CDP_BusinessObject modify column FKey nvarchar(50) default null  comment 'key';

alter table T_CDP_BusinessObject modify column FName nvarchar(50) default null  comment '名称';

alter table T_CDP_BusinessObject modify column FSubSystemKey nvarchar(50) default null  comment '子系统key';

alter table T_CDP_BusinessObject modify column FDescription nvarchar(255) default null  comment '描述';

alter table T_CDP_BusinessObject modify column FModelType nvarchar(50) default null  comment '模式类型';

alter table T_CDP_BusinessObject modify column FBaseObjectKey nvarchar(50) default null  comment '基对象key';

alter table T_CDP_BusinessObject modify column FDevTypeValue int default 0  comment '开发类型';

--建表脚本--

create table T_CDP_COMPANY(

FEntryId int not null  comment '分录内码'

,FORGID int default null  comment '组织内码'

,FType nvarchar(50) default null  comment '企业类别'

,FRegCapital nvarchar(50) default null  comment '注册资本'

,FCONTACTID nvarchar(50) default null  comment '联系人内码'

,FPROVINCE nvarchar(50) default null  comment '省份'

,FCity nvarchar(50) default null  comment '城市'

,FDESCRIPTION nvarchar(2000) default null  comment '业务描述'

,FRegisterTime datetime default null  comment '注册日期'

,FSize nvarchar(50) default null  comment '人员规模'

,FEQUITYSTRUCTURE nvarchar(50) default null  comment '公司股权构成'

,FISKINGDEER char(1) default null  comment '企业法人是金蝶离职员工'

,FWEBSITE nvarchar(255) default null  comment '企业网址'

,FLICENSE image default null  comment '企业营业执照'

,FCDPPOSTCODE nvarchar(50) default null  comment '邮政编码'

,FCDPFAX nvarchar(50) default null  comment '传真号码'

,FHASHISTORY char(1) default null  comment '企业与金蝶有合作历史'

,primary key (FEntryId)

) comment = '企业附表'

--查询--

select FEntryId as "fentryid",FORGID as "forgid",FType as "ftype",FRegCapital as "fregcapital",FCONTACTID as "fcontactid",FPROVINCE as "fprovince",FCity as "fcity",FDESCRIPTION as "fdescription",FRegisterTime as "fregistertime",FSize as "fsize",FEQUITYSTRUCTURE as "fequitystructure",FISKINGDEER as "fiskingdeer",FWEBSITE as "fwebsite",FLICENSE as "flicense",FCDPPOSTCODE as "fcdppostcode",FCDPFAX as "fcdpfax",FHASHISTORY as "fhashistory" from T_CDP_COMPANY

--查询(中文字段)--

select FEntryId as "分录内码",FORGID as "组织内码",FType as "企业类别",FRegCapital as "注册资本",FCONTACTID as "联系人内码",FPROVINCE as "省份",FCity as "城市",FDESCRIPTION as "业务描述",FRegisterTime as "注册日期",FSize as "人员规模",FEQUITYSTRUCTURE as "公司股权构成",FISKINGDEER as "企业法人是金蝶离职员工",FWEBSITE as "企业网址",FLICENSE as "企业营业执照",FCDPPOSTCODE as "邮政编码",FCDPFAX as "传真号码",FHASHISTORY as "企业与金蝶有合作历史" from T_CDP_COMPANY

--INSERT脚本--

insert into T_CDP_COMPANY(FEntryId,FORGID,FType,FRegCapital,FCONTACTID,FPROVINCE,FCity,FDESCRIPTION,FRegisterTime,FSize,FEQUITYSTRUCTURE,FISKINGDEER,FWEBSITE,FLICENSE,FCDPPOSTCODE,FCDPFAX,FHASHISTORY) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_COMPANY set FEntryId=?,FORGID=?,FType=?,FRegCapital=?,FCONTACTID=?,FPROVINCE=?,FCity=?,FDESCRIPTION=?,FRegisterTime=?,FSize=?,FEQUITYSTRUCTURE=?,FISKINGDEER=?,FWEBSITE=?,FLICENSE=?,FCDPPOSTCODE=?,FCDPFAX=?,FHASHISTORY=? where FEntryId=?

--delete脚本--

delete from T_CDP_COMPANY where FEntryId=?

--给字段加备注--

alter table T_CDP_COMPANY comment '企业附表';

alter table T_CDP_COMPANY modify column FEntryId int not null  comment '分录内码';

alter table T_CDP_COMPANY modify column FORGID int default null  comment '组织内码';

alter table T_CDP_COMPANY modify column FType nvarchar(50) default null  comment '企业类别';

alter table T_CDP_COMPANY modify column FRegCapital nvarchar(50) default null  comment '注册资本';

alter table T_CDP_COMPANY modify column FCONTACTID nvarchar(50) default null  comment '联系人内码';

alter table T_CDP_COMPANY modify column FPROVINCE nvarchar(50) default null  comment '省份';

alter table T_CDP_COMPANY modify column FCity nvarchar(50) default null  comment '城市';

alter table T_CDP_COMPANY modify column FDESCRIPTION nvarchar(2000) default null  comment '业务描述';

alter table T_CDP_COMPANY modify column FRegisterTime datetime default null  comment '注册日期';

alter table T_CDP_COMPANY modify column FSize nvarchar(50) default null  comment '人员规模';

alter table T_CDP_COMPANY modify column FEQUITYSTRUCTURE nvarchar(50) default null  comment '公司股权构成';

alter table T_CDP_COMPANY modify column FISKINGDEER char(1) default null  comment '企业法人是金蝶离职员工';

alter table T_CDP_COMPANY modify column FWEBSITE nvarchar(255) default null  comment '企业网址';

alter table T_CDP_COMPANY modify column FLICENSE image default null  comment '企业营业执照';

alter table T_CDP_COMPANY modify column FCDPPOSTCODE nvarchar(50) default null  comment '邮政编码';

alter table T_CDP_COMPANY modify column FCDPFAX nvarchar(50) default null  comment '传真号码';

alter table T_CDP_COMPANY modify column FHASHISTORY char(1) default null  comment '企业与金蝶有合作历史';

--建表脚本--

create table T_CDP_COMPANY_L(

FPKID int not null  comment '内码'

,FEntryId int default null  comment '分录内码'

,FLocaleID int default null  comment '地区内码'

,FCertification nvarchar(50) default null  comment '企业资质'

,FLEGALPERSON nvarchar(50) default null  comment '企业法人'

,FCDPADDRESS nvarchar(255) default null  comment '企业地址'

,FREGISTERADDRESS nvarchar(255) default null  comment '企业注册地址'

,primary key (FPKID)

) comment = '企业附表多语言'

--查询--

select FPKID as "fpkid",FEntryId as "fentryid",FLocaleID as "flocaleid",FCertification as "fcertification",FLEGALPERSON as "flegalperson",FCDPADDRESS as "fcdpaddress",FREGISTERADDRESS as "fregisteraddress" from T_CDP_COMPANY_L

--查询(中文字段)--

select FPKID as "内码",FEntryId as "分录内码",FLocaleID as "地区内码",FCertification as "企业资质",FLEGALPERSON as "企业法人",FCDPADDRESS as "企业地址",FREGISTERADDRESS as "企业注册地址" from T_CDP_COMPANY_L

--INSERT脚本--

insert into T_CDP_COMPANY_L(FPKID,FEntryId,FLocaleID,FCertification,FLEGALPERSON,FCDPADDRESS,FREGISTERADDRESS) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_COMPANY_L set FPKID=?,FEntryId=?,FLocaleID=?,FCertification=?,FLEGALPERSON=?,FCDPADDRESS=?,FREGISTERADDRESS=? where FPKID=?

--delete脚本--

delete from T_CDP_COMPANY_L where FPKID=?

--给字段加备注--

alter table T_CDP_COMPANY_L comment '企业附表多语言';

alter table T_CDP_COMPANY_L modify column FPKID int not null  comment '内码';

alter table T_CDP_COMPANY_L modify column FEntryId int default null  comment '分录内码';

alter table T_CDP_COMPANY_L modify column FLocaleID int default null  comment '地区内码';

alter table T_CDP_COMPANY_L modify column FCertification nvarchar(50) default null  comment '企业资质';

alter table T_CDP_COMPANY_L modify column FLEGALPERSON nvarchar(50) default null  comment '企业法人';

alter table T_CDP_COMPANY_L modify column FCDPADDRESS nvarchar(255) default null  comment '企业地址';

alter table T_CDP_COMPANY_L modify column FREGISTERADDRESS nvarchar(255) default null  comment '企业注册地址';