728x90
반응형

/* 테이블 생성 */
CREATE TABLE TEST.DI_ZIPIFO (
  SEQ                      NUMBER(22) NOT NULL,
  ZIP_CD                   CHAR(6) NOT NULL,
  SIDO_NM                  VARCHAR2(10),
  GUNGU_NM                 VARCHAR2(20),
  UPMYUN_NM                VARCHAR2(50),
  RI                       VARCHAR2(50),
  DOSEO                    VARCHAR2(10),
  BUNZI                    VARCHAR2(20),
  CTNT                     VARCHAR2(50),
  PRIMARY KEY ( SEQ, ZIP_CD )
  )
 TABLESPACE SAMPLE_STONE
 PCTFREE 10
 PCTUSED 40
 INITRANS 1
 MAXTRANS 255
 STORAGE (INITIAL 65536
   NEXT
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   PCTINCREASE
   FREELISTS 1
   FREELIST GROUPS 1);

COMMENT ON TABLE  TEST.DI_ZIPIFO IS '우편번호정보';
COMMENT ON COLUMN TEST.DI_ZIPIFO.SEQ IS '순번';
COMMENT ON COLUMN TEST.DI_ZIPIFO.ZIP_CD IS '우편번호';
COMMENT ON COLUMN TEST.DI_ZIPIFO.SIDO_NM IS '시도';
COMMENT ON COLUMN TEST.DI_ZIPIFO.GUNGU_NM IS '시군구';
COMMENT ON COLUMN TEST.DI_ZIPIFO.UPMYUN_NM IS '읍면동';
COMMENT ON COLUMN TEST.DI_ZIPIFO.RI IS '리';
COMMENT ON COLUMN TEST.DI_ZIPIFO.DOSEO IS '도서';
COMMENT ON COLUMN TEST.DI_ZIPIFO.BUNZI IS '번지';
COMMENT ON COLUMN TEST.DI_ZIPIFO.CTNT IS '내용';

728x90
반응형
블로그 이미지

nineDeveloper

안녕하세요 현직 개발자 입니다 ~ 빠르게 변화하는 세상에 뒤쳐지지 않도록 우리모두 열심히 공부합시다 ~! 개발공부는 넘나 재미있는 것~!

,