+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_hc_act_re_model:/tablelist/okayapi_hc_act_re_model.html


-- MySQL Table okayapi_hc_act_re_model
-- From: OkayAPI.com
CREATE TABLE `okayapi_hc_act_re_model` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `ID_` varchar(64) NULL COMMENT '',
    `REV_` int(11) NULL COMMENT '',
    `NAME_` varchar(255) NULL COMMENT '',
    `KEY_` varchar(255) NULL COMMENT '',
    `CATEGORY_` varchar(255) NULL COMMENT '',
    `CREATE_TIME_` timestamp(3) NULL COMMENT '',
    `LAST_UPDATE_TIME_` timestamp(3) NULL COMMENT '',
    `VERSION_` int(11) NULL COMMENT '',
    `META_INFO_` varchar(4000) NULL COMMENT '',
    `DEPLOYMENT_ID_` varchar(64) NULL COMMENT '',
    `EDITOR_SOURCE_VALUE_ID_` varchar(64) NULL COMMENT '',
    `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) NULL COMMENT '',
    `TENANT_ID_` varchar(255) NULL COMMENT '',
    KEY `ID_` (`ID_`),
    KEY `REV_` (`REV_`),
    KEY `NAME_` (`NAME_`),
    KEY `KEY_` (`KEY_`),
    KEY `CATEGORY_` (`CATEGORY_`),
    KEY `CREATE_TIME_` (`CREATE_TIME_`),
    KEY `LAST_UPDATE_TIME_` (`LAST_UPDATE_TIME_`),
    KEY `VERSION_` (`VERSION_`),
    KEY `META_INFO_` (`META_INFO_`),
    KEY `DEPLOYMENT_ID_` (`DEPLOYMENT_ID_`),
    KEY `EDITOR_SOURCE_VALUE_ID_` (`EDITOR_SOURCE_VALUE_ID_`),
    KEY `EDITOR_SOURCE_EXTRA_VALUE_ID_` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
    KEY `TENANT_ID_` (`TENANT_ID_`),
    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-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
ID_varchar(64)
REV_int(11)
NAME_varchar(255)
KEY_varchar(255)
CATEGORY_varchar(255)
CREATE_TIME_timestamp(3)
LAST_UPDATE_TIME_timestamp(3)
VERSION_int(11)
META_INFO_varchar(4000)
DEPLOYMENT_ID_varchar(64)Normal Index
EDITOR_SOURCE_VALUE_ID_varchar(64)Normal Index
EDITOR_SOURCE_EXTRA_VALUE_ID_varchar(64)Normal Index
TENANT_ID_varchar(255)

Guess You Like

MySQL Table Design okayapi_mall_ums_member_receive_address

MySQL Table Design okayapi_mall_ums_member_rule_setting

MySQL Table Design okayapi_mall_ums_member_statistics_info

MySQL Table Design okayapi_mall_ums_role_permission_relation

MySQL Table Design okayapi_cloud_image_sync

MySQL Table Design okayapi_hc_group_buy

TOP ↑