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 "企业营业执照",FC