[DEMO] database dbhub schema

Login

Name Table Database Data Type Is Null Default Value Comment Table Comment Warning
type schema_index schema VARCHAR(100)

None

None

table_id schema_index schema INTEGER

None

None

include_columns schema_index schema VARCHAR(1000)

None

None

name schema_index schema VARCHAR(100)

None

None

id schema_index schema INTEGER

None

None

is_comment_dirty schema_column schema BOOLEAN

None

None

is_enum schema_column schema BOOLEAN

None

None

is_deleted schema_column schema BOOLEAN

None

None

data_type schema_column schema VARCHAR(100)

None

None

table_id schema_column schema INTEGER

None

None

comment schema_column schema TEXT

None

None

default_value schema_column schema VARCHAR(1000)

None

None

is_null schema_column schema BOOLEAN

None

None

name schema_column schema VARCHAR(100)

None

None

id schema_column schema INTEGER

None

None

permission_id auth_user_user_permissions schema INTEGER

None

None

user_id auth_user_user_permissions schema INTEGER

None

None

id auth_user_user_permissions schema INTEGER

None

None

permission_id auth_group_permissions schema INTEGER

None

None

group_id auth_group_permissions schema INTEGER

None

None

id auth_group_permissions schema INTEGER

None

None

engine schema_table schema VARCHAR(10)

数据库表对应引擎
InnoDB: 支持事务
MySIAM: 查询速度快

None

Deleted Not Match
charset schema_table schema VARCHAR(100)

字符集
utf8: mysql 默认 utf8,阉割版,一些标准 utf8 字符在此并不支持
utf8mb4: 用于支持完整的 utf8

None

Not Match
database_id schema_table schema INTEGER

Related database

None

comment schema_table schema TEXT

Comment for this table

None

Deleted