--建表脚本--

create table T_BD_ATTENDANCE(

FOPENID nvarchar(50) not null  comment '讯通openid'

,FNAME nvarchar(30) not null  comment '名字'

,FJOBNUMBER nvarchar(30) not null  comment '工号'

,FDEPARTMENT nvarchar(50) not null  comment '部门'

,FDATE datetime default null  comment '日期'

,FSTARTWORKBEGINTIME nvarchar(10) not null  comment '上午上班签到时间'

,FSTARTWORKBEGINPOSITION nvarchar(200) not null  comment '上午上班签到地点'

,FSTARTWORKENDTIME nvarchar(10) not null  comment '上午下班签到时间'

,FSTARTWORKENDPOSITION nvarchar(200) not null  comment '上午下班点到地点'

,FENDWORKBEGINTIME nvarchar(10) not null  comment '下午上班签到时间'

,FENDWORKBEGINPOSITION nvarchar(200) not null  comment '下午上班签到地点'

,FENDWORKENDTIME nvarchar(10) not null  comment '下午下班签到时间'

,FENDWORKENDPOSITION nvarchar(200) not null  comment '下午下班签到地点'

,FWORKINGHOURS nvarchar(50) not null  comment '工作时长'

,FISMORNINGLATE char(1) not null  comment '是否上午上班迟到'

,FISMORNINGQUIT char(1) not null  comment '是否上午下班早退'

,FISAFTERNOONLATE char(1) not null  comment '是否下午上班迟到'

,FISAFTERNOONQUIT char(1) not null  comment '是否下午下班早退'

,FISEIGHTHOURS char(1) not null  comment '工作时长是否满八小时'

,primary key (FOPENID)

) comment = '移动考勤表'

--查询--

select FOPENID as "fopenid",FNAME as "fname",FJOBNUMBER as "fjobnumber",FDEPARTMENT as "fdepartment",FDATE as "fdate",FSTARTWORKBEGINTIME as "fstartworkbegintime",FSTARTWORKBEGINPOSITION as "fstartworkbeginposition",FSTARTWORKENDTIME as "fstartworkendtime",FSTARTWORKENDPOSITION as "fstartworkendposition",FENDWORKBEGINTIME as "fendworkbegintime",FENDWORKBEGINPOSITION as "fendworkbeginposition",FENDWORKENDTIME as "fendworkendtime",FENDWORKENDPOSITION as "fendworkendposition",FWORKINGHOURS as "fworkinghours",FISMORNINGLATE as "fismorninglate",FISMORNINGQUIT as "fismorningquit",FISAFTERNOONLATE as "fisafternoonlate",FISAFTERNOONQUIT as "fisafternoonquit",FISEIGHTHOURS as "fiseighthours" from T_BD_ATTENDANCE

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

select FOPENID as "讯通openid",FNAME as "名字",FJOBNUMBER as "工号",FDEPARTMENT as "部门",FDATE as "日期",FSTARTWORKBEGINTIME as "上午上班签到时间",FSTARTWORKBEGINPOSITION as "上午上班签到地点",FSTARTWORKENDTIME as "上午下班签到时间",FSTARTWORKENDPOSITION as "上午下班点到地点",FENDWORKBEGINTIME as "下午上班签到时间",FENDWORKBEGINPOSITION as "下午上班签到地点",FENDWORKENDTIME as "下午下班签到时间",FENDWORKENDPOSITION as "下午下班签到地点",FWORKINGHOURS as "工作时长",FISMORNINGLATE as "是否上午上班迟到",FISMORNINGQUIT as "是否上午下班早退",FISAFTERNOONLATE as "是否下午上班迟到",FISAFTERNOONQUIT as "是否下午下班早退",FISEIGHTHOURS as "工作时长是否满八小时" from T_BD_ATTENDANCE

--INSERT脚本--

