3,490
社区成员
发帖
与我相关
我的任务
分享
create table GR_KS
(
ZGH CHAR(10),
XH INTEGER,
BKDJ CHAR(40),
BKGZ CHAR(40),
LLCJ CHAR(6),
SZCJ CHAR(6),
ZYDD CHAR(6),
BKSJ VARCHAR2(12),
ZSBH VARCHAR2(30),
PZBM VARCHAR2(40),
BZ VARCHAR2(60),
APPLY_NO CHAR(5),
MSTATE CHAR(1)
)
;
comment on table GR_KS
is '工人考试';
comment on column GR_KS.ZGH
is '职工号';
comment on column GR_KS.XH
is '序号';
comment on column GR_KS.BKDJ
is '报考等级对照表:dm_gr_gzdj';
comment on column GR_KS.BKGZ
is '报考工种对照表:dm_gr_gz';
comment on column GR_KS.LLCJ
is '理论成绩';
comment on column GR_KS.SZCJ
is '实作成绩';
comment on column GR_KS.ZYDD
is '职业道德';
comment on column GR_KS.BKSJ
is '报考时间';
comment on column GR_KS.ZSBH
is '证书编号';
comment on column GR_KS.PZBM
is '批准部门';
comment on column GR_KS.BZ
is '备注';
comment on column GR_KS.APPLY_NO
is '申请号';
/*工人考试*/
create table GR_KS
(
ZGH CHAR(10),/*职工号*/
XH INTEGER,/*序号*/
BKDJ CHAR(40),/*报考等级对照表:dm_gr_gzdj*/
BKGZ CHAR(40),/*报考工种对照表:dm_gr_gz*/
LLCJ CHAR(6),/*理论成绩*/
SZCJ CHAR(6),/*实作成绩*/
ZYDD CHAR(6),/*职业道德*/
BKSJ VARCHAR2(12),/*报考时间*/
ZSBH VARCHAR2(30),/*证书编号*/
PZBM VARCHAR2(40),/*批准部门*/
BZ VARCHAR2(60),/*备注*/
APPLY_NO CHAR(5),/*申请号*/
MSTATE CHAR(1)/**/
)