zhihuidanao/DataSendApi.Program/sqlscript/中职实习基础数据表(ods_zzsxjcsj).sql

create table ods_zzsxjcsj
(
  gzsxjysjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  xsxh   varchar2(45) not null,
  xsxm   varchar2(45) not null,
  zymc   varchar2(120) not null,
  xn   varchar2(50) not null,
  xq   varchar2(50) not null,
  sxbj   varchar2(100) not null,
  sxxmmc   varchar2(250) not null,
  sxlb   varchar2(10) not null,
  sxsfks   varchar2(10) not null,
  sxsfjs   varchar2(10) not null,
  sxhy   varchar2(4) not null,
  sxkssj   varchar2(32) not null,
  sxjssj   varchar2(32) not null,
  sxqx   varchar2(10) ,
  sxdwly   varchar2(10) not null,
  sxcslx   varchar2(10) not null,
  sxjdh   varchar2(10) not null,
  sxdwmc   varchar2(165) ,
  sxdwdz   varchar2(132) ,
  sxgwmc   varchar2(110) ,
  zsap   varchar2(10) ,
  zydkcd   varchar2(10) ,
  gmbxzl   varchar2(10) ,
  bxgmf   varchar2(10) ,
  sjcjsj   varchar2(64) not null,
  IsPush   varchar2(2) not null
);
alter table ods_zzsxjcsj add constraint ods_zzsxjcsj_gzsxjysjid primary key (gzsxjysjid);
comment on table ods_zzsxjcsj is '��ְʵϰ�������ݱ�';
comment on column ods_zzsxjcsj.gzsxjysjid is '��������Ψһ�Ա�ʶ';
comment on column ods_zzsxjcsj.xxjgdm is 'ѧУ��������';
comment on column ods_zzsxjcsj.xxjgmc is 'ѧУ��������';
comment on column ods_zzsxjcsj.xsxh is 'ѧ��ѧ��';
comment on column ods_zzsxjcsj.xsxm is 'ѧ������';
comment on column ods_zzsxjcsj.zymc is 'רҵ����';
comment on column ods_zzsxjcsj.xn is 'ѧ��';
comment on column ods_zzsxjcsj.xq is 'ѧ��';
comment on column ods_zzsxjcsj.sxbj is 'ʵϰ�༶';
comment on column ods_zzsxjcsj.sxxmmc is 'ʵϰ��Ŀ����';
comment on column ods_zzsxjcsj.sxlb is 'ʵϰ���';
comment on column ods_zzsxjcsj.sxsfks is 'ʵϰ�Ƿ�ʼ';
comment on column ods_zzsxjcsj.sxsfjs is 'ʵϰ�Ƿ����';
comment on column ods_zzsxjcsj.sxhy is 'ʵϰ��ҵ';
comment on column ods_zzsxjcsj.sxkssj is 'ʵϰ��ʼʱ��';
comment on column ods_zzsxjcsj.sxjssj is 'ʵϰ����ʱ��';
comment on column ods_zzsxjcsj.sxqx is 'ʵϰȥ��';
comment on column ods_zzsxjcsj.sxdwly is 'ʵϰ��λ��Դ';
comment on column ods_zzsxjcsj.sxcslx is 'ʵϰ��������';
comment on column ods_zzsxjcsj.sxjdh is 'ʵѵ���غ�';
comment on column ods_zzsxjcsj.sxdwmc is 'ʵϰ��λ����';
comment on column ods_zzsxjcsj.sxdwdz is 'ʵϰ��λ��ַ';
comment on column ods_zzsxjcsj.sxgwmc is 'ʵϰ��λ����';
comment on column ods_zzsxjcsj.zsap is 'ס�ް���';
comment on column ods_zzsxjcsj.zydkcd is 'רҵ�Կڳ̶�';
comment on column ods_zzsxjcsj.gmbxzl is '����������';
comment on column ods_zzsxjcsj.bxgmf is '���չ���';
comment on column ods_zzsxjcsj.sjcjsj is '���ݲɼ�ʱ��';