hs
/
jsgkj


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
							-- Create table
create table GK_SHARE_JSJY_CG_JZXTTL
(
  tj_month                     VARCHAR2(20) not null,
  gk03010202000011114100000000 NUMBER default 0,
  gk03010202000011214100000000 NUMBER default 0,
  gk03010202000012014100000000 NUMBER default 0,
  gk03010202000011114110000000 NUMBER default 0,
  gk03010202000011214110000000 NUMBER default 0,
  gk03010202000012014110000000 NUMBER default 0,
  gk03010202000011114111000000 NUMBER default 0,
  gk03010202000011214111000000 NUMBER default 0,
  gk03010202000012014111000000 NUMBER default 0,
  gk03010202000011114112000000 NUMBER default 0,
  gk03010202000011214112000000 NUMBER default 0,
  gk03010202000012014112000000 NUMBER default 0,
  gk03010202000011114113000000 NUMBER default 0,
  gk03010202000011214113000000 NUMBER default 0,
  gk03010202000012014113000000 NUMBER default 0,
  gk03010202000011114119000000 NUMBER default 0,
  gk03010202000011214119000000 NUMBER default 0,
  gk03010202000012014119000000 NUMBER default 0,
  gk03010202000011114120000000 NUMBER default 0,
  gk03010202000011214120000000 NUMBER default 0,
  gk03010202000012014120000000 NUMBER default 0,
  gk03010202000011114121000000 NUMBER default 0,
  gk03010202000011214121000000 NUMBER default 0,
  gk03010202000012014121000000 NUMBER default 0,
  gk03010202000011114122000000 NUMBER default 0,
  gk03010202000011214122000000 NUMBER default 0,
  gk03010202000012014122000000 NUMBER default 0,
  gk03010202000011114123000000 NUMBER default 0,
  gk03010202000011214123000000 NUMBER default 0,
  gk03010202000012014123000000 NUMBER default 0,
  gk03010202000011114129000000 NUMBER default 0,
  gk03010202000011214129000000 NUMBER default 0,
  gk03010202000012014129000000 NUMBER default 0,
  gk03010202000011114200000000 NUMBER default 0,
  gk03010202000011214200000000 NUMBER default 0,
  gk03010202000012014200000000 NUMBER default 0,
  gk03010202000011114300000000 NUMBER default 0,
  gk03010202000011214300000000 NUMBER default 0,
  gk03010202000012014300000000 NUMBER default 0,
  gk03010202000010014100000000 NUMBER default 0,
  gk03010202000010014110000000 NUMBER default 0,
  gk03010202000010014111000000 NUMBER default 0,
  gk03010202000010014112000000 NUMBER default 0,
  gk03010202000010014113000000 NUMBER default 0,
  gk03010202000010014119000000 NUMBER default 0,
  gk03010202000010014120000000 NUMBER default 0,
  gk03010202000010014121000000 NUMBER default 0,
  gk03010202000010014122000000 NUMBER default 0,
  gk03010202000010014123000000 NUMBER default 0,
  gk03010202000010014129000000 NUMBER default 0,
  gk03010202000010014200000000 NUMBER default 0,
  gk03010202000010014300000000 NUMBER default 0,
  create_date_time             TIMESTAMP(6) default current_timestamp,
  update_date_time             TIMESTAMP(6) default current_timestamp,
  create_user                  VARCHAR2(40),
  update_user                  VARCHAR2(40),
  szd                          VARCHAR2(20),
  record_status                NUMBER(38) default 1,
  sftb                         CHAR(1) default 'Y' not null,
  tbzt                         CHAR(1) default 'N' not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255;
-- Add comments to the columns 
comment on column GK_SHARE_JSJY_CG_JZXTTL.tj_month
  is '月份';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114100000000
  is 'TEU国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214100000000
  is 'TEU内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014100000000
  is 'TEU国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114110000000
  is 'TEU空箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214110000000
  is 'TEU空箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014110000000
  is 'TEU空箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114111000000
  is '空箱45英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214111000000
  is '空箱45英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014111000000
  is '空箱45英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114112000000
  is '空箱40英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214112000000
  is '空箱40英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014112000000
  is '空箱40英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114113000000
  is '空箱20英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214113000000
  is '空箱20英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014113000000
  is '空箱20英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114119000000
  is '其他空箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214119000000
  is '其他空箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014119000000
  is '其他空箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114120000000
  is 'TEU重箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214120000000
  is 'TEU重箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014120000000
  is 'TEU重箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114121000000
  is '重箱45英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214121000000
  is '重箱45英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014121000000
  is '重箱45英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114122000000
  is '重箱40英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214122000000
  is '重箱40英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014122000000
  is '重箱40英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114123000000
  is '重箱20英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214123000000
  is '重箱20英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014123000000
  is '重箱20英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114129000000
  is '其他重箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214129000000
  is '其他重箱内支线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014129000000
  is '其他重箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114200000000
  is '国际航线合计重量';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214200000000
  is '内支线合计重量';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014200000000
  is '国内航线合计重量';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011114300000000
  is '国际航线合计货重';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000011214300000000
  is '内支线合计货重';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000012014300000000
  is '国内航线合计货重';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014100000000
  is 'TEU总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014110000000
  is '空箱TEU总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014111000000
  is '空箱45英尺箱总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014112000000
  is '空箱40英尺箱总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014113000000
  is '空箱20英尺箱总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014119000000
  is '空箱其他总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014120000000
  is '空箱TEU总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014121000000
  is '重箱45英尺箱总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014122000000
  is '重箱40英尺箱总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014123000000
  is '重箱20英尺箱总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014129000000
  is '重箱其他总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014200000000
  is '合计总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.gk03010202000010014300000000
  is '货重总计';
comment on column GK_SHARE_JSJY_CG_JZXTTL.create_date_time
  is '创建时间';
comment on column GK_SHARE_JSJY_CG_JZXTTL.update_date_time
  is '更新时间';
comment on column GK_SHARE_JSJY_CG_JZXTTL.create_user
  is '创建人';
comment on column GK_SHARE_JSJY_CG_JZXTTL.update_user
  is '更新人';
comment on column GK_SHARE_JSJY_CG_JZXTTL.szd
  is '所在地';
comment on column GK_SHARE_JSJY_CG_JZXTTL.record_status
  is '记录状态';
comment on column GK_SHARE_JSJY_CG_JZXTTL.sftb
  is '是否同步';
comment on column GK_SHARE_JSJY_CG_JZXTTL.tbzt
  is '同步状态';
-- Create/Recreate primary, unique and foreign key constraints 
alter table GK_SHARE_JSJY_CG_JZXTTL
  add constraint GK_SHARE_JSJY_CG_JZXTTL_PK primary key (TJ_MONTH)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255;