MySQL Create Table SQL
Table Structure: okayapi_attach：/tablelist/okayapi_attach.html
-- MySQL Table okayapi_attach
-- From: OkayAPI.com
CREATE TABLE `okayapi_attach` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`file_name` varchar(255) NULL COMMENT '附件名称',
`access_key` varchar(32) NULL COMMENT '批次 Key',
`file_location` varchar(255) NULL COMMENT '文件位置',
`file_type` varchar(32) NULL DEFAULT '0' COMMENT '文件类型',
`item_type` varchar(32) NULL DEFAULT '0' COMMENT '关联类型',
KEY `file_name` (`file_name`),
KEY `access_key` (`access_key`),
KEY `file_location` (`file_location`),
KEY `file_type` (`file_type`),
KEY `item_type` (`item_type`),
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 | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| file_name | varchar(255) | 是 | 附件名称 | |||
| access_key | varchar(32) | 是 | 批次 Key | |||
| file_location | varchar(255) | 是 | 文件位置 | |||
| file_type | varchar(32) | 0 | 是 | 文件类型 | 0 | |
| item_type | varchar(32) | 0 | 是 | 关联类型 | 0 |
