MySQL Create Table SQL
Table Structure: okayapi_openant_currency:/tablelist/okayapi_openant_currency.html
-- MySQL Table okayapi_openant_currency
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_currency` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`currency_id` int(11) NOT NULL COMMENT '',
`title` varchar(32) NOT NULL COMMENT '',
`okayapi_openant_currency_code` varchar(3) NOT NULL COMMENT '',
`symbol_left` varchar(12) NOT NULL COMMENT '',
`symbol_right` varchar(12) NOT NULL COMMENT '',
`decimal_place` char(1) NOT NULL COMMENT '',
`okayapi_openant_currency_value` float(15,8) NOT NULL COMMENT '',
`okayapi_openant_currency_status` tinyint(1) NOT NULL COMMENT '',
`date_modified` datetime NOT NULL COMMENT '',
KEY `currency_id` (`currency_id`),
KEY `title` (`title`),
KEY `okayapi_openant_currency_code` (`okayapi_openant_currency_code`),
KEY `symbol_left` (`symbol_left`),
KEY `symbol_right` (`symbol_right`),
KEY `decimal_place` (`decimal_place`),
KEY `okayapi_openant_currency_value` (`okayapi_openant_currency_value`),
KEY `okayapi_openant_currency_status` (`okayapi_openant_currency_status`),
KEY `date_modified` (`date_modified`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-货币';
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 |
---|---|---|---|---|---|---|
currency_id | int(11) | 否 | ||||
title | varchar(32) | 否 | ||||
okayapi_openant_currency_code | varchar(3) | 否 | ||||
symbol_left | varchar(12) | 否 | ||||
symbol_right | varchar(12) | 否 | ||||
decimal_place | char(1) | 否 | ||||
okayapi_openant_currency_value | float(15,8) | 否 | ||||
okayapi_openant_currency_status | tinyint(1) | 否 | ||||
date_modified | datetime | 否 |