[DEMO] database dbhub schema

Login

Name Table Database Data Type Is Null Default Value Comment Table Comment Warning
last_login auth_user schema DATETIME

None

None

comment schema_database schema TEXT

None

None

charset schema_database schema VARCHAR(100)

None

None

engine schema_database schema VARCHAR(10)

None

None

name sqlite_sequence schema NullType()

None

None

seq sqlite_sequence schema NullType()

None

None

object_id django_admin_log schema TEXT

None

None

content_type_id django_admin_log schema INTEGER

None

None

comment schema_table schema TEXT

Comment for this table

None

Deleted
charset schema_table schema VARCHAR(100)

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

None

Not Match
engine schema_table schema VARCHAR(10)

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

None

Deleted Not Match
is_null schema_column schema BOOLEAN

None

None

default_value schema_column schema VARCHAR(1000)

None

None

comment schema_column schema TEXT

None

None

data_type schema_column schema VARCHAR(100)

None

None

include_columns schema_index schema VARCHAR(1000)

None

None

type schema_index schema VARCHAR(100)

None

None

enable schema_database schema BOOLEAN

None

None

id auth_group schema INTEGER

None

None

name auth_group schema VARCHAR(80)

None

None

id auth_user schema INTEGER

None

None

password auth_user schema VARCHAR(128)

None

None

is_superuser auth_user schema BOOLEAN

None

None

first_name auth_user schema VARCHAR(30)

None

None

last_name auth_user schema VARCHAR(30)

None

None