okayapi_appver_user_app_rel

MySQL Create Table SQL

Table Structure: okayapi_appver_user_app_rel：/tablelist/okayapi_appver_user_app_rel.html


-- MySQL Table okayapi_appver_user_app_rel
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_user_app_rel` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` varchar(32) NOT NULL COMMENT '用户ID',
    `app_id` int(10) NOT NULL DEFAULT '0' COMMENT 'APPID',
    `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
    KEY `user_id` (`user_id`),
    KEY `app_id` (`app_id`),
    KEY `created_time` (`created_time`),
    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-3 of 3 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
user_id	varchar(32)		否	用户ID
app_id	int(10)	0	否	APPID	0
created_time	timestamp	CURRENT_TIMESTAMP	否		CURRENT_TIMESTAMP

Guess You Like

MySQL Table Design okayapi_appver_access_log

MySQL Table Design okayapi_appver_android_version

MySQL Create Table SQL

MySQL database table structure design

Guess You Like

MySQL Table Design okayapi_appver_access_log

MySQL Table Design okayapi_appver_android_version

MySQL Table Design okayapi_appver_apk

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