-- Start of DDL Script for Table SD_HOSPITAL.BA_JKBMDY
-- Generated 2022-5-6 16:13:45 from SD_HOSPITAL@FW2

CREATE TABLE ba_jkbmdy
    (bmbh00                         NUMBER(5,0) NOT NULL,
    bmmc00                         VARCHAR2(20 BYTE) NOT NULL,
    yyid00                         CHAR(6 BYTE),
    jkbmbh                         VARCHAR2(20 BYTE),
    jkbmmc                         VARCHAR2(20 BYTE),
    wbbmbh                         VARCHAR2(20 BYTE),
    wbbmmc                         VARCHAR2(20 BYTE),
    czrq00                         CHAR(8 BYTE))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  TABLESPACE  ts_yy
  STORAGE   (
    INITIAL     65536
    NEXT        1048576
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
  NOCACHE
  MONITORING
  NOPARALLEL
  LOGGING
/





-- Indexes for BA_JKBMDY

CREATE INDEX index_ba_jkbmdy_bmbh00 ON ba_jkbmdy
  (
    bmbh00                          ASC
  )
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  ts_yy
  STORAGE   (
    INITIAL     65536
    NEXT        1048576
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
NOPARALLEL
LOGGING
/



-- End of DDL Script for Table SD_HOSPITAL.BA_JKBMDY