1.4 BD基础--基础资料-公用（银行、银行多语言）

--建表脚本--

create table T_BD_BANK(

FBANKID int not null  comment '银行内码'

,FMasterId int not null  comment '组织隔离字段'

,FNUMBER nvarchar(30) not null  comment '银行编码'

,FADDRESS nvarchar(80) not null  comment '银行地址'

,FSTARTDATE datetime default null  comment '生效日期'

,FENDDATE datetime default null  comment '失效日期'

,FDOCUMENTSTATUS char(1) default null  comment '数据状态'

,FFORBIDSTATUS char(1) default ''''  comment '禁用状态'

,FCREATEORGID int default 0  comment '创建组织'

,FUSEORGID int default 0  comment '使用组织'

,FCREATORID int default 0  comment '创建人'

,FCREATEDATE datetime default null  comment '创建日期'

,FMODIFIERID int default 0  comment '修改人'

,FMODIFYDATE datetime default null  comment '修改日期'

,FAUDITORID int default 0  comment '审核人'

,FAUDITDATE datetime default null  comment '审核日期'

,FFORBIDDERID int default 0  comment '禁用人'

,FFORBIDDATE datetime default null  comment '禁用日期'

,FISSYSPRESET char(1) default ''0''  comment '是否系统预设'

,FBANKTYPE int default 0  comment '银行类型'

,FDISTRICT int default 0  comment '地区'

,FPROVINCE int default 0  comment '省'

,FCITY int default 0  comment '城市'

,FACNTBRANCHNUMBER varchar(255) default '' ''  comment '联行号'

,FACNTAREACODE varchar(255) default '' ''  comment '地区码'

,primary key (FBANKID)

) comment = '银行'

--查询--

select FBANKID as "fbankid",FMasterId as "fmasterid",FNUMBER as "fnumber",FADDRESS as "faddress",FSTARTDATE as "fstartdate",FENDDATE as "fenddate",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FCREATEORGID as "fcreateorgid",FUSEORGID as "fuseorgid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAUDITORID as "fauditorid",FAUDITDATE as "fauditdate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FISSYSPRESET as "fissyspreset",FBANKTYPE as "fbanktype",FDISTRICT as "fdistrict",FPROVINCE as "fprovince",FCITY as "fcity",FACNTBRANCHNUMBER as "facntbranchnumber",FACNTAREACODE as "facntareacode" from T_BD_BANK

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

select FBANKID as "银行内码",FMasterId as "组织隔离字段",FNUMBER as "银行编码",FADDRESS as "银行地址",FSTARTDATE as "生效日期",FENDDATE as "失效日期",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态",FCREATEORGID as "创建组织",FUSEORGID as "使用组织",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FAUDITORID as "审核人",FAUDITDATE as "审核日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FISSYSPRESET as "是否系统预设",FBANKTYPE as "银行类型",FDISTRICT as "地区",FPROVINCE as "省",FCITY as "城市",FACNTBRANCHNUMBER as "联行号",FACNTAREACODE as "地区码" from T_BD_BANK

--INSERT脚本--

insert into T_BD_BANK(FBANKID,FMasterId,FNUMBER,FADDRESS,FSTARTDATE,FENDDATE,FDOCUMENTSTATUS,FFORBIDSTATUS,FCREATEORGID,FUSEORGID,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAUDITORID,FAUDITDATE,FFORBIDDERID,FFORBIDDATE,FISSYSPRESET,FBANKTYPE,FDISTRICT,FPROVINCE,FCITY,FACNTBRANCHNUMBER,FACNTAREACODE) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_BANK set FBANKID=?,FMasterId=?,FNUMBER=?,FADDRESS=?,FSTARTDATE=?,FENDDATE=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FCREATEORGID=?,FUSEORGID=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAUDITORID=?,FAUDITDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FISSYSPRESET=?,FBANKTYPE=?,FDISTRICT=?,FPROVINCE=?,FCITY=?,FACNTBRANCHNUMBER=?,FACNTAREACODE=? where FBANKID=?

--delete脚本--

delete from T_BD_BANK where FBANKID=?

--给字段加备注--

alter table T_BD_BANK comment '银行';

alter table T_BD_BANK modify column FBANKID int not null  comment '银行内码';

alter table T_BD_BANK modify column FMasterId int not null  comment '组织隔离字段';

alter table T_BD_BANK modify column FNUMBER nvarchar(30) not null  comment '银行编码';

alter table T_BD_BANK modify column FADDRESS nvarchar(80) not null  comment '银行地址';

alter table T_BD_BANK modify column FSTARTDATE datetime default null  comment '生效日期';

alter table T_BD_BANK modify column FENDDATE datetime default null  comment '失效日期';

alter table T_BD_BANK modify column FDOCUMENTSTATUS char(1) default null  comment '数据状态';

alter table T_BD_BANK modify column FFORBIDSTATUS char(1) default ''''  comment '禁用状态';

alter table T_BD_BANK modify column FCREATEORGID int default 0  comment '创建组织';

alter table T_BD_BANK modify column FUSEORGID int default 0  comment '使用组织';

alter table T_BD_BANK modify column FCREATORID int default 0  comment '创建人';

alter table T_BD_BANK modify column FCREATEDATE datetime default null  comment '创建日期';

alter table T_BD_BANK modify column FMODIFIERID int default 0  comment '修改人';

alter table T_BD_BANK modify column FMODIFYDATE datetime default null  comment '修改日期';

alter table T_BD_BANK modify column FAUDITORID int default 0  comment '审核人';

alter table T_BD_BANK modify column FAUDITDATE datetime default null  comment '审核日期';

alter table T_BD_BANK modify column FFORBIDDERID int default 0  comment '禁用人';

alter table T_BD_BANK modify column FFORBIDDATE datetime default null  comment '禁用日期';

alter table T_BD_BANK modify column FISSYSPRESET char(1) default ''0''  comment '是否系统预设';

alter table T_BD_BANK modify column FBANKTYPE int default 0  comment '银行类型';

alter table T_BD_BANK modify column FDISTRICT int default 0  comment '地区';

alter table T_BD_BANK modify column FPROVINCE int default 0  comment '省';

alter table T_BD_BANK modify column FCITY int default 0  comment '城市';

alter table T_BD_BANK modify column FACNTBRANCHNUMBER varchar(255) default '' ''  comment '联行号';

alter table T_BD_BANK modify column FACNTAREACODE varchar(255) default '' ''  comment '地区码';

--建表脚本--

create table T_BD_BANK_L(

FPKID int not null  comment '内码'

,FBANKID int not null  comment '银行内码'

,FLOCALEID int not null  comment '语言内码'

,FNAME nvarchar(255) not null  comment '银行名称'

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

,FACNTAREANAME nvarchar(255) default ' '  comment '地区名'

,primary key (FPKID)

) comment = '银行多语言'

--查询--

select FPKID as "fpkid",FBANKID as "fbankid",FLOCALEID as "flocaleid",FNAME as "fname",FDESCRIPTION as "fdescription",FACNTAREANAME as "facntareaname" from T_BD_BANK_L

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

select FPKID as "内码",FBANKID as "银行内码",FLOCALEID as "语言内码",FNAME as "银行名称",FDESCRIPTION as "描述",FACNTAREANAME as "地区名" from T_BD_BANK_L

--INSERT脚本--

insert into T_BD_BANK_L(FPKID,FBANKID,FLOCALEID,FNAME,FDESCRIPTION,FACNTAREANAME) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_BANK_L set FPKID=?,FBANKID=?,FLOCALEID=?,FNAME=?,FDESCRIPTION=?,FACNTAREANAME=? where FPKID=?

--delete脚本--

delete from T_BD_BANK_L where FPKID=?

--给字段加备注--

alter table T_BD_BANK_L comment '银行多语言';

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

alter table T_BD_BANK_L modify column FBANKID int not null  comment '银行内码';

alter table T_BD_BANK_L modify column FLOCALEID int not null  comment '语言内码';

alter table T_BD_BANK_L modify column FNAME nvarchar(255) not null  comment '银行名称';

alter table T_BD_BANK_L modify column FDESCRIPTION nvarchar(255) default null  comment '描述';

alter table T_BD_BANK_L modify column FACNTAREANAME nvarchar(255) default ' '  comment '地区名';