Database design of simple voting system

Introduce

Database design of simple voting system . If you find any mistakes in the design, please point them out in the comment area , thank you ！

One 、 Screenshot

Project table

List of options

The ballot form

Two 、 Code

Ticket list

CREATE TABLE `as_ticket` (
  `id` varchar(64) NOT NULL COMMENT ' Primary key ',
  `title` varchar(100) DEFAULT NULL COMMENT ' The title of the vote ',
  `description` text COMMENT ' describe ',
  `rate` int(11) DEFAULT '1' COMMENT ' Number of votes per person per day ：-1 Means unlimited ',
  `multi` int(11) NOT NULL DEFAULT '0' COMMENT ' Support multiple choices ：1 Support 、0 I won't support it ',
  `min` int(11) NOT NULL DEFAULT '1' COMMENT ' In multi-select mode ： Minimum number of choices , Default ：1 individual ',
  `max` int(11) NOT NULL DEFAULT '4' COMMENT ' In multi-select mode ： Maximum number of choices , Default ： unlimited ',
  `anonymous` int(11) NOT NULL DEFAULT '1' COMMENT '1： anonymous 、0： Not anonymous ',
  `img_url` varchar(255) DEFAULT NULL COMMENT ' Picture address ',
  `create_by` varchar(255) DEFAULT NULL COMMENT ' The creator ',
  `remark` varchar(255) DEFAULT NULL COMMENT ' remarks ',
  `update_by` varchar(255) DEFAULT NULL COMMENT ' Reviser ',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ' Update time ',
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ' Start date ',
  `end_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ' Closing date ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ' Creation time ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Ticket option table

CREATE TABLE `as_ticket_option` (
  `id` varchar(64) NOT NULL COMMENT ' Primary key ',
  `vote_id` varchar(64) DEFAULT NULL COMMENT ' The ticket belongs to ID',
  `name` varchar(100) DEFAULT NULL COMMENT ' Option name ',
  `description` text COMMENT ' describe ',
  `img_url` varchar(255) DEFAULT NULL COMMENT ' Picture address ',
  `num` int(11) DEFAULT NULL COMMENT ' Number of people voted ',
  `update_by` varchar(255) DEFAULT NULL COMMENT ' Update time ',
  `create_by` varchar(255) DEFAULT NULL COMMENT ' The creator ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ' Creation time ',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ' Update time ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

The ballot form

CREATE TABLE `as_vote` (
  `id` varchar(64) NOT NULL COMMENT ' Voted ID',
  `username` varchar(64) DEFAULT NULL COMMENT ' Voters ： user name 、IP Address 、 Unknown ',
  `option_id` varchar(64) DEFAULT NULL COMMENT ' The options cast ',
  `vote_id` varchar(64) DEFAULT NULL COMMENT ' The votes cast ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;