zhihuidanao/DataSendApi.Program/sqlscript/校区基础数据表(ods_xqjcsj).sql

create table ods_xqjcsj
(
  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,
  xqbh   varchar2(64) not null,
  xqmc   varchar2(180) not null,
  xqjc   varchar2(60) not null,
  xqszdxzqh   varchar2(50) ,
  xqdz   varchar2(300) ,
  xqyzbm   varchar2(35) ,
  xqlxdh   varchar2(35) ,
  xqfzr   varchar2(36) ,
  xqjzgzs   number not null,
  xqxszs   number not null,
  xqclrq   varchar2(50) ,
  sjcjsj   varchar2(50) not null,
  IsPush   varchar2(2) not null
);
alter table ods_xqjcsj add constraint ods_xqjcsj_xygkjcsjid primary key (xygkjcsjid);
comment on table ods_xqjcsj is '校区基础数据表';
comment on column ods_xqjcsj.xygkjcsjid is '主键数据唯一性标识';
comment on column ods_xqjcsj.provincejgbm is '省机构编码';
comment on column ods_xqjcsj.provincejgmc is '省机构名称';
comment on column ods_xqjcsj.cityjgbm is '市机构编码';
comment on column ods_xqjcsj.cityjgmc is '市机构名称';
comment on column ods_xqjcsj.countyjgbm is '区县机构编码';
comment on column ods_xqjcsj.countyjgmc is '区县机构名称';
comment on column ods_xqjcsj.xxjgdm is '学校机构代码';
comment on column ods_xqjcsj.xxjgmc is '学校机构名称';
comment on column ods_xqjcsj.xqbh is '校区编号';
comment on column ods_xqjcsj.xqmc is '校区名称';
comment on column ods_xqjcsj.xqjc is '校区简称';
comment on column ods_xqjcsj.xqszdxzqh is '校区所在地行政区划';
comment on column ods_xqjcsj.xqdz is '校区地址';
comment on column ods_xqjcsj.xqyzbm is '校区邮政编码';
comment on column ods_xqjcsj.xqlxdh is '校区联系电话';
comment on column ods_xqjcsj.xqfzr is '校区负责人';
comment on column ods_xqjcsj.xqjzgzs is '校区教职工总数';
comment on column ods_xqjcsj.xqxszs is '校区学生总数';
comment on column ods_xqjcsj.xqclrq is '校区成立日期';
comment on column ods_xqjcsj.sjcjsj is '数据采集时间';