jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/table/2.6.jsjdTableCreate.sql

--GK_OPERATION_JSJY_JGBG
--GK_OPERATION_JSJY_JGBGFJ
--GK_OPERATION_JSJY_JGSQ
--GK_OPERATION_JSJY_JGSQFJ
--GK_OPERATION_JSJY_JGZX
--GK_OPERATION_JSJY_JGZXFJ
--GK_OPERATION_JSJY_JOBINFO
--GK_OPERATION_JSJY_JSJDBG
--GK_OPERATION_JSJY_JSJDBGFJ
--GK_OPERATION_JSJY_JSJDCBSJ
--GK_OPERATION_JSJY_JSJDCBSJFJ
--GK_OPERATION_JSJY_JSJDZX
--GK_OPERATION_JSJY_JSJDZXFJ
--GK_OPERATION_JSJY_LGYX
--GK_OPERATION_JSJY_LHBG
--GK_OPERATION_JSJY_LHBGFJ
--GK_OPERATION_JSJY_LHSQ
--GK_OPERATION_JSJY_LHSQFJ
--GK_OPERATION_JSJY_LHYX
--GK_OPERATION_JSJY_LHYXFJ

create table GK_OPERATION_JSJY_JGBG
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  flowstatus       CHAR(1),
  xmbm             NVARCHAR2(40),
  zftze            NUMBER,
  sylx             VARCHAR2(40),
  jcsj             TIMESTAMP(6)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_JGBG.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JGBG.xmmc
  is '项目名称';
comment on column GK_OPERATION_JSJY_JGBG.xmfr
  is '项目法人';
comment on column GK_OPERATION_JSJY_JGBG.jsdd
  is '建设地点';
comment on column GK_OPERATION_JSJY_JGBG.jsgm
  is '建设规模';
comment on column GK_OPERATION_JSJY_JGBG.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK_OPERATION_JSJY_JGBG.ztz
  is '总投资（万元）';
comment on column GK_OPERATION_JSJY_JGBG.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK_OPERATION_JSJY_JGBG.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK_OPERATION_JSJY_JGBG.axcd
  is '岸线长度';
comment on column GK_OPERATION_JSJY_JGBG.bwdj
  is '泊位吨级';
comment on column GK_OPERATION_JSJY_JGBG.bwhz
  is '泊位货种';
comment on column GK_OPERATION_JSJY_JGBG.tgnl
  is '通过能力';
comment on column GK_OPERATION_JSJY_JGBG.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_JGBG.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_JGBG.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JGBG.xmlx
  is '项目类型';
comment on column GK_OPERATION_JSJY_JGBG.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_JGBG.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JGBG.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_JGBG.bwyt
  is '泊位用途';
comment on column GK_OPERATION_JSJY_JGBG.zyhbwfl
  is '专业化泊位分类';
comment on column GK_OPERATION_JSJY_JGBG.lcjd
  is '流程节点';
comment on column GK_OPERATION_JSJY_JGBG.sfqswj
  is '是否缺失文件';
alter table GK_OPERATION_JSJY_JGBG
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

create table GK_OPERATION_JSJY_JGBGFJ
(
  id               VARCHAR2(40),
  ssid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  type             CHAR(1),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1),
  tbzt             CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JGSQ
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  xmbm             NVARCHAR2(40),
  zftze            NUMBER,
  sylx             VARCHAR2(40),
  jcsj             TIMESTAMP(6),
  flowstatus       CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_JGSQ.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JGSQ.xmmc
  is '项目名称';
comment on column GK_OPERATION_JSJY_JGSQ.xmfr
  is '项目法人';
comment on column GK_OPERATION_JSJY_JGSQ.jsdd
  is '建设地点';
comment on column GK_OPERATION_JSJY_JGSQ.jsgm
  is '建设规模';
comment on column GK_OPERATION_JSJY_JGSQ.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK_OPERATION_JSJY_JGSQ.ztz
  is '总投资（万元）';
comment on column GK_OPERATION_JSJY_JGSQ.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK_OPERATION_JSJY_JGSQ.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK_OPERATION_JSJY_JGSQ.axcd
  is '岸线长度';
comment on column GK_OPERATION_JSJY_JGSQ.bwdj
  is '泊位吨级';
comment on column GK_OPERATION_JSJY_JGSQ.bwhz
  is '泊位货种';
comment on column GK_OPERATION_JSJY_JGSQ.tgnl
  is '通过能力';
