+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
order_idvarchar(14)
goods_idint(10)
goods_namevarchar(100)
goods_snvarchar(16)
stockint(10)
cat_idint(10)
out_pricefloat(10,2) unsigned
p_discountfloat(10,2) unsigned
ismemberpricetinyint(1)
ispromotetinyint(1)
promote_pricefloat(8,2) unsigned
numfloat(10,2) unsigned
datelineint(10)

Guess You Like

MySQL Table Design okayapi_smpss_admin

MySQL Table Design okayapi_smpss_category

MySQL Table Design okayapi_smpss_goods

MySQL Table Design okayapi_smpss_group

MySQL Table Design okayapi_smpss_log

MySQL Table Design okayapi_smpss_mbgroup

MySQL Table Design okayapi_smpss_member

MySQL Table Design okayapi_smpss_purchase

MySQL Table Design okayapi_smpss_region

MySQL Table Design okayapi_smpss_sales

MySQL Table Design okayapi_smpss_system

MySQL Table Design okayapi_dberp_accounts_receivable

MySQL Table Design okayapi_dberp_accounts_receivable_log

MySQL Table Design okayapi_dberp_admin

MySQL Table Design okayapi_dberp_admin_group

MySQL Table Design okayapi_dberp_app

MySQL Table Design okayapi_dberp_brand

MySQL Table Design okayapi_dberp_customer

MySQL Table Design okayapi_dberp_customer_category

MySQL Table Design okayapi_dberp_finance_payable

TOP ↑