MySQL Create Table SQL
Table Structure: okayapi_dberp_shop_order_delivery_address:/tablelist/okayapi_dberp_shop_order_delivery_address.html
-- MySQL Table okayapi_dberp_shop_order_delivery_address
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_shop_order_delivery_address` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`delivery_name` varchar(100) NOT NULL COMMENT '',
`region_info` varchar(50) NOT NULL COMMENT '',
`region_address` varchar(300) NOT NULL COMMENT '',
`zip_code` varchar(10) NOT NULL COMMENT '',
`delivery_phone` varchar(20) NOT NULL COMMENT '',
`delivery_telephone` varchar(20) NOT NULL COMMENT '',
`delivery_number` varchar(30) NOT NULL COMMENT '',
`delivery_info` varchar(500) NOT NULL COMMENT '',
`shop_order_id` int(11) NOT NULL COMMENT '',
KEY `delivery_name` (`delivery_name`),
KEY `region_info` (`region_info`),
KEY `region_address` (`region_address`),
KEY `zip_code` (`zip_code`),
KEY `delivery_phone` (`delivery_phone`),
KEY `delivery_telephone` (`delivery_telephone`),
KEY `delivery_number` (`delivery_number`),
KEY `delivery_info` (`delivery_info`),
KEY `shop_order_id` (`shop_order_id`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'DBErp进销存-商城订单配送地址';
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 |
---|---|---|---|---|---|---|
delivery_name | varchar(100) | 否 | ||||
region_info | varchar(50) | 是 | ||||
region_address | varchar(300) | 否 | ||||
zip_code | varchar(10) | 是 | ||||
delivery_phone | varchar(20) | 否 | ||||
delivery_telephone | varchar(20) | 是 | ||||
delivery_number | varchar(30) | 是 | ||||
delivery_info | varchar(500) | 是 | ||||
shop_order_id | int(11) | 否 |