comment on column GK_OPERATION_JSJY_JGSQ.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_JGSQ.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_JGSQ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JGSQ.xmlx
  is '项目类型';
comment on column GK_OPERATION_JSJY_JGSQ.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_JGSQ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JGSQ.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_JGSQ.bwyt
  is '泊位用途';
comment on column GK_OPERATION_JSJY_JGSQ.zyhbwfl
  is '专业化泊位分类';
comment on column GK_OPERATION_JSJY_JGSQ.lcjd
  is '流程节点';
comment on column GK_OPERATION_JSJY_JGSQ.sfqswj
  is '是否缺失文件';
alter table GK_OPERATION_JSJY_JGSQ
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JGSQFJ
(
  id               VARCHAR2(40) not null,
  ssid             VARCHAR2(40),
  wjh              VARCHAR2(40),
  fbsj             TIMESTAMP(6),
  fbdw             VARCHAR2(100),
  fjid             VARCHAR2(40),
  szd              NUMBER,
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  wjlb             VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  fjlx             VARCHAR2(10),
  fjbz             VARCHAR2(40)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_JGSQFJ
  is '项目进度初步设计附件表';
comment on column GK_OPERATION_JSJY_JGSQFJ.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JGSQFJ.ssid
  is '项目id';
comment on column GK_OPERATION_JSJY_JGSQFJ.wjh
  is '文件号';
comment on column GK_OPERATION_JSJY_JGSQFJ.fbsj
  is '发布时间';
comment on column GK_OPERATION_JSJY_JGSQFJ.fbdw
  is '发布单位';
comment on column GK_OPERATION_JSJY_JGSQFJ.fjid
  is '附件id';
comment on column GK_OPERATION_JSJY_JGSQFJ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JGSQFJ.wjlb
  is '文件类别';
comment on column GK_OPERATION_JSJY_JGSQFJ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JGSQFJ.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_JGSQFJ.fjlx
  is '附件类型（普通附件和其他附件）';
comment on column GK_OPERATION_JSJY_JGSQFJ.fjbz
  is '附件标识';
alter table GK_OPERATION_JSJY_JGSQFJ
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JGZX
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  flowstatus       CHAR(1),
  xmbm             NVARCHAR2(40),
  zftze            NUMBER,
  sylx             VARCHAR2(40),
  jcsj             TIMESTAMP(6)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_JGZX.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JGZX.xmmc
  is '项目名称';
comment on column GK_OPERATION_JSJY_JGZX.xmfr
  is '项目法人';
comment on column GK_OPERATION_JSJY_JGZX.jsdd
  is '建设地点';
comment on column GK_OPERATION_JSJY_JGZX.jsgm
  is '建设规模';
comment on column GK_OPERATION_JSJY_JGZX.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK_OPERATION_JSJY_JGZX.ztz
  is '总投资（万元）';
comment on column GK_OPERATION_JSJY_JGZX.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK_OPERATION_JSJY_JGZX.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK_OPERATION_JSJY_JGZX.axcd
  is '岸线长度';
comment on column GK_OPERATION_JSJY_JGZX.bwdj
  is '泊位吨级';
comment on column GK_OPERATION_JSJY_JGZX.bwhz
  is '泊位货种';
comment on column GK_OPERATION_JSJY_JGZX.tgnl
  is '通过能力';
comment on column GK_OPERATION_JSJY_JGZX.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_JGZX.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_JGZX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JGZX.xmlx
  is '项目类型';
comment on column GK_OPERATION_JSJY_JGZX.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_JGZX.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JGZX.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_JGZX.bwyt
  is '泊位用途';
comment on column GK_OPERATION_JSJY_JGZX.zyhbwfl
  is '专业化泊位分类';
comment on column GK_OPERATION_JSJY_JGZX.lcjd
  is '流程节点';
comment on column GK_OPERATION_JSJY_JGZX.sfqswj
  is '是否缺失文件';
alter table GK_OPERATION_JSJY_JGZX
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JGZXFJ
(
  id               VARCHAR2(40),
  ssid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  type             CHAR(1),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1),
  tbzt             CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JOBINFO
(
  id               VARCHAR2(40) not null,
  disp             VARCHAR2(100),
  create_time      DATE default current_timestamp,
  start_time       DATE,
  end_time         DATE,
  circle           CHAR(1),
  result           VARCHAR2(100),
  interval         NUMBER,
  status           VARCHAR2(100),
  param            VARCHAR2(100),
  clazz            VARCHAR2(100),
  cron_expression  VARCHAR2(100),
  create_date_time TIMESTAMP(0) default current_timestamp not null,
  update_date_time TIMESTAMP(0) default current_timestamp not null,
  record_status    INTEGER default 1 not null,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_JOBINFO
  is '任务信息表';
comment on column GK_OPERATION_JSJY_JOBINFO.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JOBINFO.disp
  is '任务描述';
comment on column GK_OPERATION_JSJY_JOBINFO.create_time
  is '任务创建时间';
comment on column GK_OPERATION_JSJY_JOBINFO.start_time
  is '任务启动时间';
comment on column GK_OPERATION_JSJY_JOBINFO.end_time
  is '任务结束时间';
comment on column GK_OPERATION_JSJY_JOBINFO.circle
  is '是否循环';
comment on column GK_OPERATION_JSJY_JOBINFO.result
  is '上次执行结果';
comment on column GK_OPERATION_JSJY_JOBINFO.interval
  is '间隔时间';
comment on column GK_OPERATION_JSJY_JOBINFO.status
  is '任务状态';
comment on column GK_OPERATION_JSJY_JOBINFO.param
  is '执行参数';
comment on column GK_OPERATION_JSJY_JOBINFO.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_JOBINFO.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_JOBINFO.record_status
  is '数据状态';
comment on column GK_OPERATION_JSJY_JOBINFO.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_JOBINFO.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_JOBINFO.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JOBINFO.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JOBINFO.tbzt
  is '同步状态';
alter table GK_OPERATION_JSJY_JOBINFO
  add primary key (ID)
  using index 
  tablespace GK_BASIC
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JSJDBG
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  flowstatus       CHAR(1),
  xmbm             NVARCHAR2(40),
  zftze            NUMBER,
  sylx             VARCHAR2(40),
  jcsj             TIMESTAMP(6)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_JSJDBG.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JSJDBG.xmmc
  is '项目名称';
comment on column GK_OPERATION_JSJY_JSJDBG.xmfr
  is '项目法人';
comment on column GK_OPERATION_JSJY_JSJDBG.jsdd
  is '建设地点';
comment on column GK_OPERATION_JSJY_JSJDBG.jsgm
  is '建设规模';
comment on column GK_OPERATION_JSJY_JSJDBG.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK_OPERATION_JSJY_JSJDBG.ztz
  is '总投资（万元）';
comment on column GK_OPERATION_JSJY_JSJDBG.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK_OPERATION_JSJY_JSJDBG.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK_OPERATION_JSJY_JSJDBG.axcd
  is '岸线长度';
comment on column GK_OPERATION_JSJY_JSJDBG.bwdj
  is '泊位吨级';
comment on column GK_OPERATION_JSJY_JSJDBG.bwhz
  is '泊位货种';
comment on column GK_OPERATION_JSJY_JSJDBG.tgnl
  is '通过能力';
comment on column GK_OPERATION_JSJY_JSJDBG.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_JSJDBG.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_JSJDBG.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JSJDBG.xmlx
  is '项目类型';
comment on column GK_OPERATION_JSJY_JSJDBG.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_JSJDBG.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JSJDBG.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_JSJDBG.bwyt
  is '泊位用途';
comment on column GK_OPERATION_JSJY_JSJDBG.zyhbwfl
  is '专业化泊位分类';
comment on column GK_OPERATION_JSJY_JSJDBG.lcjd
  is '流程节点';
comment on column GK_OPERATION_JSJY_JSJDBG.sfqswj
  is '是否缺失文件';
alter table GK_OPERATION_JSJY_JSJDBG
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JSJDBGFJ
(
  id               VARCHAR2(40),
  ssid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  type             CHAR(1),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1),
  tbzt             CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );

create table GK_OPERATION_JSJY_JSJDCBSJ
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  flowstatus       CHAR(1),
  xmbm             NVARCHAR2(40),
  zftze            NUMBER,
  sylx             VARCHAR2(40),
  jcsj             TIMESTAMP(6)
)
tablespace GK_BASIC
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_JSJDCBSJ
  is '项目建设管理';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.xmmc
  is '项目名称';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.xmfr
  is '项目法人';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.jsdd
  is '建设地点';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.jsgm
  is '建设规模';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.ztz
  is '总投资（万元）';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.axcd
  is '岸线长度';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.bwdj
  is '泊位吨级';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.bwhz
  is '泊位货种';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.tgnl
  is '通过能力';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.xmlx
  is '项目类型';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.bwyt
  is '泊位用途';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.zyhbwfl
  is '专业化泊位分类';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.lcjd
  is '流程节点';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.sfqswj
  is '是否缺失文件';
