okayapi_landi_repository - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_landi_repository：/tablelist/okayapi_landi_repository.html


-- MySQL Table okayapi_landi_repository
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_repository` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `repo_num` varchar(64) NULL COMMENT '',
    `address` varchar(64) NULL COMMENT '',
    `area` double NULL COMMENT '',
    `manager_id` int(11) NULL COMMENT '',
    `manager_name` varchar(64) NULL COMMENT '管理员',
    `state` tinyint(3) NULL DEFAULT '0' COMMENT '0:空闲 1:占用',
    KEY `repo_num` (`repo_num`),
    KEY `address` (`address`),
    KEY `area` (`area`),
    KEY `manager_id` (`manager_id`),
    KEY `manager_name` (`manager_name`),
    KEY `state` (`state`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-库房';

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

MySQL database table structure design

Displaying 1-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
repo_num	varchar(64)		是		Unique Index
address	varchar(64)		是
area	double		是
manager_id	int(11)		是
manager_name	varchar(64)		是	管理员
state	tinyint(3)	0	是	0:空闲 1:占用		0