MySQL Create Table SQL
Table Structure: okayapi_smpss_tempsales:/tablelist/okayapi_smpss_tempsales.html
-- MySQL Table okayapi_smpss_tempsales
-- From: OkayAPI.com
CREATE TABLE `okayapi_smpss_tempsales` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`order_id` varchar(14) NOT NULL COMMENT '',
`goods_id` int(10) NOT NULL COMMENT '',
`goods_name` varchar(100) NOT NULL COMMENT '',
`goods_sn` varchar(16) NOT NULL COMMENT '',
`stock` int(10) NOT NULL COMMENT '',
`cat_id` int(10) NOT NULL COMMENT '',
`out_price` float(10,2) unsigned NOT NULL COMMENT '',
`p_discount` float(10,2) unsigned NOT NULL COMMENT '',
`ismemberprice` tinyint(1) NOT NULL COMMENT '',
`ispromote` tinyint(1) NOT NULL COMMENT '',
`promote_price` float(8,2) unsigned NOT NULL COMMENT '',
`num` float(10,2) unsigned NOT NULL COMMENT '',
`dateline` int(10) NOT NULL COMMENT '',
KEY `order_id` (`order_id`),
KEY `goods_id` (`goods_id`),
KEY `goods_name` (`goods_name`),
KEY `goods_sn` (`goods_sn`),
KEY `stock` (`stock`),
KEY `cat_id` (`cat_id`),
KEY `out_price` (`out_price`),
KEY `p_discount` (`p_discount`),
KEY `ismemberprice` (`ismemberprice`),
KEY `ispromote` (`ispromote`),
KEY `promote_price` (`promote_price`),
KEY `num` (`num`),
KEY `dateline` (`dateline`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '进销存-销售临时表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-13 of 13 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
order_id | varchar(14) | 否 | ||||
goods_id | int(10) | 否 | ||||
goods_name | varchar(100) | 否 | ||||
goods_sn | varchar(16) | 否 | ||||
stock | int(10) | 否 | ||||
cat_id | int(10) | 否 | ||||
out_price | float(10,2) unsigned | 否 | ||||
p_discount | float(10,2) unsigned | 否 | ||||
ismemberprice | tinyint(1) | 否 | ||||
ispromote | tinyint(1) | 否 | ||||
promote_price | float(8,2) unsigned | 否 | ||||
num | float(10,2) unsigned | 否 | ||||
dateline | int(10) | 否 |