zhihuidanao/DataSendApi.Program/sqlscript/资质证书数据表(ods_zzzssj).sql

create table ods_zzzssj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  jszgzrs   number not null,
  gjzcrs   number not null,
  zjzcrs   number not null,
  cjzcrs   number not null,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_zzzssj add constraint ods_zzzssj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_zzzssj is '����֤�����ݱ�';
comment on column ods_zzzssj.gzzyqksjid is '��������Ψһ�Ա�ʶ';
comment on column ods_zzzssj.xxjgdm is 'ѧУ��������';
comment on column ods_zzzssj.xxjgmc is 'ѧУ��������';
comment on column ods_zzzssj.jszgzrs is '��ʦ�ʸ�֤����';
comment on column ods_zzzssj.gjzcrs is '�߼�ְ������';
comment on column ods_zzzssj.zjzcrs is '�м�ְ������';
comment on column ods_zzzssj.cjzcrs is '����ְ������';
comment on column ods_zzzssj.sjcjsj is '���ݲɼ�ʱ��';