bjquanjiang
/
zhihuidanao
1
0
Vork 0
Code Kwesties 0 Pull-aanvragen 0 Publicaties 0 Wiki Activiteit
智慧大脑
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 Commits
1 Branch
78 MiB
Branch: master
Branches Labels
${ item.name }
Maak branch ${ searchTerm }
van 'master'
${ noResults }
zhihuidanao/DataSendApi.Program/sqlscript/德育活动数据表(ods_d...

德育活动数据表(ods_dyhdsj).sql 1.7 KiB
Ruw Permalink Normale weergave Geschiedenis

添加项目文件。
1 jaar geleden
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
 1234567891011121314151617181920212223242526272829303132333435363738394041424344 
  1. 

  2. create table ods_dyhdsj

  3. (

  4.   gzzyqksjid   varchar2(32) not null,

  5.   xxjgdm   varchar2(36) not null,

  6.   xxjgmc   varchar2(180) not null,

  7.   hdmc   varchar2(132) not null,

  8.   sszt   varchar2(163) ,

  9.   hdbk   varchar2(200) ,

  10.   hdzt   varchar2(10) ,

  11.   hdlx   varchar2(10) not null,

  12.   hdnr   varchar2(300) ,

  13.   zbdw   varchar2(200) not null,

  14.   zbdwjb   varchar2(10) not null,

  15.   hdksrq   varchar2(200) not null,

  16.   hdjsrq   varchar2(200) not null,

  17.   xffzr   varchar2(32) ,

  18.   cybjs   number not null,

  19.   cyjss   number not null,

  20.   cyxss   number not null,

  21.   sjcjsj   varchar2(60) not null,

  22.   IsPush   varchar2(2) not null

  23. );

  24. alter table ods_dyhdsj add constraint ods_dyhdsj_gzzyqksjid primary key (gzzyqksjid);

  25. comment on table ods_dyhdsj is 'ݱ';

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

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

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

  29. comment on column ods_dyhdsj.hdmc is '';

  30. comment on column ods_dyhdsj.sszt is 'ר';

  31. comment on column ods_dyhdsj.hdbk is '';

  32. comment on column ods_dyhdsj.hdzt is '';

  33. comment on column ods_dyhdsj.hdlx is '';

  34. comment on column ods_dyhdsj.hdnr is '';

  35. comment on column ods_dyhdsj.zbdw is '쵥λ';

  36. comment on column ods_dyhdsj.zbdwjb is '쵥λ';

  37. comment on column ods_dyhdsj.hdksrq is 'ʼ';

  38. comment on column ods_dyhdsj.hdjsrq is '';

  39. comment on column ods_dyhdsj.xffzr is 'У';

  40. comment on column ods_dyhdsj.cybjs is '༶';

  41. comment on column ods_dyhdsj.cyjss is 'ʦ';

  42. comment on column ods_dyhdsj.cyxss is 'ѧ';

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

  44.