comment on column GK_OPERATION_JSJY_JSJDCBSJ.flowstatus
  is '状态0,正常1.退回地市2完成';
alter table GK_OPERATION_JSJY_JSJDCBSJ
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JSJDCBSJFJ
(
  id               VARCHAR2(40) not null,
  ssid             VARCHAR2(40),
  wjh              VARCHAR2(40),
  fbsj             TIMESTAMP(6),
  fbdw             VARCHAR2(100),
  fjid             VARCHAR2(40),
  szd              NUMBER,
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  wjlb             VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  fjlx             VARCHAR2(10),
  fjbz             VARCHAR2(40)
)
tablespace GK_BASIC
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_JSJDCBSJFJ
  is '项目进度初步设计附件表';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.ssid
  is '项目id';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.wjh
  is '文件号';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.fbsj
  is '发布时间';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.fbdw
  is '发布单位';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.fjid
  is '附件id';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.wjlb
  is '文件类别';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.fjlx
  is '附件类型（普通附件和其他附件）';
comment on column GK_OPERATION_JSJY_JSJDCBSJFJ.fjbz
  is '附件标识';
alter table GK_OPERATION_JSJY_JSJDCBSJFJ
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JSJDZX
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  flowstatus       CHAR(1),
  zftze            NUMBER,
  sylx             VARCHAR2(40),
  jcsj             TIMESTAMP(6),
  xmbm             NVARCHAR2(40)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_JSJDZX.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_JSJDZX.xmmc
  is '项目名称';
