okayapi_jeewms_jform_order_customer - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_order_customer：/tablelist/okayapi_jeewms_jform_order_customer.html


-- MySQL Table okayapi_jeewms_jform_order_customer
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_order_customer` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_jeewms_jform_order_customer_name` varchar(32) NOT NULL COMMENT '客户名',
    `money` double NOT NULL COMMENT '单价',
    `sex` varchar(4) NOT NULL COMMENT '性别',
    `telphone` varchar(32) NOT NULL COMMENT '电话',
    `fk_id` varchar(36) NOT NULL COMMENT '外键',
    KEY `okayapi_jeewms_jform_order_customer_name` (`okayapi_jeewms_jform_order_customer_name`),
    KEY `money` (`money`),
    KEY `sex` (`sex`),
    KEY `telphone` (`telphone`),
    KEY `fk_id` (`fk_id`),
    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-5 of 5 results.

Field Name	Field Type	IS NULL	Field Comment
okayapi_jeewms_jform_order_customer_name	varchar(32)	否	客户名
money	double	是	单价
sex	varchar(4)	否	性别
telphone	varchar(32)	是	电话
fk_id	varchar(36)	否	外键