insert into T_BD_ATTENDANCE(FOPENID,FNAME,FJOBNUMBER,FDEPARTMENT,FDATE,FSTARTWORKBEGINTIME,FSTARTWORKBEGINPOSITION,FSTARTWORKENDTIME,FSTARTWORKENDPOSITION,FENDWORKBEGINTIME,FENDWORKBEGINPOSITION,FENDWORKENDTIME,FENDWORKENDPOSITION,FWORKINGHOURS,FISMORNINGLATE,FISMORNINGQUIT,FISAFTERNOONLATE,FISAFTERNOONQUIT,FISEIGHTHOURS) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_ATTENDANCE set FOPENID=?,FNAME=?,FJOBNUMBER=?,FDEPARTMENT=?,FDATE=?,FSTARTWORKBEGINTIME=?,FSTARTWORKBEGINPOSITION=?,FSTARTWORKENDTIME=?,FSTARTWORKENDPOSITION=?,FENDWORKBEGINTIME=?,FENDWORKBEGINPOSITION=?,FENDWORKENDTIME=?,FENDWORKENDPOSITION=?,FWORKINGHOURS=?,FISMORNINGLATE=?,FISMORNINGQUIT=?,FISAFTERNOONLATE=?,FISAFTERNOONQUIT=?,FISEIGHTHOURS=? where FOPENID=?

--delete脚本--

delete from T_BD_ATTENDANCE where FOPENID=?

--给字段加备注--

alter table T_BD_ATTENDANCE comment '移动考勤表';

alter table T_BD_ATTENDANCE modify column FOPENID nvarchar(50) not null  comment '讯通openid';

alter table T_BD_ATTENDANCE modify column FNAME nvarchar(30) not null  comment '名字';

alter table T_BD_ATTENDANCE modify column FJOBNUMBER nvarchar(30) not null  comment '工号';

alter table T_BD_ATTENDANCE modify column FDEPARTMENT nvarchar(50) not null  comment '部门';

alter table T_BD_ATTENDANCE modify column FDATE datetime default null  comment '日期';

alter table T_BD_ATTENDANCE modify column FSTARTWORKBEGINTIME nvarchar(10) not null  comment '上午上班签到时间';

alter table T_BD_ATTENDANCE modify column FSTARTWORKBEGINPOSITION nvarchar(200) not null  comment '上午上班签到地点';

alter table T_BD_ATTENDANCE modify column FSTARTWORKENDTIME nvarchar(10) not null  comment '上午下班签到时间';

alter table T_BD_ATTENDANCE modify column FSTARTWORKENDPOSITION nvarchar(200) not null  comment '上午下班点到地点';

alter table T_BD_ATTENDANCE modify column FENDWORKBEGINTIME nvarchar(10) not null  comment '下午上班签到时间';

alter table T_BD_ATTENDANCE modify column FENDWORKBEGINPOSITION nvarchar(200) not null  comment '下午上班签到地点';

alter table T_BD_ATTENDANCE modify column FENDWORKENDTIME nvarchar(10) not null  comment '下午下班签到时间';

alter table T_BD_ATTENDANCE modify column FENDWORKENDPOSITION nvarchar(200) not null  comment '下午下班签到地点';

alter table T_BD_ATTENDANCE modify column FWORKINGHOURS nvarchar(50) not null  comment '工作时长';

alter table T_BD_ATTENDANCE modify column FISMORNINGLATE char(1) not null  comment '是否上午上班迟到';

alter table T_BD_ATTENDANCE modify column FISMORNINGQUIT char(1) not null  comment '是否上午下班早退';

alter table T_BD_ATTENDANCE modify column FISAFTERNOONLATE char(1) not null  comment '是否下午上班迟到';

alter table T_BD_ATTENDANCE modify column FISAFTERNOONQUIT char(1) not null  comment '是否下午下班早退';

alter table T_BD_ATTENDANCE modify column FISEIGHTHOURS char(1) not null  comment '工作时长是否满八小时';

--建表脚本--

create table T_BD_ATTENDANCESETTING(

FID int not null  comment '主键'

,FDEPARTMENTNAME nvarchar(100) not null  comment '部门名称'

,FSTAFFCOUNT int not null  comment '部门人数'

,FMORNINGSTARTTIME datetime default null  comment '上午上班时间'

,FMORNINGENDTIME datetime default null  comment '上午下班时间'

,FAFTERNOONSTARTTIME datetime default null  comment '下午上班时间'

,FAFTERNOONENDTIME datetime default null  comment '下午下班时间'

,primary key (FID)

) comment = '移动考勤设置表'

--查询--

select FID as "fid",FDEPARTMENTNAME as "fdepartmentname",FSTAFFCOUNT as "fstaffcount",FMORNINGSTARTTIME as "fmorningstarttime",FMORNINGENDTIME as "fmorningendtime",FAFTERNOONSTARTTIME as "fafternoonstarttime",FAFTERNOONENDTIME as "fafternoonendtime" from T_BD_ATTENDANCESETTING

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

