jsgkj/gkjsjy/docs/DB/货物分析表sql/集装箱吞吐量(进港).txt

-- Create table
create table GK_SHARE_JSJY_JG_JZXTTL
(
  tj_month                     VARCHAR2(20) not null,
  gk03010202000021114100000000 NUMBER default 0,
  gk03010202000021214100000000 NUMBER default 0,
  gk03010202000022014100000000 NUMBER default 0,
  gk03010202000021114110000000 NUMBER default 0,
  gk03010202000021214110000000 NUMBER default 0,
  gk03010202000022014110000000 NUMBER default 0,
  gk03010202000021114111000000 NUMBER default 0,
  gk03010202000021214111000000 NUMBER default 0,
  gk03010202000022014111000000 NUMBER default 0,
  gk03010202000021114112000000 NUMBER default 0,
  gk03010202000021214112000000 NUMBER default 0,
  gk03010202000022014112000000 NUMBER default 0,
  gk03010202000021114113000000 NUMBER default 0,
  gk03010202000021214113000000 NUMBER default 0,
  gk03010202000022014113000000 NUMBER default 0,
  gk03010202000021114119000000 NUMBER default 0,
  gk03010202000021214119000000 NUMBER default 0,
  gk03010202000022014119000000 NUMBER default 0,
  gk03010202000021114120000000 NUMBER default 0,
  gk03010202000021214120000000 NUMBER default 0,
  gk03010202000022014120000000 NUMBER default 0,
  gk03010202000021114121000000 NUMBER default 0,
  gk03010202000021214121000000 NUMBER default 0,
  gk03010202000022014121000000 NUMBER default 0,
  gk03010202000021114122000000 NUMBER default 0,
  gk03010202000021214122000000 NUMBER default 0,
  gk03010202000022014122000000 NUMBER default 0,
  gk03010202000021114123000000 NUMBER default 0,
  gk03010202000021214123000000 NUMBER default 0,
  gk03010202000022014123000000 NUMBER default 0,
  gk03010202000021114129000000 NUMBER default 0,
  gk03010202000021214129000000 NUMBER default 0,
  gk03010202000022014129000000 NUMBER default 0,
  gk03010202000021114200000000 NUMBER default 0,
  gk03010202000021214200000000 NUMBER default 0,
  gk03010202000022014200000000 NUMBER default 0,
  gk03010202000021114300000000 NUMBER default 0,
  gk03010202000021214300000000 NUMBER default 0,
  gk03010202000022014300000000 NUMBER default 0,
  gk03010202000020014100000000 NUMBER default 0,
  gk03010202000020014110000000 NUMBER default 0,
  gk03010202000020014111000000 NUMBER default 0,
  gk03010202000020014112000000 NUMBER default 0,
  gk03010202000020014113000000 NUMBER default 0,
  gk03010202000020014119000000 NUMBER default 0,
  gk03010202000020014120000000 NUMBER default 0,
  gk03010202000020014121000000 NUMBER default 0,
  gk03010202000020014122000000 NUMBER default 0,
  gk03010202000020014123000000 NUMBER default 0,
  gk03010202000020014129000000 NUMBER default 0,
  gk03010202000020014200000000 NUMBER default 0,
  gk03010202000020014300000000 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_JG_JZXTTL.tj_month
  is '月份';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114100000000
  is 'TEU国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214100000000
  is 'TEU内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014100000000
  is 'TEU国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114110000000
  is 'TEU空箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214110000000
  is 'TEU空箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014110000000
  is 'TEU空箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114111000000
  is '空箱45英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214111000000
  is '空箱45英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014111000000
  is '空箱45英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114112000000
  is '空箱40英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214112000000
  is '空箱40英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014112000000
  is '空箱40英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114113000000
  is '空箱20英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214113000000
  is '空箱20英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014113000000
  is '空箱20英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114119000000
  is '其他空箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214119000000
  is '其他空箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014119000000
  is '其他空箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114120000000
  is 'TEU重箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214120000000
  is 'TEU重箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014120000000
  is 'TEU重箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114121000000
  is '重箱45英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214121000000
  is '重箱45英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014121000000
  is '重箱45英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114122000000
  is '重箱40英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214122000000
  is '重箱40英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014122000000
  is '重箱40英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114123000000
  is '重箱20英尺箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214123000000
  is '重箱20英尺箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014123000000
  is '重箱20英尺箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114129000000
  is '其他重箱国际航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214129000000
  is '其他重箱内支线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014129000000
  is '其他重箱国内航线合计箱数';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114200000000
  is '国际航线合计重量';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214200000000
  is '内支线合计重量';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014200000000
  is '国内航线合计重量';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021114300000000
  is '国际航线合计货重';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000021214300000000
  is '内支线合计货重';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000022014300000000
  is '国内航线合计货重';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014100000000
  is 'TEU总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014110000000
  is '空箱TEU总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014111000000
  is '空箱45英尺箱总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014112000000
  is '空箱40英尺箱总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014113000000
  is '空箱20英尺箱总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014119000000
  is '空箱其他总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014120000000
  is '空箱TEU总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014121000000
  is '重箱45英尺箱总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014122000000
  is '重箱40英尺箱总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014123000000
  is '重箱20英尺箱总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014129000000
  is '重箱其他总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014200000000
  is '合计总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.gk03010202000020014300000000
  is '货重总计';
comment on column GK_SHARE_JSJY_JG_JZXTTL.create_date_time
  is '创建时间';
comment on column GK_SHARE_JSJY_JG_JZXTTL.update_date_time
  is '更新时间';
comment on column GK_SHARE_JSJY_JG_JZXTTL.create_user
  is '创建人';
comment on column GK_SHARE_JSJY_JG_JZXTTL.update_user
  is '更新人';
comment on column GK_SHARE_JSJY_JG_JZXTTL.szd
  is '所在地';
comment on column GK_SHARE_JSJY_JG_JZXTTL.record_status
  is '记录状态';
comment on column GK_SHARE_JSJY_JG_JZXTTL.sftb
  is '是否同步';
comment on column GK_SHARE_JSJY_JG_JZXTTL.tbzt
  is '同步状态';
-- Create/Recreate primary, unique and foreign key constraints 
alter table GK_SHARE_JSJY_JG_JZXTTL
  add constraint GK_SHARE_JSJY_JG_JZXTTL_PK primary key (TJ_MONTH)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255;