MySQL Create Table SQL
Table Structure: okayapi_pinot_task_index:/tablelist/okayapi_pinot_task_index.html
-- MySQL Table okayapi_pinot_task_index
-- From: OkayAPI.com
CREATE TABLE `okayapi_pinot_task_index` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) NULL COMMENT '',
`status` varchar(100) NULL COMMENT '',
`type` varchar(100) NULL COMMENT '',
`start_time` bigint(20) NULL COMMENT '',
`end_time` bigint(20) NULL COMMENT '',
`job_id` bigint(20) NULL COMMENT '',
`worker_id` bigint(20) NULL COMMENT '',
`base_id` bigint(20) NULL COMMENT '',
`version` int(10) NULL COMMENT '',
KEY `name` (`name`),
KEY `status` (`status`),
KEY `type` (`type`),
KEY `start_time` (`start_time`),
KEY `end_time` (`end_time`),
KEY `job_id` (`job_id`),
KEY `worker_id` (`worker_id`),
KEY `base_id` (`base_id`),
KEY `version` (`version`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'OLAP存储分析-任务';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-9 of 9 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(200) | 否 | ||||
status | varchar(100) | 否 | ||||
type | varchar(100) | 否 | ||||
start_time | bigint(20) | 否 | ||||
end_time | bigint(20) | 否 | ||||
job_id | bigint(20) | 是 | ||||
worker_id | bigint(20) | 是 | ||||
base_id | bigint(20) | 否 | ||||
version | int(10) | 是 |