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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(20) | 是 | 仓库名称 | |||
address | varchar(50) | 是 | 仓库地址 | |||
warehousing | decimal(24,6) | 是 | 仓储费 | |||
truckage | decimal(24,6) | 是 | 搬运费 | |||
type | int(10) | 是 | 类型 | |||
sort | varchar(10) | 是 | 排序 | |||
remark | varchar(100) | 是 | 描述 | |||
principal | bigint(20) | 是 | 负责人 | |||
tenant_id | bigint(20) | 是 | 租户id | |||
delete_Flag | varchar(1) | 0 | 是 | 删除标记,0未删除,1删除 | 0 | |
is_default | bit(1) | 是 | 是否默认 |