comment on column GK_OPERATION_JSJY_JSJDZX.xmfr
  is '项目法人';
comment on column GK_OPERATION_JSJY_JSJDZX.jsdd
  is '建设地点';
comment on column GK_OPERATION_JSJY_JSJDZX.jsgm
  is '建设规模';
comment on column GK_OPERATION_JSJY_JSJDZX.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK_OPERATION_JSJY_JSJDZX.ztz
  is '总投资（万元）';
comment on column GK_OPERATION_JSJY_JSJDZX.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK_OPERATION_JSJY_JSJDZX.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK_OPERATION_JSJY_JSJDZX.axcd
  is '岸线长度';
comment on column GK_OPERATION_JSJY_JSJDZX.bwdj
  is '泊位吨级';
comment on column GK_OPERATION_JSJY_JSJDZX.bwhz
  is '泊位货种';
comment on column GK_OPERATION_JSJY_JSJDZX.tgnl
  is '通过能力';
comment on column GK_OPERATION_JSJY_JSJDZX.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_JSJDZX.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_JSJDZX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JSJDZX.xmlx
  is '项目类型';
comment on column GK_OPERATION_JSJY_JSJDZX.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_JSJDZX.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_JSJDZX.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_JSJDZX.bwyt
  is '泊位用途';
comment on column GK_OPERATION_JSJY_JSJDZX.zyhbwfl
  is '专业化泊位分类';
comment on column GK_OPERATION_JSJY_JSJDZX.lcjd
  is '流程节点';
comment on column GK_OPERATION_JSJY_JSJDZX.sfqswj
  is '是否缺失文件';
alter table GK_OPERATION_JSJY_JSJDZX
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_JSJDZXFJ
(
  id               VARCHAR2(40),
  ssid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  type             CHAR(1),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1),
  tbzt             CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_LGYX
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  zcdz             NVARCHAR2(100),
  fddbr            NVARCHAR2(40),
  gsyyzzbh         NVARCHAR2(50),
  lxr              NVARCHAR2(20),
  zczb             NVARCHAR2(40),
  lxdh             NVARCHAR2(20),
  jydy             NVARCHAR2(500),
  xkzbh            NVARCHAR2(40),
  yxrq             TIMESTAMP(6),
  ygzs             NVARCHAR2(10),
  lhys             NVARCHAR2(10),
  yysr             NVARCHAR2(10),
  lhl              NVARCHAR2(10),
  lxl              NVARCHAR2(10),
  yysrr            NVARCHAR2(10),
  lhll             NVARCHAR2(10),
  lxll             NVARCHAR2(10),
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  record_status    INTEGER,
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  tbzt             CHAR(1),
  sftb             CHAR(1),
  oneyear          NVARCHAR2(10),
  twoyear          NVARCHAR2(10)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LGYX
  is '理货延续';


