MySQL Create Table SQL
Table Structure: okayapi_lend_book：/tablelist/okayapi_lend_book.html
-- MySQL Table okayapi_lend_book
-- From: OkayAPI.com
CREATE TABLE `okayapi_lend_book` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`book` varchar(30) NULL COMMENT '书籍',
`info` varchar(50) NULL COMMENT '书籍信息',
`owner` varchar(30) NULL COMMENT '拥有者',
`lender` varchar(32) NULL COMMENT '借书的人的uuid',
`telephone` varchar(50) NULL COMMENT '联系方式',
`tag` int(11) NULL COMMENT '0表示未被借出，1表示已经被借',
KEY `book` (`book`),
KEY `info` (`info`),
KEY `owner` (`owner`),
KEY `lender` (`lender`),
KEY `telephone` (`telephone`),
KEY `tag` (`tag`),
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-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| book | varchar(30) | 是 | 书籍 | |||
| info | varchar(50) | 是 | 书籍信息 | |||
| owner | varchar(30) | 是 | 拥有者 | |||
| lender | varchar(32) | 是 | 借书的人的uuid | |||
| telephone | varchar(50) | 是 | 联系方式 | |||
| tag | int(11) | 是 | 0表示未被借出，1表示已经被借 |
