-- Create table
create table SD_YK.YK_CGJHMX
(
  CGJHDH VARCHAR2(16) not null,
  YPNM00 NUMBER(10) not null,
  YPMC00 VARCHAR2(160) not null,
  YPGG00 VARCHAR2(50),
  CGDW00 VARCHAR2(12) not null,
  ZHL000 NUMBER(13,3) not null,
  JHCGSL NUMBER(13,3),
  GJDJ00 NUMBER(12,4),
  LSDJ00 NUMBER(12,4),
  SCCJBH VARCHAR2(10),
  SCCJZW VARCHAR2(60),
  GMP000 CHAR(1),
  GHDWNM NUMBER(5),
  CGMXXH NUMBER(16) not null,
  KCSL00 NUMBER(31,3),
  CGCKSL NUMBER(12,2),
  BZ0000 VARCHAR2(100),
  JHSYSL NUMBER(31,3),
  YFZSL0 NUMBER(12,2),
  SHSL00 NUMBER(13,3),
  JQYL00 NUMBER(31,3),
  TYCGSL NUMBER(13,3),
  SYSYL0 NUMBER(12,2),
  SYCYYL NUMBER(12,2)
)
tablespace TS_YK
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 9920
    next 1
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate check constraints 
alter table SD_YK.YK_CGJHMX
  add constraint YK_CGJHMX
  check (ZHL000 > 0 AND JHCGSL >= 0);
-- Create/Recreate indexes 
create index INDEX_YK_CGJHMX_CGJHDH on SD_YK.YK_CGJHMX (CGJHDH, YPNM00)
  tablespace TS_YK_INDEX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 2816K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Grant/Revoke object privileges 
grant select, insert, update, delete, references, alter, index on SD_YK.YK_CGJHMX to SD_HOSPITAL;