-- Start of DDL Script for Table SD_HOSPITAL.BM_GYZHB0_WXYZKS
-- Generated 2011-5-25 16:08:24 from SD_HOSPITAL@DYHIS

CREATE TABLE bm_gyzhb0_wxyzks
    (bmbh00                         NUMBER(5,0) NOT NULL,
    bmmc00                         VARCHAR2(20))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  TABLESPACE  ts_yy
  STORAGE   (
    INITIAL     1048576
    NEXT        1048576
    PCTINCREASE 0
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
  NOCACHE
  NOMONITORING
/

-- Grants for Table
GRANT SELECT ON bm_gyzhb0_wxyzks TO shida
/




-- Constraints for BM_GYZHB0_WXYZKS

ALTER TABLE bm_gyzhb0_wxyzks
ADD CONSTRAINT pk_bm_gyzhb0_wxyzks_bmbh00 PRIMARY KEY (bmbh00)
USING INDEX
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  ts_yy
  STORAGE   (
    INITIAL     1048576
    NEXT        1048576
    PCTINCREASE 0
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
/


-- End of DDL Script for Table SD_HOSPITAL.BM_GYZHB0_WXYZKS