Sheet 1
cskefu_v8_design
20221229-154435
  cs_group_users
    id
    groupid
    userid
    createtime
    updatetime
  cs_groups
    id
    name
    description
    createtime
    updatetime
    deleted
    creator
  cs_permission_groups
    id
    groupid
    resourceoperationid
    enabled
    createtime
    updatetime
  cs_permission_users
    id
    userid
    resourcepatternid
    enabled
    createtime
    updatetime
  cs_plugins
    id
    name
    groupid
    artifactid
    version
    description
    gridfsfileidweb
    gridfsfileidjar
    pluginjson
    state
    installerid
    vendor
    officialsite
    vendoremail
    createtime
    updatetime
    deleted
  cs_plugins_config_global
    id
    plugingroupid
    pluginartifactid
    pluginversion
    name
    value
    type
    help
    required
    lastmodifieduserid
    createtime
    updatetime
  cs_plugins_config_space
    id
    plugingroupid
    pluginartifactid
    pluginversion
    spaceid
    name
    type
    value
    help
    required
    lastmodifieduserid
    createtime
    updatetime
  cs_resource_operations
    id
    name
    description
    resourceid
    pathpattern
    method
    pluginid
    createtime
    updatetime
  cs_resources
    id
    spacekey
    name
    description
  cs_spaces
    id
    spacename
    spacekey
    creator
    description
    createtime
    updatetime
  cs_users
    id
    lastname
    username
    firstname
    realname
    englishname
    phonenumber
    phonecountrycode
    phoneverified
    birthday
    country
    province
    city
    street
    avatarurl
    sex
    birthyear
    primarylanguage
    bio
    email
    emailverified
    password
    identitytype
    identitynumber
    identityverified
    identityverifydate
    blocked
    deleted
    createtime
    updatetime