create table GK_OPERATION_JSJY_LHBG
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(100),
  xkzbh            NVARCHAR2(100),
  lxr              NVARCHAR2(40),
  dh               NVARCHAR2(40),
  sqrq             TIMESTAMP(6),
  cz               NVARCHAR2(40),
  ybgdz            NVARCHAR2(40),
  xbgdz            NVARCHAR2(40),
  yfddbr           NVARCHAR2(40),
  xfddbr           NVARCHAR2(40),
  tyxyyy           NVARCHAR2(200),
  gkjshyj          NVARCHAR2(200),
  gkjshrq          TIMESTAMP(6),
  jttshyj          NVARCHAR2(200),
  jttshrq          TIMESTAMP(6),
  szd              VARCHAR2(40),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  tbzt             CHAR(1),
  sftb             CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LHBG
  is '理货变更';
comment on column GK_OPERATION_JSJY_LHBG.id
  is '主健ID';
comment on column GK_OPERATION_JSJY_LHBG.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_LHBG.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_LHBG.xkzbh
  is '许可证号';
comment on column GK_OPERATION_JSJY_LHBG.lxr
  is '联系人';
comment on column GK_OPERATION_JSJY_LHBG.dh
  is '电话';
comment on column GK_OPERATION_JSJY_LHBG.sqrq
  is '申请日期';
comment on column GK_OPERATION_JSJY_LHBG.cz
  is '传真';
comment on column GK_OPERATION_JSJY_LHBG.ybgdz
  is '原办公地址';
comment on column GK_OPERATION_JSJY_LHBG.xbgdz
  is '现办公地址';
comment on column GK_OPERATION_JSJY_LHBG.yfddbr
  is '原法定代表人';
comment on column GK_OPERATION_JSJY_LHBG.xfddbr
  is '现法定代表人';
comment on column GK_OPERATION_JSJY_LHBG.tyxyyy
  is '停业歇业原因';
comment on column GK_OPERATION_JSJY_LHBG.gkjshyj
  is '港口局意见';
comment on column GK_OPERATION_JSJY_LHBG.gkjshrq
  is '港口局审核时间';
comment on column GK_OPERATION_JSJY_LHBG.jttshyj
  is '交通厅意见';
comment on column GK_OPERATION_JSJY_LHBG.jttshrq
  is '交通厅审核时间';
comment on column GK_OPERATION_JSJY_LHBG.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_LHBG.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_LHBG.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_LHBG.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_LHBG.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_LHBG.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_LHBG.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_LHBG.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_LHBG.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_LHBG.sftb
  is '是否同步';


create table GK_OPERATION_JSJY_LHBGFJ
(
  id               VARCHAR2(40),
  bgid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1),
  tbzt             CHAR(1),
  fjid             VARCHAR2(40)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LHBGFJ
  is '理货变更附件';


