bjquanjiang
/
zhihuidanao
1
0
Fork 0
Koodi Ongelmat 0 Pull-pyynnöt 0 Julkaisut 0 Wiki Toiminta
智慧大脑
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commitit
1 Haara
78 MiB
Haara: master
Branchit Tagit
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
zhihuidanao/DataSendApi.Program/sqlscript/教材选用数据表(ods_j...

教材选用数据表(ods_jcxysj).sql 1.6 KiB
Raaka Pysyvä linkki Normaali näkymä Historia

添加项目文件。
1 vuosi sitten
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
 1234567891011121314151617181920212223242526272829303132333435363738394041424344 
  1. 

  2. create table ods_jcxysj

  3. (

  4.   gzzyqksjid   varchar2(32) not null,

  5.   xxjgdm   varchar2(36) not null,

  6.   xxjgmc   varchar2(80) not null,

  7.   jcmc   varchar2(150) not null,

  8.   jcbh   varchar2(80) not null,

  9.   jcxz   varchar2(10) not null,

  10.   isbn   varchar2(200) not null,

  11.   zzxm   varchar2(100) ,

  12.   cbrq   varchar2(100) ,

  13.   cbs   varchar2(120) ,

  14.   sycc   varchar2(10) ,

  15.   jg   varchar2(30) ,

  16.   bc   number not null,

  17.   yc   number not null,

  18.   sfylxc   varchar2(10) ,

  19.   sfyjcjf   varchar2(10) ,

  20.   hjqk   varchar2(10) ,

  21.   sjcjsj   varchar2(60) not null,

  22.   IsPush   varchar2(2) not null

  23. );

  24. alter table ods_jcxysj add constraint ods_jcxysj_gzzyqksjid primary key (gzzyqksjid);

  25. comment on table ods_jcxysj is '̲ѡݱ';

  26. comment on column ods_jcxysj.gzzyqksjid is 'ΨһԱʶ';

  27. comment on column ods_jcxysj.xxjgdm is 'ѧУ';

  28. comment on column ods_jcxysj.xxjgmc is 'ѧУ';

  29. comment on column ods_jcxysj.jcmc is '̲';

  30. comment on column ods_jcxysj.jcbh is '̲ı';

  31. comment on column ods_jcxysj.jcxz is '̲';

  32. comment on column ods_jcxysj.isbn is 'ISBN ';

  33. comment on column ods_jcxysj.zzxm is '';

  34. comment on column ods_jcxysj.cbrq is '';

  35. comment on column ods_jcxysj.cbs is '';

  36. comment on column ods_jcxysj.sycc is 'ò';

  37. comment on column ods_jcxysj.jg is '۸Ԫ';

  38. comment on column ods_jcxysj.bc is '';

  39. comment on column ods_jcxysj.yc is 'ӡ';

  40. comment on column ods_jcxysj.sfylxc is 'Ƿϰ';

  41. comment on column ods_jcxysj.sfyjcjf is 'Ƿн̲ν̸';

  42. comment on column ods_jcxysj.hjqk is '';

  43. comment on column ods_jcxysj.sjcjsj is 'ݲɼʱ';

  44.