T_BD_COMMONCONTACT(供应商客户联系人) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FCONTACTID | 供应商客户联系人id | int | 0 | |||
FMASTERID | 唯一标识 | int | 0 | ||||
FNUMBER | 供应商客户联系人编码 | nvarchar | 30 | ||||
FSEX | 性别 | nvarchar | 36 | ||||
FPOST | 职务 | nvarchar | 80 | ||||
FCOMPANYTYPE | 类别 | varchar | 36 | ||||
FCOMPANY | 所属公司 | int | 0 | ||||
FTEL | 固定电话 | nvarchar | 80 | ||||
FMOBILE | 移动电话 | nvarchar | 80 | ||||
FFAX | 传真 | nvarchar | 50 | ||||
FEMAIL | 电子邮箱 | nvarchar | 80 | ||||
FDOCUMENTSTATUS | 数据状态 | char | 1 | ||||
FFORBIDSTATUS | 禁用状态 | char | 1 | ||||
FCREATORID | 创建人 | int | 0 | ||||
FCREATEDATE | 创建日期 | datetime | ✓ | ||||
FMODIFIERID | 修改人 | int | 0 | ||||
FMODIFYDATE | 修改日期 | datetime | ✓ | ||||
FBIZLOCATION | 地点名称 | nvarchar | 255 | ||||
FBIZLOCNUMBER | 地点编码 | nvarchar | 30 | ||||
FBIZADDRESS | 详细地址 | nvarchar | 255 |
--建表脚本--
create table T_BD_COMMONCONTACT(
FCONTACTID int not null comment '供应商客户联系人id'
,FMASTERID int not null comment '唯一标识'
,FNUMBER nvarchar(30) not null comment '供应商客户联系人编码'
,FSEX nvarchar(36) not null comment '性别'
,FPOST nvarchar(80) not null comment '职务'
,FCOMPANYTYPE varchar(36) not null comment '类别'
,FCOMPANY int not null comment '所属公司'
,FTEL nvarchar(80) not null comment '固定电话'
,FMOBILE nvarchar(80) not null comment '移动电话'
,FFAX nvarchar(50) not null comment '传真'
,FEMAIL nvarchar(80) not null comment '电子邮箱'
,FDOCUMENTSTATUS char(1) not null comment '数据状态'
,FFORBIDSTATUS char(1) not null comment '禁用状态'
,FCREATORID int not null comment '创建人'
,FCREATEDATE datetime default null comment '创建日期'
,FMODIFIERID int not null comment '修改人'
,FMODIFYDATE datetime default null comment '修改日期'
,FBIZLOCATION nvarchar(255) not null comment '地点名称'
,FBIZLOCNUMBER nvarchar(30) not null comment '地点编码'
,FBIZADDRESS nvarchar(255) not null comment '详细地址'
,primary key (FCONTACTID)
) comment = '供应商客户联系人'
--查询--
select FCONTACTID as "fcontactid",FMASTERID as "fmasterid",FNUMBER as "fnumber",FSEX as "fsex",FPOST as "fpost",FCOMPANYTYPE as "fcompanytype",FCOMPANY as "fcompany",FTEL as "ftel",FMOBILE as "fmobile",FFAX as "ffax",FEMAIL as "femail",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FBIZLOCATION as "fbizlocation",FBIZLOCNUMBER as "fbizlocnumber",FBIZADDRESS as "fbizaddress" from T_BD_COMMONCONTACT
--查询(中文字段)--
select FCONTACTID as "供应商客户联系人id",FMASTERID as "唯一标识",FNUMBER as "供应商客户联系人编码",FSEX as "性别",FPOST as "职务",FCOMPANYTYPE as "类别",FCOMPANY as "所属公司",FTEL as "固定电话",FMOBILE as "移动电话",FFAX as "传真",FEMAIL as "电子邮箱",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FBIZLOCATION as "地点名称",FBIZLOCNUMBER as "地点编码",FBIZADDRESS as "详细地址" from T_BD_COMMONCONTACT
--INSERT脚本--
insert into T_BD_COMMONCONTACT(FCONTACTID,FMASTERID,FNUMBER,FSEX,FPOST,FCOMPANYTYPE,FCOMPANY,FTEL,FMOBILE,FFAX,FEMAIL,FDOCUMENTSTATUS,FFORBIDSTATUS,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FBIZLOCATION,FBIZLOCNUMBER,FBIZADDRESS) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_BD_COMMONCONTACT set FCONTACTID=?,FMASTERID=?,FNUMBER=?,FSEX=?,FPOST=?,FCOMPANYTYPE=?,FCOMPANY=?,FTEL=?,FMOBILE=?,FFAX=?,FEMAIL=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FBIZLOCATION=?,FBIZLOCNUMBER=?,FBIZADDRESS=? where FCONTACTID=?
--delete脚本--
delete from T_BD_COMMONCONTACT where FCONTACTID=?
--给字段加备注--
alter table T_BD_COMMONCONTACT comment '供应商客户联系人';
alter table T_BD_COMMONCONTACT modify column FCONTACTID int not null comment '供应商客户联系人id';
alter table T_BD_COMMONCONTACT modify column FMASTERID int not null comment '唯一标识';
alter table T_BD_COMMONCONTACT modify column FNUMBER nvarchar(30) not null comment '供应商客户联系人编码';
alter table T_BD_COMMONCONTACT modify column FSEX nvarchar(36) not null comment '性别';
alter table T_BD_COMMONCONTACT modify column FPOST nvarchar(80) not null comment '职务';
alter table T_BD_COMMONCONTACT modify column FCOMPANYTYPE varchar(36) not null comment '类别';
alter table T_BD_COMMONCONTACT modify column FCOMPANY int not null comment '所属公司';
alter table T_BD_COMMONCONTACT modify column FTEL nvarchar(80) not null comment '固定电话';
alter table T_BD_COMMONCONTACT modify column FMOBILE nvarchar(80) not null comment '移动电话';
alter table T_BD_COMMONCONTACT modify column FFAX nvarchar(50) not null comment '传真';
alter table T_BD_COMMONCONTACT modify column FEMAIL nvarchar(80) not null comment '电子邮箱';
alter table T_BD_COMMONCONTACT modify column FDOCUMENTSTATUS char(1) not null comment '数据状态';
alter table T_BD_COMMONCONTACT modify column FFORBIDSTATUS char(1) not null comment '禁用状态';
alter table T_BD_COMMONCONTACT modify column FCREATORID int not null comment '创建人';
alter table T_BD_COMMONCONTACT modify column FCREATEDATE datetime default null comment '创建日期';
alter table T_BD_COMMONCONTACT modify column FMODIFIERID int not null comment '修改人';
alter table T_BD_COMMONCONTACT modify column FMODIFYDATE datetime default null comment '修改日期';
alter table T_BD_COMMONCONTACT modify column FBIZLOCATION nvarchar(255) not null comment '地点名称';
alter table T_BD_COMMONCONTACT modify column FBIZLOCNUMBER nvarchar(30) not null comment '地点编码';
alter table T_BD_COMMONCONTACT modify column FBIZADDRESS nvarchar(255) not null comment '详细地址';
T_BD_COMMONCONTACT_L(供应商客户联系人多语言) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FPKID | 多语言主键 | int | 0 | |||
FCONTACTID | 供应商客户联系人内码 | int | 0 | ||||
FLOCALEID | 语言标示 | int | 0 | ||||
FNAME | 名称 | nvarchar | 80 | ||||
FSHORTNAME | 简称 | nvarchar | 50 | ||||
FDESCRIPTION | 描述 | nvarchar | 255 |
--建表脚本--
create table T_BD_COMMONCONTACT_L(
FPKID int not null comment '多语言主键'
,FCONTACTID int not null comment '供应商客户联系人内码'
,FLOCALEID int not null comment '语言标示'
,FNAME nvarchar(80) not null comment '名称'
,FSHORTNAME nvarchar(50) not null comment '简称'
,FDESCRIPTION nvarchar(255) not null comment '描述'
,primary key (FPKID)
) comment = '供应商客户联系人多语言'
--查询--
select FPKID as "fpkid",FCONTACTID as "fcontactid",FLOCALEID as "flocaleid",FNAME as "fname",FSHORTNAME as "fshortname",FDESCRIPTION as "fdescription" from T_BD_COMMONCONTACT_L
--查询(中文字段)--
select FPKID as "多语言主键",FCONTACTID as "供应商客户联系人内码",FLOCALEID as "语言标示",FNAME as "名称",FSHORTNAME as "简称",FDESCRIPTION as "描述" from T_BD_COMMONCONTACT_L
--INSERT脚本--
insert into T_BD_COMMONCONTACT_L(FPKID,FCONTACTID,FLOCALEID,FNAME,FSHORTNAME,FDESCRIPTION) values (?,?,?,?,?,?)
--UPDATE脚本--
update T_BD_COMMONCONTACT_L set FPKID=?,FCONTACTID=?,FLOCALEID=?,FNAME=?,FSHORTNAME=?,FDESCRIPTION=? where FPKID=?
--delete脚本--
delete from T_BD_COMMONCONTACT_L where FPKID=?
--给字段加备注--
alter table T_BD_COMMONCONTACT_L comment '供应商客户联系人多语言';
alter table T_BD_COMMONCONTACT_L modify column FPKID int not null comment '多语言主键';
alter table T_BD_COMMONCONTACT_L modify column FCONTACTID int not null comment '供应商客户联系人内码';
alter table T_BD_COMMONCONTACT_L modify column FLOCALEID int not null comment '语言标示';
alter table T_BD_COMMONCONTACT_L modify column FNAME nvarchar(80) not null comment '名称';
alter table T_BD_COMMONCONTACT_L modify column FSHORTNAME nvarchar(50) not null comment '简称';
alter table T_BD_COMMONCONTACT_L modify column FDESCRIPTION nvarchar(255) not null comment '描述';
推荐阅读