MySQL Create Table SQL
Table Structure: okayapi_admanage_targetuser:/tablelist/okayapi_admanage_targetuser.html
-- MySQL Table okayapi_admanage_targetuser
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_targetuser` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`TargetUser` varchar(10) NOT NULL COMMENT '目标用户群ID',
`TargetUserName` varchar(15) NOT NULL COMMENT '目标用户群名称',
`route` varchar(30) NOT NULL COMMENT '',
KEY `TargetUser` (`TargetUser`),
KEY `TargetUserName` (`TargetUserName`),
KEY `route` (`route`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '广告管理-用户群表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
TargetUser | varchar(10) | 否 | 目标用户群ID | |||
TargetUserName | varchar(15) | 否 | 目标用户群名称 | |||
route | varchar(30) | 否 |