ejyoo's 개발 노트

[Oracle] SqlDeveloper에서 쿼리 가져올 때 변경해야할 것 본문

DB/Oracle

[Oracle] SqlDeveloper에서 쿼리 가져올 때 변경해야할 것

ejyoovV 2021. 6. 8. 09:03
  CREATE TABLE "DB계정(예:JSP)"."QNA" 
   (	"QNO" NUMBER NOT NULL ENABLE, 
	"QTYPE" VARCHAR2(30 BYTE), 
	"TITLE" VARCHAR2(300 BYTE) NOT NULL ENABLE, 
	"WRITER" VARCHAR2(50 BYTE) NOT NULL ENABLE, 
	"CONTENT" VARCHAR2(3200 BYTE) NOT NULL ENABLE, 
	"PICTURE" VARCHAR2(200 BYTE), 
	"REGDATE" DATE, 
	"VIEWCNT" NUMBER DEFAULT 0, 
	"ISANSWER" VARCHAR2(2 BYTE) DEFAULT 'N', 
	"ISDEL" VARCHAR2(2 BYTE) DEFAULT 'N', 
	 PRIMARY KEY ("QNO")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM계정"  ENABLE, 
	 FOREIGN KEY ("WRITER")
	  REFERENCES "DB계정(예:JSP)"."MEMBER" ("ID") ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM계정" ;

   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."QNO" IS '게시글번호';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."QTYPE" IS '문의분류';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."TITLE" IS '제목';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."WRITER" IS '작성자';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."CONTENT" IS '내용';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."PICTURE" IS '첨부사진';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."REGDATE" IS '작성일';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."VIEWCNT" IS '조회수';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."ISANSWER" IS '답변여부';
   COMMENT ON COLUMN "DB계정(예:JSP)"."QNA"."ISDEL" IS '삭제여부';