zjrs-jeecgBoot/.docs/sql/建表语句/视频帮办.sql

CREATE TABLE "SPBB_FEEDBACK"
(
"ID" VARCHAR(36) NOT NULL,
"VIDEO_DATA_ID" VARCHAR(50),
"FEEDBACK_TYPE" VARCHAR(32),
"VIDEO_CATEGORY" VARCHAR(32),
"FEEDBACK_CONTENT" VARCHAR(500),
"CONTACT_INFO" VARCHAR(50),
"CREATE_BY" VARCHAR(50),
"CREATE_TIME" DATETIME(6),
"UPDATE_BY" VARCHAR(50),
"UPDATE_TIME" DATETIME(6),
"SYS_ORG_CODE" VARCHAR(64),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "SPPB_FAVORITE"
(
"ID" VARCHAR(36) NOT NULL,
"VIDEO_ID" VARCHAR(36),
"USER_ID" VARCHAR(50),
"USER_SOURCE" VARCHAR(32),
"FAVORITE_TIME" DATETIME(6),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

COMMENT ON TABLE "SPPB_FAVORITE" IS '视频帮办-收藏表';
COMMENT ON COLUMN "SPPB_FAVORITE"."ID" IS '主键ID';
COMMENT ON COLUMN "SPPB_FAVORITE"."VIDEO_ID" IS '视频ID';
COMMENT ON COLUMN "SPPB_FAVORITE"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "SPPB_FAVORITE"."USER_SOURCE" IS '用户来源';
COMMENT ON COLUMN "SPPB_FAVORITE"."FAVORITE_TIME" IS '收藏时间';

CREATE TABLE "SPPB_VIDEO"
(
"ID" VARCHAR(36) NOT NULL,
"TITLE" VARCHAR(100),
"COVER" VARCHAR(255),
"VIDEO_FILE" VARCHAR(500),
"FORMAT" VARCHAR(20),
"FILE_SIZE" VARCHAR(100),
"DURATION" VARCHAR(50),
"DATA_ID" VARCHAR(100),
"DATA_NAME" VARCHAR(100),
"STEP_SUMMARY" VARCHAR(500),
"CONTENT_DESC" VARCHAR(500),
"RECORDING_TIME" DATETIME(6),
"VIDEO_UPDATE_TIME" DATETIME(6),
"STATE" NUMERIC(1,0),
"BUSINESS_CATEGORY" NUMERIC(1,0),
"KEYWORD" VARCHAR(255),
"TARGET_AUDIENCE" VARCHAR(32),
"PLAY_COUNT" NUMERIC(10,0),
"FAVORITE_COUNT" NUMERIC(10,0),
"PLAY_COMPLETION_RATE" VARCHAR(100),
"REMARK" VARCHAR(255),
"CREATE_BY" VARCHAR(50),
"CREATE_TIME" DATETIME(6),
"UPDATE_BY" VARCHAR(50),
"UPDATE_TIME" DATETIME(6),
"SYS_ORG_CODE" VARCHAR(64),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;