테이블 목록 확인하기

sql> SHOW TABLES;

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
);

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