select FID as "主键",FDEPARTMENTNAME as "部门名称",FSTAFFCOUNT as "部门人数",FMORNINGSTARTTIME as "上午上班时间",FMORNINGENDTIME as "上午下班时间",FAFTERNOONSTARTTIME as "下午上班时间",FAFTERNOONENDTIME as "下午下班时间" from T_BD_ATTENDANCESETTING

--INSERT脚本--

insert into T_BD_ATTENDANCESETTING(FID,FDEPARTMENTNAME,FSTAFFCOUNT,FMORNINGSTARTTIME,FMORNINGENDTIME,FAFTERNOONSTARTTIME,FAFTERNOONENDTIME) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_ATTENDANCESETTING set FID=?,FDEPARTMENTNAME=?,FSTAFFCOUNT=?,FMORNINGSTARTTIME=?,FMORNINGENDTIME=?,FAFTERNOONSTARTTIME=?,FAFTERNOONENDTIME=? where FID=?

--delete脚本--

delete from T_BD_ATTENDANCESETTING where FID=?

--给字段加备注--

alter table T_BD_ATTENDANCESETTING comment '移动考勤设置表';

alter table T_BD_ATTENDANCESETTING modify column FID int not null  comment '主键';

alter table T_BD_ATTENDANCESETTING modify column FDEPARTMENTNAME nvarchar(100) not null  comment '部门名称';

alter table T_BD_ATTENDANCESETTING modify column FSTAFFCOUNT int not null  comment '部门人数';

alter table T_BD_ATTENDANCESETTING modify column FMORNINGSTARTTIME datetime default null  comment '上午上班时间';

alter table T_BD_ATTENDANCESETTING modify column FMORNINGENDTIME datetime default null  comment '上午下班时间';

alter table T_BD_ATTENDANCESETTING modify column FAFTERNOONSTARTTIME datetime default null  comment '下午上班时间';

alter table T_BD_ATTENDANCESETTING modify column FAFTERNOONENDTIME datetime default null  comment '下午下班时间';

--建表脚本--

create table T_BD_EXPERTADVISOR(

FID int not null  comment 'FID'

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

,FDOCUMENTSTATUS char(1) not null  comment '审核状态'

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

,FTYPE char(1) not null  comment '专家类型'

,FSEX char(1) not null  comment '性别'

,FPHONENUMBER nvarchar(36) not null  comment '电话'

,FEMAIL nvarchar(36) not null  comment '邮箱'

,FQQ nvarchar(36) not null  comment 'qq'

,FPRAISECOUNT int not null  comment '统计被赞数'

,primary key (FID)

) comment = '专家名片表'

--查询--

select FID as "fid",FNUMBER as "fnumber",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus",FTYPE as "ftype",FSEX as "fsex",FPHONENUMBER as "fphonenumber",FEMAIL as "femail",FQQ as "fqq",FPRAISECOUNT as "fpraisecount" from T_BD_EXPERTADVISOR

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

select FID as "FID",FNUMBER as "编码",FDOCUMENTSTATUS as "审核状态",FFORBIDSTATUS as "禁用状态",FTYPE as "专家类型",FSEX as "性别",FPHONENUMBER as "电话",FEMAIL as "邮箱",FQQ as "qq",FPRAISECOUNT as "统计被赞数" from T_BD_EXPERTADVISOR

--INSERT脚本--

insert into T_BD_EXPERTADVISOR(FID,FNUMBER,FDOCUMENTSTATUS,FFORBIDSTATUS,FTYPE,FSEX,FPHONENUMBER,FEMAIL,FQQ,FPRAISECOUNT) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_EXPERTADVISOR set FID=?,FNUMBER=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=?,FTYPE=?,FSEX=?,FPHONENUMBER=?,FEMAIL=?,FQQ=?,FPRAISECOUNT=? where FID=?

--delete脚本--

delete from T_BD_EXPERTADVISOR where FID=?

--给字段加备注--

alter table T_BD_EXPERTADVISOR comment '专家名片表';

alter table T_BD_EXPERTADVISOR modify column FID int not null  comment 'FID';

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

alter table T_BD_EXPERTADVISOR modify column FDOCUMENTSTATUS char(1) not null  comment '审核状态';

alter table T_BD_EXPERTADVISOR modify column FFORBIDSTATUS char(1) not null  comment '禁用状态';

alter table T_BD_EXPERTADVISOR modify column FTYPE char(1) not null  comment '专家类型';