[
"cs_group_users",
"cs_groups",
"cs_permission_groups",
"cs_permission_users",
"cs_plugins",
"cs_plugins_config_global",
"cs_plugins_config_space",
"cs_resource_operations",
"cs_resources",
"cs_spaces",
"cs_users"
]
Generated with https://github.com/hailiang-wang/mysql-tables-design
{
"name": "cs_group_users",
"comment": "Users in Group",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 10:15:04"
}
unique constraint: INDEX_USERID_GROUPID
fields: groupid, userid
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "groupid",
"pos": 2,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_GROUP_ID] linked primary key:
cs_groups.id
{
"name": "userid",
"pos": 3,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_USER_ID] linked primary key:
cs_users.id
{
"name": "createtime",
"pos": 4,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 5,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "cs_groups",
"comment": "Groups",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 10:15:49"
}
unique constraint: name_UNIQUE
fields: name
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
primary key [FKEY_GROUP_ID] linked foreign key:
cs_group_users.groupid
primary key [cs_permission_groups_ibfk_2] linked foreign key:
cs_permission_groups.groupid
{
"name": "name",
"pos": 2,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "description",
"pos": 3,
"default": null,
"is_nullable": "YES",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "createtime",
"pos": 4,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "updatetime",
"pos": 5,
"default": "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "deleted",
"pos": 6,
"default": "0",
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "creator",
"pos": 7,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_GROUPS_USERS_CREATOR] linked primary key:
cs_users.id
{
"name": "cs_permission_groups",
"comment": "Permission for each group against Resource Operations",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 15:59:25"
}
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "groupid",
"pos": 2,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [cs_permission_groups_ibfk_2] linked primary key:
cs_groups.id
{
"name": "resourceoperationid",
"pos": 3,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [cs_permission_groups_ibfk_1] linked primary key:
cs_resource_operations.id
{
"name": "enabled",
"pos": 4,
"default": null,
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "createtime",
"pos": 5,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 6,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "cs_permission_users",
"comment": "Permission for user against Resource Operations",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 15:59:45"
}
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "userid",
"pos": 2,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_USERID] linked primary key:
cs_users.id
{
"name": "resourcepatternid",
"pos": 3,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_RESPATTERNID] linked primary key:
cs_resource_operations.id
{
"name": "enabled",
"pos": 4,
"default": null,
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "createtime",
"pos": 5,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 6,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "cs_plugins",
"comment": "Plugins",
"charset": "utf8mb4_bin",
"createddate": "2022-12-29 10:51:55"
}
unique constraint: INDEX_GROUP_ART_VERSION
fields: groupid, artifactid, version
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
primary key [FKEY_PLUGIN_ID] linked foreign key:
cs_resource_operations.pluginid
{
"name": "name",
"pos": 2,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 255,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(255)"
}
{
"name": "groupid",
"pos": 3,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "artifactid",
"pos": 4,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "version",
"pos": 5,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 30,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(30)"
}
{
"name": "description",
"pos": 6,
"default": null,
"is_nullable": "YES",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "gridfsfileidweb",
"pos": 7,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "gridfsfileidjar",
"pos": 8,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "pluginjson",
"pos": 9,
"default": null,
"is_nullable": "YES",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "state",
"pos": 10,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 255,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(255)"
}
{
"name": "installerid",
"pos": 11,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_INSTALLER] linked primary key:
cs_users.id
{
"name": "vendor",
"pos": 12,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 500,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(500)"
}
{
"name": "officialsite",
"pos": 13,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 500,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(500)"
}
{
"name": "vendoremail",
"pos": 14,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 255,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(255)"
}
{
"name": "createtime",
"pos": 15,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 16,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "deleted",
"pos": 17,
"default": "0",
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "cs_plugins_config_global",
"comment": "Plugin Configurations globally",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 16:12:31"
}
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "plugingroupid",
"pos": 2,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "pluginartifactid",
"pos": 3,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "pluginversion",
"pos": 4,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 30,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(30)"
}
{
"name": "name",
"pos": 5,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 255,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(255)"
}
{
"name": "value",
"pos": 6,
"default": null,
"is_nullable": "YES",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "type",
"pos": 7,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 30,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(30)"
}
{
"name": "help",
"pos": 8,
"default": null,
"is_nullable": "YES",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "required",
"pos": 9,
"default": null,
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "lastmodifieduserid",
"pos": 10,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_LAST_MODIFIED_BY_G] linked primary key:
cs_users.id
{
"name": "createtime",
"pos": 11,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 12,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "cs_plugins_config_space",
"comment": "Plugin Configurations by per Space",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 16:12:31"
}
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "plugingroupid",
"pos": 2,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "pluginartifactid",
"pos": 3,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "pluginversion",
"pos": 4,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 30,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(30)"
}
{
"name": "spaceid",
"pos": 5,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_SPACE_ID] linked primary key:
cs_spaces.id
{
"name": "name",
"pos": 6,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 255,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(255)"
}
{
"name": "type",
"pos": 7,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 30,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(30)"
}
{
"name": "value",
"pos": 8,
"default": null,
"is_nullable": "YES",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "help",
"pos": 9,
"default": null,
"is_nullable": "YES",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "required",
"pos": 10,
"default": null,
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "lastmodifieduserid",
"pos": 11,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_LAST_MODIFIED_BY] linked primary key:
cs_users.id
{
"name": "createtime",
"pos": 12,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 13,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "cs_resource_operations",
"comment": "Operations upon Resources",
"charset": "utf8mb4_bin",
"createddate": "2022-12-29 10:48:47"
}
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
primary key [cs_permission_groups_ibfk_1] linked foreign key:
cs_permission_groups.resourceoperationid
primary key [FKEY_RESPATTERNID] linked foreign key:
cs_permission_users.resourcepatternid
{
"name": "name",
"pos": 2,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 30,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(30)"
}
{
"name": "description",
"pos": 3,
"default": null,
"is_nullable": "NO",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "resourceid",
"pos": 4,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_RESOURCE_ID] linked primary key:
cs_resources.id
{
"name": "pathpattern",
"pos": 5,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 500,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(500)"
}
{
"name": "method",
"pos": 6,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 255,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(255)"
}
{
"name": "pluginid",
"pos": 7,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_PLUGIN_ID] linked primary key:
cs_plugins.id
{
"name": "createtime",
"pos": 8,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 9,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "cs_resources",
"comment": "Resources",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 16:00:13"
}
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
primary key [FKEY_RESOURCE_ID] linked foreign key:
cs_resource_operations.resourceid
{
"name": "spacekey",
"pos": 2,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 300,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(300)"
}
foreign key [FKEY_SPACEKEY] linked primary key:
cs_spaces.id
{
"name": "name",
"pos": 3,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 30,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(30)"
}
{
"name": "description",
"pos": 4,
"default": null,
"is_nullable": "NO",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "cs_spaces",
"comment": "Spaces",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 10:19:37"
}
unique constraint: groupkey_UNIQUE
fields: spacekey
unique constraint: groupname_UNIQUE
fields: spacename
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
primary key [FKEY_SPACE_ID] linked foreign key:
cs_plugins_config_space.spaceid
primary key [FKEY_SPACEKEY] linked foreign key:
cs_resources.spacekey
{
"name": "spacename",
"pos": 2,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 300,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(300)"
}
{
"name": "spacekey",
"pos": 3,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 300,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(300)"
}
{
"name": "creator",
"pos": 4,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
foreign key [FKEY_SPACES_USERS_CREATOR] linked primary key:
cs_users.id
{
"name": "description",
"pos": 5,
"default": null,
"is_nullable": "NO",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "createtime",
"pos": 6,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 7,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "NO",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "cs_users",
"comment": "Users",
"charset": "utf8mb4_bin",
"createddate": "2022-12-28 10:22:24"
}
unique constraint: EMAIL
fields: email
unique constraint: PHONENUMBER
fields: phonecountrycode, phonenumber
unique constraint: username_UNIQUE
fields: username
{
"name": "id",
"pos": 1,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
primary key [FKEY_GROUPS_USERS_CREATOR] linked foreign key:
cs_groups.creator
primary key [FKEY_USER_ID] linked foreign key:
cs_group_users.userid
primary key [FKEY_USERID] linked foreign key:
cs_permission_users.userid
primary key [FKEY_INSTALLER] linked foreign key:
cs_plugins.installerid
primary key [FKEY_LAST_MODIFIED_BY_G] linked foreign key:
cs_plugins_config_global.lastmodifieduserid
primary key [FKEY_LAST_MODIFIED_BY] linked foreign key:
cs_plugins_config_space.lastmodifieduserid
primary key [FKEY_SPACES_USERS_CREATOR] linked foreign key:
cs_spaces.creator
{
"name": "lastname",
"pos": 2,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "username",
"pos": 3,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "firstname",
"pos": 4,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 100,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(100)"
}
{
"name": "realname",
"pos": 5,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "englishname",
"pos": 6,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "phonenumber",
"pos": 7,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "phonecountrycode",
"pos": 8,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "phoneverified",
"pos": 9,
"default": "0",
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "birthday",
"pos": 10,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "country",
"pos": 11,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "province",
"pos": 12,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "city",
"pos": 13,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "street",
"pos": 14,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 500,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(500)"
}
{
"name": "avatarurl",
"pos": 15,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 500,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(500)"
}
{
"name": "sex",
"pos": 16,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "birthyear",
"pos": 17,
"default": null,
"is_nullable": "YES",
"data_type": "int",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "int(11)"
}
{
"name": "primarylanguage",
"pos": 18,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "bio",
"pos": 19,
"default": null,
"is_nullable": "YES",
"data_type": "text",
"varchar_max": 65535,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "text"
}
{
"name": "email",
"pos": 20,
"default": null,
"is_nullable": "NO",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "emailverified",
"pos": 21,
"default": "0",
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "password",
"pos": 22,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 200,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(200)"
}
{
"name": "identitytype",
"pos": 23,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 45,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(45)"
}
{
"name": "identitynumber",
"pos": 24,
"default": null,
"is_nullable": "YES",
"data_type": "varchar",
"varchar_max": 100,
"charset": "utf8mb4",
"collation_name": "utf8mb4_bin",
"column_type": "varchar(100)"
}
{
"name": "identityverified",
"pos": 25,
"default": "0",
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "identityverifydate",
"pos": 26,
"default": null,
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "blocked",
"pos": 27,
"default": "0",
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "deleted",
"pos": 28,
"default": null,
"is_nullable": "YES",
"data_type": "tinyint",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "tinyint(1)"
}
{
"name": "createtime",
"pos": 29,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}
{
"name": "updatetime",
"pos": 30,
"default": "CURRENT_TIMESTAMP",
"is_nullable": "YES",
"data_type": "datetime",
"varchar_max": null,
"charset": null,
"collation_name": null,
"column_type": "datetime"
}