MySQL Create Table SQL
Table Structure: okayapi_appver_channel：/tablelist/okayapi_appver_channel.html
-- MySQL Table okayapi_appver_channel
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_channel` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`app_id` int(11) NOT NULL DEFAULT '0' COMMENT '关联的APPID',
`channel_name` varchar(255) NOT NULL COMMENT '渠道名称',
`channel_code` varchar(255) NOT NULL COMMENT '渠道码',
`channel_type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '渠道类型 （1:应用市场 2:推广渠道）',
`created_by` varchar(64) NOT NULL COMMENT '创建人',
`del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否被删除',
`updated_by` varchar(32) NOT NULL COMMENT '更新人',
`channel_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1：正常 2：废弃 3：停用 ',
KEY `app_id` (`app_id`),
KEY `channel_name` (`channel_name`),
KEY `channel_code` (`channel_code`),
KEY `channel_type` (`channel_type`),
KEY `created_by` (`created_by`),
KEY `del_flag` (`del_flag`),
KEY `updated_by` (`updated_by`),
KEY `channel_status` (`channel_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-渠道';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-8 of 8 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| app_id | int(11) | 0 | 否 | 关联的APPID | Normal Index | 0 |
| channel_name | varchar(255) | 否 | 渠道名称 | |||
| channel_code | varchar(255) | 否 | 渠道码 | |||
| channel_type | tinyint(2) | 1 | 否 | 渠道类型 （1:应用市场 2:推广渠道） | 1 | |
| created_by | varchar(64) | 否 | 创建人 | |||
| del_flag | tinyint(1) | 0 | 否 | 是否被删除 | 0 | |
| updated_by | varchar(32) | 否 | 更新人 | |||
| channel_status | tinyint(1) | 1 | 否 | 1：正常 2：废弃 3：停用 | 1 |
