MySQL Create Table SQL
Table Structure: okayapi_dberp_supplier:/tablelist/okayapi_dberp_supplier.html
-- MySQL Table okayapi_dberp_supplier
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_supplier` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`supplier_category_id` int(11) NOT NULL COMMENT '',
`supplier_code` varchar(30) NOT NULL COMMENT '',
`supplier_name` varchar(100) NOT NULL COMMENT '',
`supplier_sort` int(11) NOT NULL DEFAULT '255' COMMENT '',
`supplier_address` varchar(255) NOT NULL COMMENT '',
`supplier_contacts` varchar(30) NOT NULL COMMENT '',
`supplier_phone` varchar(20) NOT NULL COMMENT '',
`supplier_telephone` varchar(20) NOT NULL COMMENT '',
`supplier_bank` varchar(100) NOT NULL COMMENT '',
`supplier_bank_account` varchar(30) NOT NULL COMMENT '',
`supplier_tax` varchar(30) NOT NULL COMMENT '',
`supplier_email` varchar(30) NOT NULL COMMENT '',
`supplier_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 `supplier_category_id` (`supplier_category_id`),
KEY `supplier_code` (`supplier_code`),
KEY `supplier_name` (`supplier_name`),
KEY `supplier_sort` (`supplier_sort`),
KEY `supplier_address` (`supplier_address`),
KEY `supplier_contacts` (`supplier_contacts`),
KEY `supplier_phone` (`supplier_phone`),
KEY `supplier_telephone` (`supplier_telephone`),
KEY `supplier_bank` (`supplier_bank`),
KEY `supplier_bank_account` (`supplier_bank_account`),
KEY `supplier_tax` (`supplier_tax`),
KEY `supplier_email` (`supplier_email`),
KEY `supplier_info` (`supplier_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 |
---|---|---|---|---|---|---|
supplier_category_id | int(11) | 否 | ||||
supplier_code | varchar(30) | 否 | ||||
supplier_name | varchar(100) | 否 | ||||
supplier_sort | int(11) | 255 | 否 | 255 | ||
supplier_address | varchar(255) | 是 | ||||
supplier_contacts | varchar(30) | 是 | ||||
supplier_phone | varchar(20) | 是 | ||||
supplier_telephone | varchar(20) | 是 | ||||
supplier_bank | varchar(100) | 是 | ||||
supplier_bank_account | varchar(30) | 是 | ||||
supplier_tax | varchar(30) | 是 | ||||
supplier_email | varchar(30) | 是 | ||||
supplier_info | varchar(255) | 是 | ||||
admin_id | int(11) | 否 | ||||
region_id | int(11) | 0 | 否 | 0 | ||
region_values | varchar(100) | 否 |