zhihuidanao/DataSendApi.Program/sqlscript/校内实训基地数据表(ods_xnsxjdsj).sql

create table ods_xnsxjdsj
(
  gzzyqksjid   varchar2(32) ,
  xxjgdm   varchar2(36) ,
  xxjgmc   varchar2(80) ,
  sxjdh   varchar2(32) ,
  sxjdmc   varchar2(200) ,
  clnd   varchar2(10) ,
  mxzy   varchar2(200) ,
  zcbm   varchar2(10) not null,
  pzrq   varchar2(20) not null,
  sxss   number not null,
  sxxmzs   number ,
  jdlb   varchar2(10) ,
  jzmj   number ,
  yqsbzs   number ,
  sjjxgws   number ,
  glryzz   varchar2(12) ,
  glryjz   varchar2(12) ,
  sjcjsj   varchar2(60),
  IsPush   varchar2(2) not null
);
alter table ods_xnsxjdsj add constraint ods_xnsxjdsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_xnsxjdsj is 'У��ʵѵ�������ݱ�';
comment on column ods_xnsxjdsj.gzzyqksjid is '��������Ψһ�Ա�ʶ';
comment on column ods_xnsxjdsj.xxjgdm is 'ѧУ��������';
comment on column ods_xnsxjdsj.xxjgmc is 'ѧУ��������';
comment on column ods_xnsxjdsj.sxjdh is 'ʵѵ���غ�';
comment on column ods_xnsxjdsj.sxjdmc is 'ʵѵ��������';
comment on column ods_xnsxjdsj.clnd is '�������';
comment on column ods_xnsxjdsj.mxzy is '����רҵ';
comment on column ods_xnsxjdsj.zcbm is '����Ϊʵѵ������Ŀ֧�ֲ���';
comment on column ods_xnsxjdsj.pzrq is '��׼����';
comment on column ods_xnsxjdsj.sxss is 'ʵѵ����';
comment on column ods_xnsxjdsj.sxxmzs is 'ʵѵ��Ŀ����';
comment on column ods_xnsxjdsj.jdlb is '�������';
comment on column ods_xnsxjdsj.jzmj is '�������';
comment on column ods_xnsxjdsj.yqsbzs is '�����豸����';
comment on column ods_xnsxjdsj.sjjxgws is 'ʵ����ѧ��λ��';
comment on column ods_xnsxjdsj.glryzz is '������Ա(רְ)';
comment on column ods_xnsxjdsj.glryjz is '������Ա(��ְ)';
comment on column ods_xnsxjdsj.sjcjsj is '���ݲɼ�ʱ��';