create table CJ_T_ATTACHMENT1
(
ID VARCHAR2(50) not null,
FILENAME VARCHAR2(50),
FILETYPE VARCHAR2(100),
FILESIZE NUMBER(18),
CONTENT BLOB,
STATUS NUMBER(1),
REMARK VARCHAR2(500),
REFID VARCHAR2(50),
TYPE VARCHAR2(50),
INUSERID VARCHAR2(50),
INDATE DATE default SYSDATE,
RS NUMBER(1) default 1,
TS VARCHAR2(30) default TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6'),
constraint PK_CJ_T_ATTACHMENT1 primary key (ID)
)LOB(CONTENT) STORE AS SECUREFILE
(COMPRESS DEDUPLICATE CACHE NOLOGGING)