Development of SpringBoot Video and Video Program Imitating Tremble

I. Project Introduction

Simulating the dithering of a short video micro-messaging program, using SpringBoot to build a small program background, using SSM framework to build a short video background management system, small program background through distributed zookeeper monitoring nodes automatically download or delete short video background management system uploaded video.

Environmental parameters

  1. Core Framework: SpringBoot, SSM
  2. Database: MySQL, HikariCP Data Source, MyBatis Reverse Engineering
  3. Middleware: zookeeper, redis, swagger2
  4. Front-end framework: Bootstrap + Jquery, jqGrid paging component
  5. Audio processing: FFmpeg
  6. Development tools: IDEA

Popular Technology Points

III. Project demonstration

Functions: Small programs [Registration, Log-in and Log-out], [Upload Head Image], [Upload Works], [View All/Single Short Video], [Tip Zan], [Focus on a User], [Short Video and BGM Merge], [Message Comment Reply], [Reporting], [Download Short Video to Mobile Phone]

IV. Database Design

CREATE TABLE `bgm` (
  `id` varchar(64) NOT NULL,
  `author` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL COMMENT 'Playback address',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `comments` (
  `id` varchar(20) NOT NULL,
  `father_comment_id` varchar(20) DEFAULT NULL,
  `to_user_id` varchar(20) DEFAULT NULL,
  `video_id` varchar(20) NOT NULL COMMENT 'video id',
  `from_user_id` varchar(20) NOT NULL COMMENT 'Messager, User of Comment id',
  `comment` text NOT NULL COMMENT 'Comment content',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Course review form';

CREATE TABLE `search_records` (
  `id` varchar(64) NOT NULL,
  `content` varchar(255) NOT NULL COMMENT 'Contents of the search',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Video Search Record Table';

CREATE TABLE `vuser` (
  `id` varchar(64) NOT NULL,
  `username` varchar(20) NOT NULL COMMENT 'User name',
  `password` varchar(64) NOT NULL COMMENT 'Password',
  `face_image` varchar(255) DEFAULT NULL COMMENT 'My avatar, if not by default',
  `nickname` varchar(20) NOT NULL COMMENT 'Nickname?',
  `fans_counts` int(11) DEFAULT '0' COMMENT 'Number of my fans',
  `follow_counts` int(11) DEFAULT '0' COMMENT 'The total number of people I care about',
  `receive_like_counts` int(11) DEFAULT '0' COMMENT 'The compliments I received/Number of collections',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `users_fans` (
  `id` varchar(64) NOT NULL,
  `user_id` varchar(64) NOT NULL COMMENT 'user',
  `fan_id` varchar(64) NOT NULL COMMENT 'Fans',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`fan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='User Fan Association Table';

CREATE TABLE `users_like_videos` (
  `id` varchar(64) NOT NULL,
  `user_id` varchar(64) NOT NULL COMMENT 'user',
  `video_id` varchar(64) NOT NULL COMMENT 'video',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_video_rel` (`user_id`,`video_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='User's favorite/Supported videos';

CREATE TABLE `users_report` (
  `id` varchar(64) NOT NULL,
  `deal_user_id` varchar(64) NOT NULL COMMENT 'Reported users id',
  `deal_video_id` varchar(64) NOT NULL,
  `title` varchar(128) NOT NULL COMMENT 'Type headings, for user selection, see enumeration for details',
  `content` varchar(255) DEFAULT NULL COMMENT 'content',
  `userid` varchar(64) NOT NULL COMMENT 'Informant id',
  `create_date` datetime NOT NULL COMMENT 'Reporting time',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Reporting User List';

CREATE TABLE `videos` (
  `id` varchar(64) NOT NULL,
  `user_id` varchar(64) NOT NULL COMMENT 'Publisher id',
  `audio_id` varchar(64) DEFAULT NULL COMMENT 'User's Use of Audio Information',
  `video_desc` varchar(128) DEFAULT NULL COMMENT 'Video description',
  `video_path` varchar(255) NOT NULL COMMENT 'Video Storage Path',
  `video_seconds` float(6,2) DEFAULT NULL COMMENT 'Video seconds',
  `video_width` int(6) DEFAULT NULL COMMENT 'Video width',
  `video_height` int(6) DEFAULT NULL COMMENT 'Video height',
  `cover_path` varchar(255) DEFAULT NULL COMMENT 'Video Cover Map',
  `like_counts` bigint(20) NOT NULL DEFAULT '0' COMMENT 'like/Number of compliments',
  `status` int(1) NOT NULL COMMENT 'Video status:\r\n1,Released successfully\r\n2,No playback, administrator operation',
  `create_time` datetime NOT NULL COMMENT 'Creation time',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Video Information Table';

Tags: MySQL SpringBoot Zookeeper Database

Posted on Mon, 08 Apr 2019 04:09:31 -0400 by Beans