+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_dberp_shop_order:/tablelist/okayapi_dberp_shop_order.html


-- MySQL Table okayapi_dberp_shop_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_shop_order` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `shop_order_sn` varchar(50) NOT NULL COMMENT '',
    `shop_buy_name` varchar(100) NOT NULL COMMENT '',
    `shop_payment_code` varchar(20) NOT NULL COMMENT '',
    `shop_payment_name` varchar(30) NOT NULL COMMENT '',
    `shop_payment_cost` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `shop_payment_certification` varchar(500) NOT NULL COMMENT '',
    `shop_express_code` varchar(30) NOT NULL COMMENT '',
    `shop_express_name` varchar(50) NOT NULL COMMENT '',
    `shop_express_cost` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `shop_order_other_cost` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `shop_order_other_info` varchar(500) NOT NULL COMMENT '',
    `shop_order_state` tinyint(2) NOT NULL DEFAULT '10' COMMENT '',
    `shop_order_discount_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `shop_order_discount_info` varchar(500) NOT NULL COMMENT '',
    `shop_order_goods_amount` decimal(19,4) NOT NULL COMMENT '',
    `shop_order_amount` decimal(19,4) NOT NULL COMMENT '',
    `shop_order_add_time` int(10) NOT NULL COMMENT '',
    `shop_order_pay_time` int(10) NOT NULL COMMENT '',
    `shop_order_express_time` int(10) NOT NULL COMMENT '',
    `shop_order_finish_time` int(10) NOT NULL COMMENT '',
    `shop_order_message` varchar(500) NOT NULL COMMENT '',
    `app_id` int(11) NOT NULL COMMENT '',
    KEY `shop_order_sn` (`shop_order_sn`),
    KEY `shop_buy_name` (`shop_buy_name`),
    KEY `shop_payment_code` (`shop_payment_code`),
    KEY `shop_payment_name` (`shop_payment_name`),
    KEY `shop_payment_cost` (`shop_payment_cost`),
    KEY `shop_payment_certification` (`shop_payment_certification`),
    KEY `shop_express_code` (`shop_express_code`),
    KEY `shop_express_name` (`shop_express_name`),
    KEY `shop_express_cost` (`shop_express_cost`),
    KEY `shop_order_other_cost` (`shop_order_other_cost`),
    KEY `shop_order_other_info` (`shop_order_other_info`),
    KEY `shop_order_state` (`shop_order_state`),
    KEY `shop_order_discount_amount` (`shop_order_discount_amount`),
    KEY `shop_order_discount_info` (`shop_order_discount_info`),
    KEY `shop_order_goods_amount` (`shop_order_goods_amount`),
    KEY `shop_order_amount` (`shop_order_amount`),
    KEY `shop_order_add_time` (`shop_order_add_time`),
    KEY `shop_order_pay_time` (`shop_order_pay_time`),
    KEY `shop_order_express_time` (`shop_order_express_time`),
    KEY `shop_order_finish_time` (`shop_order_finish_time`),
    KEY `shop_order_message` (`shop_order_message`),
    KEY `app_id` (`app_id`),
    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-22 of 22 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
shop_order_snvarchar(50)
shop_buy_namevarchar(100)
shop_payment_codevarchar(20)
shop_payment_namevarchar(30)
shop_payment_costdecimal(19,4)0.00000.0000
shop_payment_certificationvarchar(500)
shop_express_codevarchar(30)
shop_express_namevarchar(50)
shop_express_costdecimal(19,4)0.00000.0000
shop_order_other_costdecimal(19,4)0.00000.0000
shop_order_other_infovarchar(500)
shop_order_statetinyint(2)1010
shop_order_discount_amountdecimal(19,4)0.00000.0000
shop_order_discount_infovarchar(500)
shop_order_goods_amountdecimal(19,4)
shop_order_amountdecimal(19,4)
shop_order_add_timeint(10)
shop_order_pay_timeint(10)
shop_order_express_timeint(10)
shop_order_finish_timeint(10)
shop_order_messagevarchar(500)
app_idint(11)

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_smpss_tempsales

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

TOP ↑