MySQL Create Table SQL
Table Structure: okayapi_pinot_data_completeness_config_index:/tablelist/okayapi_pinot_data_completeness_config_index.html
-- MySQL Table okayapi_pinot_data_completeness_config_index
-- From: OkayAPI.com
CREATE TABLE `okayapi_pinot_data_completeness_config_index` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dataset` varchar(200) NULL COMMENT '',
`date_to_check_in_ms` bigint(20) NULL COMMENT '',
`date_to_check_in_sdf` varchar(20) NULL COMMENT '',
`data_complete` tinyint(1) NULL COMMENT '',
`percent_complete` double NULL COMMENT '',
`base_id` bigint(20) NULL COMMENT '',
`version` int(10) NULL COMMENT '',
KEY `dataset` (`dataset`),
KEY `date_to_check_in_ms` (`date_to_check_in_ms`),
KEY `date_to_check_in_sdf` (`date_to_check_in_sdf`),
KEY `data_complete` (`data_complete`),
KEY `percent_complete` (`percent_complete`),
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-7 of 7 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
dataset | varchar(200) | 否 | ||||
date_to_check_in_ms | bigint(20) | 否 | ||||
date_to_check_in_sdf | varchar(20) | 是 | ||||
data_complete | tinyint(1) | 是 | ||||
percent_complete | double | 是 | ||||
base_id | bigint(20) | 否 | ||||
version | int(10) | 是 |