MySQL Create Table SQL
Table Structure: okayapi_pinot_entity_to_entity_mapping_index:/tablelist/okayapi_pinot_entity_to_entity_mapping_index.html
-- MySQL Table okayapi_pinot_entity_to_entity_mapping_index
-- From: OkayAPI.com
CREATE TABLE `okayapi_pinot_entity_to_entity_mapping_index` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`from_urn` varchar(500) NULL COMMENT '',
`to_urn` varchar(500) NULL COMMENT '',
`mapping_type` varchar(500) NULL COMMENT '',
`base_id` bigint(20) NULL COMMENT '',
`version` int(10) NULL COMMENT '',
KEY `from_urn` (`from_urn`),
KEY `to_urn` (`to_urn`),
KEY `mapping_type` (`mapping_type`),
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-5 of 5 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
from_urn | varchar(500) | 否 | ||||
to_urn | varchar(500) | 否 | ||||
mapping_type | varchar(500) | 否 | ||||
base_id | bigint(20) | 否 | ||||
version | int(10) | 是 |