+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_appver_apk:/tablelist/okayapi_appver_apk.html


-- MySQL Table okayapi_appver_apk
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_apk` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `channel_id` int(11) NOT NULL DEFAULT '0' COMMENT '渠道ID',
    `app_id` int(11) NOT NULL DEFAULT '0' COMMENT 'AppId',
    `version_id` int(11) NOT NULL DEFAULT '0' COMMENT '版本ID',
    `md5` varchar(64) NOT NULL COMMENT 'APK文件的MD5值',
    `oss_url` varchar(500) NOT NULL COMMENT 'apk文件oss存储地址',
    `delivery_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '标记渠道版本的安装包是否已上架(0-未上架;1-已上架)',
    `created_by` varchar(32) NOT NULL COMMENT '创建人',
    `del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
    `updated_by` varchar(32) NOT NULL COMMENT '更新人',
    KEY `channel_id` (`channel_id`),
    KEY `app_id` (`app_id`),
    KEY `version_id` (`version_id`),
    KEY `md5` (`md5`),
    KEY `oss_url` (`oss_url`),
    KEY `delivery_status` (`delivery_status`),
    KEY `created_by` (`created_by`),
    KEY `del_flag` (`del_flag`),
    KEY `updated_by` (`updated_by`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-安卓APK';

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


MySQL database table structure design

Displaying 1-9 of 9 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
channel_idint(11)0渠道ID0
app_idint(11)0AppId0
version_idint(11)0版本ID0
md5varchar(64)APK文件的MD5值
oss_urlvarchar(500)apk文件oss存储地址
delivery_statustinyint(1)0标记渠道版本的安装包是否已上架(0-未上架;1-已上架)0
created_byvarchar(32)创建人
del_flagtinyint(1)0是否删除0
updated_byvarchar(32)更新人

Guess You Like

MySQL Table Design okayapi_appver_access_log

MySQL Table Design okayapi_appver_android_version

MySQL Table Design okayapi_appver_apk_download_record

MySQL Table Design okayapi_appver_app

MySQL Table Design okayapi_appver_channel

MySQL Table Design okayapi_appver_chat_bot

MySQL Table Design okayapi_appver_custom_api

MySQL Table Design okayapi_appver_ios_version

MySQL Table Design okayapi_appver_operation_record_log

MySQL Table Design okayapi_appver_rn_package

MySQL Table Design okayapi_appver_rn_route

MySQL Table Design okayapi_appver_user

MySQL Table Design okayapi_appver_user_app_rel

TOP ↑