+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jsh_depot:/tablelist/okayapi_jsh_depot.html


-- MySQL Table okayapi_jsh_depot
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_depot` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(20) NULL COMMENT '仓库名称',
    `address` varchar(50) NULL COMMENT '仓库地址',
    `warehousing` decimal(24,6) NULL COMMENT '仓储费',
    `truckage` decimal(24,6) NULL COMMENT '搬运费',
    `type` int(10) NULL COMMENT '类型',
    `sort` varchar(10) NULL COMMENT '排序',
    `remark` varchar(100) NULL COMMENT '描述',
    `principal` bigint(20) NULL COMMENT '负责人',
    `tenant_id` bigint(20) NULL COMMENT '租户id',
    `delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记,0未删除,1删除',
    `is_default` bit(1) NULL COMMENT '是否默认',
    KEY `name` (`name`),
    KEY `address` (`address`),
    KEY `warehousing` (`warehousing`),
    KEY `truckage` (`truckage`),
    KEY `type` (`type`),
    KEY `sort` (`sort`),
    KEY `remark` (`remark`),
    KEY `principal` (`principal`),
    KEY `tenant_id` (`tenant_id`),
    KEY `delete_Flag` (`delete_Flag`),
    KEY `is_default` (`is_default`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-仓库表';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-11 of 11 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(20)仓库名称
addressvarchar(50)仓库地址
warehousingdecimal(24,6)仓储费
truckagedecimal(24,6)搬运费
typeint(10)类型
sortvarchar(10)排序
remarkvarchar(100)描述
principalbigint(20)负责人
tenant_idbigint(20)租户id
delete_Flagvarchar(1)0删除标记,0未删除,1删除0
is_defaultbit(1)是否默认

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 ↑