|
-
- create table ods_zzxxgkjcsj
- (
- xygkjcsjid varchar2(32) not null,
- provincejgbm varchar2(12) not null,
- provincejgmc varchar2(80) not null,
- cityjgbm varchar2(12) not null,
- cityjgmc varchar2(80) not null,
- countyjgbm varchar2(12) not null,
- countyjgmc varchar2(80) not null,
- xxjgdm varchar2(36) not null,
- xxjgmc varchar2(80) not null,
- xxlb varchar2(10) not null,
- xxsszgjyxzbm varchar2(65) ,
- xxjbzmc varchar2(120) not null,
- xxjbzxz varchar2(4) not null,
- xxfzrxm varchar2(120) ,
- jxrq varchar2(32) not null,
- xyjss number not null,
- xyxss number not null,
- bxkszys number not null,
- syxx varchar2(32) not null,
- sjcjsj varchar2(50) not null,
- IsPush varchar2(2) not null
- );
- alter table ods_zzxxgkjcsj add constraint ods_zzxxgkjcsj_xygkjcsjid primary key (xygkjcsjid);
- comment on table ods_zzxxgkjcsj is '中职学校概况基础数据表';
- comment on column ods_zzxxgkjcsj.xygkjcsjid is '主键数据唯一性标识';
- comment on column ods_zzxxgkjcsj.provincejgbm is '省机构编码';
- comment on column ods_zzxxgkjcsj.provincejgmc is '省机构名称';
- comment on column ods_zzxxgkjcsj.cityjgbm is '市机构编码';
- comment on column ods_zzxxgkjcsj.cityjgmc is '市机构名称';
- comment on column ods_zzxxgkjcsj.countyjgbm is '区县机构编码';
- comment on column ods_zzxxgkjcsj.countyjgmc is '区县机构名称';
- comment on column ods_zzxxgkjcsj.xxjgdm is '学校机构代码';
- comment on column ods_zzxxgkjcsj.xxjgmc is '学校名称';
- comment on column ods_zzxxgkjcsj.xxlb is '学校类别';
- comment on column ods_zzxxgkjcsj.xxsszgjyxzbm is '学校所属主管教育行政部门';
- comment on column ods_zzxxgkjcsj.xxjbzmc is '学校举办者名称';
- comment on column ods_zzxxgkjcsj.xxjbzxz is '学校举办者性质';
- comment on column ods_zzxxgkjcsj.xxfzrxm is '学校负责人姓名（校长）';
- comment on column ods_zzxxgkjcsj.jxrq is '建校日期（年月）';
- comment on column ods_zzxxgkjcsj.xyjss is '现有教职工总数';
- comment on column ods_zzxxgkjcsj.xyxss is '现有学生数';
- comment on column ods_zzxxgkjcsj.bxkszys is '本校开设专业数';
- comment on column ods_zzxxgkjcsj.syxx is '是否国家双优学校/省级双优学校/否';
- comment on column ods_zzxxgkjcsj.sjcjsj is '数据采集时间';
|
