MySQL Create Table SQL
Table Structure: okayapi_dberp_region：/tablelist/okayapi_dberp_region.html
-- MySQL Table okayapi_dberp_region
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_region` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`region_name` varchar(50) NULL COMMENT '',
`region_top_id` int(11) NULL DEFAULT '0' COMMENT '',
`region_sort` int(11) NULL DEFAULT '255' COMMENT '',
`region_path` varchar(100) NULL COMMENT '',
KEY `region_name` (`region_name`),
KEY `region_top_id` (`region_top_id`),
KEY `region_sort` (`region_sort`),
KEY `region_path` (`region_path`),
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-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| region_name | varchar(50) | 否 | ||||
| region_top_id | int(11) | 0 | 否 | 0 | ||
| region_sort | int(11) | 255 | 否 | 255 | ||
| region_path | varchar(100) | 是 |
