zhihuidanao/DataSendApi.Program/sqlscript/职参加社团活动数据表(ods_zzcjsthdsj).sql

create table ods_zzcjsthdsj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  cyxss   number not null,
  cjsthdlx   varchar2(200) ,
  cjsthdkssj   varchar2(100) ,
  cjsthdjssj   varchar2(100) ,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_zzcjsthdsj add constraint ods_zzcjsthdsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_zzcjsthdsj is 'ְ�μ����Ż���ݱ�';
comment on column ods_zzcjsthdsj.gzzyqksjid is '��������Ψһ�Ա�ʶ';
comment on column ods_zzcjsthdsj.xxjgdm is 'ѧУ��������';
comment on column ods_zzcjsthdsj.xxjgmc is 'ѧУ��������';
comment on column ods_zzcjsthdsj.cyxss is '����ѧ����';
comment on column ods_zzcjsthdsj.cjsthdlx is '�μ����Ż����';
comment on column ods_zzcjsthdsj.cjsthdkssj is '�μ����Ż��ʼʱ��';
comment on column ods_zzcjsthdsj.cjsthdjssj is '�μ����Ż����ʱ��';
comment on column ods_zzcjsthdsj.sjcjsj is '���ݲɼ�ʱ��';