zhihuidanao/DataSendApi.Program/sqlscript/学生综合成绩与评价数据表(ods_xszhcjpjsj).sql

create table ods_xszhcjpjsj
(
  gzzyqksjid   varchar2(32) not null,
  xxjgdm   varchar2(36) not null,
  xxjgmc   varchar2(80) not null,
  xn   varchar2(60) not null,
  xq   varchar2(60) not null,
  zymc   varchar2(163) ,
  nj   varchar2(60) not null,
  bj   varchar2(60) not null,
  xjh   varchar2(60) ,
  xsxm   varchar2(120) not null,
  sxzzcj   number not null,
  whkcj   number not null,
  zyjnkccj   number not null,
  xstzjkcj   number not null,
  zhpj   number not null,
  sjcjsj   varchar2(60) not null,
  IsPush   varchar2(2) not null
);
alter table ods_xszhcjpjsj add constraint ods_xszhcjpjsj_gzzyqksjid primary key (gzzyqksjid);
comment on table ods_xszhcjpjsj is 'ѧ���ۺϳɼ����������ݱ�';
comment on column ods_xszhcjpjsj.gzzyqksjid is '��������Ψһ�Ա�ʶ';
comment on column ods_xszhcjpjsj.xxjgdm is 'ѧУ��������';
comment on column ods_xszhcjpjsj.xxjgmc is 'ѧУ��������';
comment on column ods_xszhcjpjsj.xn is 'ѧ��';
comment on column ods_xszhcjpjsj.xq is 'ѧ��';
comment on column ods_xszhcjpjsj.zymc is 'רҵ����';
comment on column ods_xszhcjpjsj.nj is '�꼶';
comment on column ods_xszhcjpjsj.bj is '�༶';
comment on column ods_xszhcjpjsj.xjh is 'ѧ����';
comment on column ods_xszhcjpjsj.xsxm is 'ѧ������';
comment on column ods_xszhcjpjsj.sxzzcj is '˼�����γɼ�';
comment on column ods_xszhcjpjsj.whkcj is '�Ļ��γɼ�';
comment on column ods_xszhcjpjsj.zyjnkccj is 'רҵ���ܿγ̳ɼ�';
comment on column ods_xszhcjpjsj.xstzjkcj is 'ѧ�����ʽ����ɼ�';
comment on column ods_xszhcjpjsj.zhpj is '�ۺ����۳ɼ�';
comment on column ods_xszhcjpjsj.sjcjsj is '���ݲɼ�ʱ��';