create table GK_OPERATION_JSJY_LHSQ
(
  id               VARCHAR2(40) not null,
  sqr              NVARCHAR2(100),
  sqrlxfs          NVARCHAR2(20),
  sqrdz            NVARCHAR2(200),
  sqryzbm          NVARCHAR2(20),
  wtdlrxm          NVARCHAR2(20),
  wtdlrlxfs        NVARCHAR2(20),
  sqrq             TIMESTAMP(6),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  jyrid            VARCHAR2(40),
  jyrmc            VARCHAR2(40),
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  gsmc             VARCHAR2(40),
  zcdz             NVARCHAR2(200),
  fddbr            VARCHAR2(40),
  lxr              VARCHAR2(40),
  lxdh             VARCHAR2(40),
  gsyyzzbh         VARCHAR2(40),
  jydy             VARCHAR2(40),
  ygzs             VARCHAR2(40),
  lhys             VARCHAR2(40),
  zczb             VARCHAR2(40),
  sqnr             NVARCHAR2(200),
  yysr             NVARCHAR2(20),
  yysrr            NVARCHAR2(20),
  lhl              NVARCHAR2(20),
  lhll             NVARCHAR2(20),
  lxl              NVARCHAR2(20),
  lxll             NVARCHAR2(20),
  oneyear          NVARCHAR2(20),
  twoyear          NVARCHAR2(20),
  gdmc             NVARCHAR2(2000),
  zcd              NVARCHAR2(2000),
  tzgb             NVARCHAR2(2000),
  sqrqz            NVARCHAR2(20)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_LHSQ.id
  is '主键';
comment on column GK_OPERATION_JSJY_LHSQ.sqr
  is '申请人';
comment on column GK_OPERATION_JSJY_LHSQ.sqrlxfs
  is '申请人联系方式';
comment on column GK_OPERATION_JSJY_LHSQ.sqrdz
  is '申请人地址';
comment on column GK_OPERATION_JSJY_LHSQ.sqryzbm
  is '申请人邮政编码';
comment on column GK_OPERATION_JSJY_LHSQ.wtdlrxm
  is '委托代理人姓名';
comment on column GK_OPERATION_JSJY_LHSQ.wtdlrlxfs
  is '委托代理人联系方式';
comment on column GK_OPERATION_JSJY_LHSQ.sqrq
  is '申请时间';
comment on column GK_OPERATION_JSJY_LHSQ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_LHSQ.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_LHSQ.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_LHSQ.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_LHSQ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_LHSQ.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_LHSQ.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_LHSQ.gsmc
  is '公司名称';
comment on column GK_OPERATION_JSJY_LHSQ.zcdz
  is '注册地址';
comment on column GK_OPERATION_JSJY_LHSQ.fddbr
  is '法定代表人';
comment on column GK_OPERATION_JSJY_LHSQ.lxr
  is '联系人';
comment on column GK_OPERATION_JSJY_LHSQ.lxdh
  is '联系人电话';
comment on column GK_OPERATION_JSJY_LHSQ.gsyyzzbh
  is '工商营业执照编号';
comment on column GK_OPERATION_JSJY_LHSQ.jydy
  is '经营地域';
comment on column GK_OPERATION_JSJY_LHSQ.ygzs
  is '员工总数';
comment on column GK_OPERATION_JSJY_LHSQ.lhys
  is '理货员数';
comment on column GK_OPERATION_JSJY_LHSQ.zczb
  is '注册资本';
alter table GK_OPERATION_JSJY_LHSQ
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_LHSQFJ
(
  id               VARCHAR2(40) not null,
  sqid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_LHSQFJ.id
  is '主键';
comment on column GK_OPERATION_JSJY_LHSQFJ.sqid
  is '申请ID';
comment on column GK_OPERATION_JSJY_LHSQFJ.fjid
  is '附件ID';
comment on column GK_OPERATION_JSJY_LHSQFJ.fjmc
  is '附件名称';
comment on column GK_OPERATION_JSJY_LHSQFJ.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_LHSQFJ.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_LHSQFJ.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_LHSQFJ.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_LHSQFJ.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_LHSQFJ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_LHSQFJ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_LHSQFJ.tbzt
  is '同步状态';
alter table GK_OPERATION_JSJY_LHSQFJ
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_LHYX
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  zcdz             NVARCHAR2(100),
  fddbr            NVARCHAR2(40),
  gsyyzzbh         NVARCHAR2(50),
  lxr              NVARCHAR2(20),
  zczb             NVARCHAR2(40),
  lxdh             NVARCHAR2(20),
  jydy             NVARCHAR2(500),
  xkzbh            NVARCHAR2(40),
  yxrq             TIMESTAMP(6),
  ygzs             NVARCHAR2(10),
  lhys             NVARCHAR2(10),
  yysr             NVARCHAR2(10),
  lhl              NVARCHAR2(10),
  lxl              NVARCHAR2(10),
  yysrr            NVARCHAR2(10),
  lhll             NVARCHAR2(10),
  lxll             NVARCHAR2(10),
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  record_status    INTEGER,
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  tbzt             CHAR(1),
  sftb             CHAR(1),
  oneyear          NVARCHAR2(10),
  twoyear          NVARCHAR2(10)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LHYX
  is '理货延续';


create table GK_OPERATION_JSJY_LHYXFJ
(
  id               VARCHAR2(40),
  yxid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1),
  tbzt             CHAR(1),
  fjid             VARCHAR2(40)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LHYXFJ
  is '理货延续附件';


  -- Create table
create table GK_BASIC_JSJY_GKJS_XMBWGLB
(
  id               VARCHAR2(40) not null,
  xmid             VARCHAR2(40),
  bwid             VARCHAR2(40),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  szd              VARCHAR2(40),
  sftb             CHAR(1) default 'Y',
  tbzt             CHAR(2) default 'N',
  record_status    NUMBER
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 8
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table GK_BASIC_JSJY_GKJS_XMBWGLB
  is '项目泊位信息';
-- Create/Recreate primary, unique and foreign key constraints 
alter table GK_BASIC_JSJY_GKJS_XMBWGLB
  add constraint GK_BASIC_JSJY_GKJS_XMBWGLB_PK primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );