hs
/
jsgkj


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
							-- Create table
create table GK_SHARE_JSJY_HJ_JZXTTL
(
  tj_month                     VARCHAR2(20) not null,
  gk03010202000001114100000000 NUMBER default 0,
  gk03010202000001214100000000 NUMBER default 0,
  gk03010202000002014100000000 NUMBER default 0,
  gk03010202000001114110000000 NUMBER default 0,
  gk03010202000001214110000000 NUMBER default 0,
  gk03010202000002014110000000 NUMBER default 0,
  gk03010202000001114111000000 NUMBER default 0,
  gk03010202000001214111000000 NUMBER default 0,
  gk03010202000002014111000000 NUMBER default 0,
  gk03010202000001114112000000 NUMBER default 0,
  gk03010202000001214112000000 NUMBER default 0,
  gk03010202000002014112000000 NUMBER default 0,
  gk03010202000001114113000000 NUMBER default 0,
  gk03010202000001214113000000 NUMBER default 0,
  gk03010202000002014113000000 NUMBER default 0,
  gk03010202000001114119000000 NUMBER default 0,
  gk03010202000001214119000000 NUMBER default 0,
  gk03010202000002014119000000 NUMBER default 0,
  gk03010202000001114120000000 NUMBER default 0,
  gk03010202000001214120000000 NUMBER default 0,
  gk03010202000002014120000000 NUMBER default 0,
  gk03010202000001114121000000 NUMBER default 0,
  gk03010202000001214121000000 NUMBER default 0,
  gk03010202000002014121000000 NUMBER default 0,
  gk03010202000001114122000000 NUMBER default 0,
  gk03010202000001214122000000 NUMBER default 0,
  gk03010202000002014122000000 NUMBER default 0,
  gk03010202000001114123000000 NUMBER default 0,
  gk03010202000001214123000000 NUMBER default 0,
  gk03010202000002014123000000 NUMBER default 0,
  gk03010202000001114129000000 NUMBER default 0,
  gk03010202000001214129000000 NUMBER default 0,
  gk03010202000002014129000000 NUMBER default 0,
  gk03010202000001114200000000 NUMBER default 0,
  gk03010202000001214200000000 NUMBER default 0,
  gk03010202000002014200000000 NUMBER default 0,
  gk03010202000001114300000000 NUMBER default 0,
  gk03010202000001214300000000 NUMBER default 0,
  gk03010202000002014300000000 NUMBER default 0,
  gk03010202000000014100000000 NUMBER default 0,
  gk03010202000000014110000000 NUMBER default 0,
  gk03010202000000014111000000 NUMBER default 0,
  gk03010202000000014112000000 NUMBER default 0,
  gk03010202000000014113000000 NUMBER default 0,
  gk03010202000000014119000000 NUMBER default 0,
  gk03010202000000014120000000 NUMBER default 0,
  gk03010202000000014121000000 NUMBER default 0,
  gk03010202000000014122000000 NUMBER default 0,
  gk03010202000000014123000000 NUMBER default 0,
  gk03010202000000014129000000 NUMBER default 0,
  gk03010202000000014200000000 NUMBER default 0,
  gk03010202000000014300000000 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_HJ_JZXTTL.tj_month
  is '月份';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114100000000
  is 'TEU国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214100000000
  is 'TEU内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014100000000
  is 'TEU国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114110000000
  is 'TEU空箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214110000000
  is 'TEU空箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014110000000
  is 'TEU空箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114111000000
  is '空箱45英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214111000000
  is '空箱45英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014111000000
  is '空箱45英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114112000000
  is '空箱40英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214112000000
  is '空箱40英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014112000000
  is '空箱40英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114113000000
  is '空箱20英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214113000000
  is '空箱20英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014113000000
  is '空箱20英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114119000000
  is '其他空箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214119000000
  is '其他空箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014119000000
  is '其他空箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114120000000
  is 'TEU重箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214120000000
  is 'TEU重箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014120000000
  is 'TEU重箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114121000000
  is '重箱45英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214121000000
  is '重箱45英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014121000000
  is '重箱45英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114122000000
  is '重箱40英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214122000000
  is '重箱40英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014122000000
  is '重箱40英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114123000000
  is '重箱20英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214123000000
  is '重箱20英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014123000000
  is '重箱20英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114129000000
  is '其他重箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214129000000
  is '其他重箱内支线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014129000000
  is '其他重箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114200000000
  is '国际航线合计重量';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214200000000
  is '内支线合计重量';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014200000000
  is '国内航线合计重量';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001114300000000
  is '国际航线合计货重';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000001214300000000
  is '内支线合计货重';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000002014300000000
  is '国内航线合计货重';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014100000000
  is 'TEU总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014110000000
  is '空箱TEU总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014111000000
  is '空箱45英尺箱总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014112000000
  is '空箱40英尺箱总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014113000000
  is '空箱20英尺箱总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014119000000
  is '空箱其他总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014120000000
  is '空箱TEU总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014121000000
  is '重箱45英尺箱总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014122000000
  is '重箱40英尺箱总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014123000000
  is '重箱20英尺箱总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014129000000
  is '重箱其他总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014200000000
  is '合计总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.gk03010202000000014300000000
  is '货重总计';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.create_date_time
  is '创建时间';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.update_date_time
  is '更新时间';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.create_user
  is '创建人';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.update_user
  is '更新人';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.szd
  is '所在地';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.record_status
  is '记录状态';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.sftb
  is '是否同步';
comment on column GK_SHARE_JSJY_HJ_JZXTTL.tbzt
  is '同步状态';
-- Create/Recreate primary, unique and foreign key constraints 
alter table GK_SHARE_JSJY_HJ_JZXTTL
  add constraint GK_SHARE_JSJY_HJ_JZXTTL_PK primary key (TJ_MONTH)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255;