MySQL Create Table SQL
Table Structure: okayapi_dberp_customer:/tablelist/okayapi_dberp_customer.html
-- MySQL Table okayapi_dberp_customer
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_customer` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`customer_category_id` int(11) NOT NULL COMMENT '',
`customer_code` varchar(30) NOT NULL COMMENT '',
`customer_name` varchar(100) NOT NULL COMMENT '',
`customer_sort` int(11) NOT NULL DEFAULT '255' COMMENT '',
`customer_email` varchar(30) NOT NULL COMMENT '',
`customer_address` varchar(255) NOT NULL COMMENT '',
`customer_contacts` varchar(30) NOT NULL COMMENT '',
`customer_phone` varchar(20) NOT NULL COMMENT '',
`customer_telephone` varchar(20) NOT NULL COMMENT '',
`customer_bank` varchar(100) NOT NULL COMMENT '',
`customer_bank_account` varchar(30) NOT NULL COMMENT '',
`customer_tax` varchar(30) NOT NULL COMMENT '',
`customer_info` varchar(255) NOT NULL COMMENT '',
`admin_id` int(11) NOT NULL COMMENT '',
`region_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
`region_values` varchar(100) NOT NULL COMMENT '',
KEY `customer_category_id` (`customer_category_id`),
KEY `customer_code` (`customer_code`),
KEY `customer_name` (`customer_name`),
KEY `customer_sort` (`customer_sort`),
KEY `customer_email` (`customer_email`),
KEY `customer_address` (`customer_address`),
KEY `customer_contacts` (`customer_contacts`),
KEY `customer_phone` (`customer_phone`),
KEY `customer_telephone` (`customer_telephone`),
KEY `customer_bank` (`customer_bank`),
KEY `customer_bank_account` (`customer_bank_account`),
KEY `customer_tax` (`customer_tax`),
KEY `customer_info` (`customer_info`),
KEY `admin_id` (`admin_id`),
KEY `region_id` (`region_id`),
KEY `region_values` (`region_values`),
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-16 of 16 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
customer_category_id | int(11) | 否 | ||||
customer_code | varchar(30) | 否 | ||||
customer_name | varchar(100) | 否 | ||||
customer_sort | int(11) | 255 | 否 | 255 | ||
customer_email | varchar(30) | 是 | ||||
customer_address | varchar(255) | 是 | ||||
customer_contacts | varchar(30) | 是 | ||||
customer_phone | varchar(20) | 是 | ||||
customer_telephone | varchar(20) | 是 | ||||
customer_bank | varchar(100) | 是 | ||||
customer_bank_account | varchar(30) | 是 | ||||
customer_tax | varchar(30) | 是 | ||||
customer_info | varchar(255) | 是 | ||||
admin_id | int(11) | 否 | ||||
region_id | int(11) | 0 | 否 | 0 | ||
region_values | varchar(100) | 否 |