테이블 목록 확인하기

sql> SHOW TABLES;

컬럼 목록 확인하기

sql> SHOW COLUMNS FROM T_LOG_SYSTEM;

Related

CREATE TABLE PUBLIC.TB_RELATED (
	ID INTEGER NOT NULL,
	MORPH VARCHAR(200),
	KEYWORD VARCHAR(512),
	DISPLAY_KEYWORD VARCHAR(255),
	DISPLAY_EXCEPT_KEYWORD VARCHAR(255),
	EXCEPT_KEYWORD VARCHAR(100),
	ONLY_DISPLAY_KEYWORD VARCHAR(255),
	USE_YN CHAR(1),
	ADD_KEYWORD VARCHAR(255)
);

Youtube

CREATE CACHED TABLE PUBLIC.TB_YOUTUBE
(
    VIDEOID VARCHAR(64) NOT NULL,
    VIDEOTITLE VARCHAR(512),
    VIDEODESCRIPTION TEXT,
    THUMBNAIL VARCHAR(512),
    NOTE VARCHAR(1024),
    LINK VARCHAR(512),
    CHANNELID VARCHAR(64),
    PUBLISHEDAT VARCHAR(64)
);

Facebook

CREATE TABLE PUBLIC.TB_FACEBOOK (
	ID VARCHAR(64) NOT NULL,
	FROMNAME VARCHAR(64) DEFAULT NULL,
	FROMCATEGORY VARCHAR(64) DEFAULT NULL,
	FROMID VARCHAR(64) DEFAULT NULL,
	MESSAGE CLOB,
	PICTURE VARCHAR(2048),
	LINK VARCHAR(512) DEFAULT NULL,
	NAME VARCHAR(255) DEFAULT NULL,
	"TYPE" VARCHAR(64) DEFAULT NULL,
	OBJECTID VARCHAR(64) DEFAULT NULL,
	APPLICATIONNAME VARCHAR(64) DEFAULT NULL,
	APPLICATIONID VARCHAR(64) DEFAULT NULL,
	CREATEDTIME VARCHAR(64) DEFAULT NULL,
	UPDATEDTIME VARCHAR(64) DEFAULT NULL
);

Twitter

CREATE TABLE PUBLIC.TB_TWITTER (
	ID VARCHAR(64) NOT NULL,
	TEXT VARCHAR(255) DEFAULT NULL,
	CREATED_AT VARCHAR(64) DEFAULT NULL,
	"SOURCE" VARCHAR(64) DEFAULT NULL,
	USERID VARCHAR(64) DEFAULT NULL,
	USERSCREENNAME VARCHAR(64) DEFAULT NULL,
	USERNAME VARCHAR(64) DEFAULT NULL,
	USERURL VARCHAR(255) DEFAULT NULL,
	USERLOCATION VARCHAR(64) DEFAULT NULL,
	USERPROFILEIMAGEURL VARCHAR(255) DEFAULT NULL,
	USERSTATUSESCOUNT VARCHAR(11) DEFAULT NULL
);

컬럼 크기 변경(TOTAL_SIZE, USED_SIZE, NAME)

ALTER TABLE T_LOG_SYSTEM ALTER COLUMN TOTAL_SIZE VARCHAR(32) NOT NULL;
ALTER TABLE T_LOG_SYSTEM ALTER COLUMN USED_SIZE VARCHAR(32) NOT NULL;
ALTER TABLE T_LOG_SYSTEM ALTER COLUMN NAME VARCHAR(64);

컬럼 추가(INFLOW)

ALTER TABLE T_ADDON_TOPKEYWORD ADD COLUMN INFLOW VARCHAR(64) DEFAULT '';
UPDATE T_ADDON_TOPKEYWORD SET INFLOW='inflow' WHERE INFLOW IS NULL;
 
ALTER TABLE T_ADDON_TOPKEYWORD_EXCEPT ADD COLUMN INFLOW VARCHAR(64) DEFAULT '';
UPDATE T_ADDON_TOPKEYWORD_EXCEPT SET INFLOW='inflow' WHERE INFLOW IS NULL;

H2 실행 및 설정방법 (할당된 사용자 김토피아. 마감일 2020-02-10)