[DEMO] database dbhub schema

Login

Name Table Data Type Is Null Default Value Comment Table Comment Warning Database
id schema_index INTEGER

None

None

schema
name schema_index VARCHAR(100)

None

None

schema
table_id schema_index INTEGER

None

None

schema
is_deleted schema_column BOOLEAN

None

None

schema
is_enum schema_column BOOLEAN

None

None

schema
is_comment_dirty schema_column BOOLEAN

None

None

schema
last_login auth_user DATETIME

None

user

schema
comment schema_database TEXT

None

None

schema
charset schema_database VARCHAR(100)

None

None

schema
engine schema_database VARCHAR(10)

None

None

schema
name sqlite_sequence NullType()

None

None

schema
seq sqlite_sequence NullType()

None

None

schema
object_id django_admin_log TEXT

None

None

schema
content_type_id django_admin_log INTEGER

None

None

schema
comment schema_table TEXT

Comment for this table

store table's schema here.

Deleted schema
charset schema_table VARCHAR(100)

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

store table's schema here.

Not Match schema
engine schema_table VARCHAR(10)

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

store table's schema here.

Deleted Not Match schema
is_null schema_column BOOLEAN

None

None

schema
default_value schema_column VARCHAR(1000)

None

None

schema
comment schema_column TEXT

None

None

schema
data_type schema_column VARCHAR(100)

None

None

schema
include_columns schema_index VARCHAR(1000)

None

None

schema
type schema_index VARCHAR(100)

None

None

schema
enable schema_database BOOLEAN

None

None

schema
DBHUB is built with <3 using Django & maintained by huifenqi.