alter table T_BD_EXPERTADVISOR modify column FSEX char(1) not null  comment '性别';

alter table T_BD_EXPERTADVISOR modify column FPHONENUMBER nvarchar(36) not null  comment '电话';

alter table T_BD_EXPERTADVISOR modify column FEMAIL nvarchar(36) not null  comment '邮箱';

alter table T_BD_EXPERTADVISOR modify column FQQ nvarchar(36) not null  comment 'qq';

alter table T_BD_EXPERTADVISOR modify column FPRAISECOUNT int not null  comment '统计被赞数';

--建表脚本--

create table T_BD_EXPERTADVISOR_L(

FPKID int not null  comment '主键'

,FID int not null  comment 'FID'

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

,FNAME nvarchar(80) not null  comment '名称'

,FPOSITION nvarchar(36) not null  comment '职能岗位'

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

,primary key (FPKID)

) comment = '专家名片多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FNAME as "fname",FPOSITION as "fposition",FDESCRIPTION as "fdescription" from T_BD_EXPERTADVISOR_L

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

select FPKID as "主键",FID as "FID",FLOCALEID as "多语言内码",FNAME as "名称",FPOSITION as "职能岗位",FDESCRIPTION as "描述" from T_BD_EXPERTADVISOR_L

--INSERT脚本--

insert into T_BD_EXPERTADVISOR_L(FPKID,FID,FLOCALEID,FNAME,FPOSITION,FDESCRIPTION) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_EXPERTADVISOR_L set FPKID=?,FID=?,FLOCALEID=?,FNAME=?,FPOSITION=?,FDESCRIPTION=? where FPKID=?

--delete脚本--

delete from T_BD_EXPERTADVISOR_L where FPKID=?

--给字段加备注--

alter table T_BD_EXPERTADVISOR_L comment '专家名片多语言';

alter table T_BD_EXPERTADVISOR_L modify column FPKID int not null  comment '主键';

alter table T_BD_EXPERTADVISOR_L modify column FID int not null  comment 'FID';

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

alter table T_BD_EXPERTADVISOR_L modify column FNAME nvarchar(80) not null  comment '名称';

alter table T_BD_EXPERTADVISOR_L modify column FPOSITION nvarchar(36) not null  comment '职能岗位';

alter table T_BD_EXPERTADVISOR_L modify column FDESCRIPTION nvarchar(255) not null  comment '描述';

--建表脚本--

create table T_BD_EXPERTFAVORITE(

FPKID int not null  comment 'FPKID'

,FID int not null  comment '专家id'

,FOPENID nvarchar(36) not null  comment '云之家用户id'

,FISFAVORITE char(1) not null  comment '是否收藏'

,FISPRAISE char(1) not null  comment '是否赞'

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

,primary key (FPKID)

) comment = '收藏夹表'

--查询--

select FPKID as "fpkid",FID as "fid",FOPENID as "fopenid",FISFAVORITE as "fisfavorite",FISPRAISE as "fispraise",FCREATEDATE as "fcreatedate" from T_BD_EXPERTFAVORITE

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

select FPKID as "FPKID",FID as "专家id",FOPENID as "云之家用户id",FISFAVORITE as "是否收藏",FISPRAISE as "是否赞",FCREATEDATE as "创建日期" from T_BD_EXPERTFAVORITE

--INSERT脚本--

insert into T_BD_EXPERTFAVORITE(FPKID,FID,FOPENID,FISFAVORITE,FISPRAISE,FCREATEDATE) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_BD_EXPERTFAVORITE set FPKID=?,FID=?,FOPENID=?,FISFAVORITE=?,FISPRAISE=?,FCREATEDATE=? where FPKID=?

--delete脚本--

delete from T_BD_EXPERTFAVORITE where FPKID=?

--给字段加备注--

alter table T_BD_EXPERTFAVORITE comment '收藏夹表';

alter table T_BD_EXPERTFAVORITE modify column FPKID int not null  comment 'FPKID';

alter table T_BD_EXPERTFAVORITE modify column FID int not null  comment '专家id';

alter table T_BD_EXPERTFAVORITE modify column FOPENID nvarchar(36) not null  comment '云之家用户id';

alter table T_BD_EXPERTFAVORITE modify column FISFAVORITE char(1) not null  comment '是否收藏';

alter table T_BD_EXPERTFAVORITE modify column FISPRAISE char(1) not null  comment '是否赞';

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