okayapi_openant_tax_rate - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_tax_rate：/tablelist/okayapi_openant_tax_rate.html


-- MySQL Table okayapi_openant_tax_rate
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_tax_rate` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `tax_rate_id` int(11) NOT NULL COMMENT '',
    `geo_zone_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `rate` decimal(15,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `okayapi_openant_tax_rate_type` char(1) NOT NULL COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    `date_modified` datetime NOT NULL COMMENT '',
    KEY `tax_rate_id` (`tax_rate_id`),
    KEY `geo_zone_id` (`geo_zone_id`),
    KEY `rate` (`rate`),
    KEY `okayapi_openant_tax_rate_type` (`okayapi_openant_tax_rate_type`),
    KEY `date_added` (`date_added`),
    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-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Demo Data
tax_rate_id	int(11)		否
geo_zone_id	int(11)	0	否	0
rate	decimal(15,4)	0.0000	否	0.0000
okayapi_openant_tax_rate_type	char(1)		否
date_added	datetime		否
date_modified	datetime		否