MySQL Create Table SQL
Table Structure: okayapi_appver_app：/tablelist/okayapi_appver_app.html
-- MySQL Table okayapi_appver_app
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_app` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否被删除',
`updated_by` varchar(32) NOT NULL COMMENT '更新人',
`app_name` varchar(255) NOT NULL COMMENT 'APP名称',
`tenant_app_id` varchar(32) NOT NULL COMMENT '租户应用ID',
`created_by` varchar(64) NOT NULL COMMENT '创建人',
KEY `del_flag` (`del_flag`),
KEY `updated_by` (`updated_by`),
KEY `app_name` (`app_name`),
KEY `tenant_app_id` (`tenant_app_id`),
KEY `created_by` (`created_by`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-APP';
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 |
|---|---|---|---|---|---|---|
| del_flag | tinyint(1) | 0 | 否 | 是否被删除 | 0 | |
| updated_by | varchar(32) | 否 | 更新人 | |||
| app_name | varchar(255) | 否 | APP名称 | |||
| tenant_app_id | varchar(32) | 否 | 租户应用ID | |||
| created_by | varchar(64) | 否 | 创建人 |
