-- Create table
create table GDGA_CD
(
  objectid       INTEGER not null,
  bsm            VARCHAR2(20),
  ysdm           VARCHAR2(20),
  bdcdyh         VARCHAR2(50),
  tdbh           VARCHAR2(20),
  zdlx           VARCHAR2(10),
  djh            VARCHAR2(20),
  qxdm           VARCHAR2(10),
  jdh            VARCHAR2(100),
  jfh            VARCHAR2(100),
  zh             VARCHAR2(5),
  zdsz           VARCHAR2(500),
  txdz           VARCHAR2(200),
  tdzl           VARCHAR2(200),
  mjdw           VARCHAR2(5),
  qsxz           VARCHAR2(50),
  syqlx          VARCHAR2(50),
  qlsdfs         VARCHAR2(5),
  zddz           VARCHAR2(200),
  zdnz           VARCHAR2(200),
  zdxz           VARCHAR2(200),
  zdbz           VARCHAR2(200),
  tdyt           VARCHAR2(50),
  fbfmc          VARCHAR2(200),
  cbsymj         VARCHAR2(50),
  cbsyqssj       DATE,
  cbsyjssj       DATE,
  cbfmc          VARCHAR2(200),
  tdjb           VARCHAR2(50),
  sbdj           VARCHAR2(50),
  qdjg           VARCHAR2(50),
  zt             VARCHAR2(20),
  qsdwmc         VARCHAR2(50),
  qsdwdm         VARCHAR2(50),
  dlbm           VARCHAR2(100),
  dlmc           VARCHAR2(100),
  yqsxz          VARCHAR2(10),
  cyzl           VARCHAR2(100),
  szxml          VARCHAR2(200),
  zdmj           VARCHAR2(40),
  dqqlr          VARCHAR2(50),
  suid           VARCHAR2(50),
  gzry           VARCHAR2(20),
  dczt           VARCHAR2(50),
  xzqs           VARCHAR2(20),
  shape          SDE.ST_GEOMETRY,
  zddm           VARCHAR2(50),
  qlrzjh         VARCHAR2(20),
  qlrzjlx        VARCHAR2(100),
  tfh            VARCHAR2(50),
  qlxz           VARCHAR2(50),
  synstate       VARCHAR2(50) default (-1),
  prezddm        VARCHAR2(50),
  presuid        VARCHAR2(50),
  zbdh           NUMBER(5),
  lastmodifytime VARCHAR2(20),
  qllx           VARCHAR2(100)
)
tablespace GD_GIS_TBSPC
  pctfree 0
  initrans 4
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column GDGA_CD.synstate
  is '0:未同步，1:已同步，-1:初始状态';
-- Create/Recreate indexes 
create unique index R19_SDE_ROWID_UK on GDGA_CD (OBJECTID)
  tablespace GD_GIS_TBSPC
  pctfree 0
  initrans 4
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Grant/Revoke object privileges 
grant select, insert, update, delete, references, alter, index on GDGA_CD to GISBASE with grant option;
grant select, insert, update, delete on GDGA_CD to SDE;