[DEMO] database dbhub schema

Login

Name Table Data Type Is Null Default Value Comment Table Comment Warning Database
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
id auth_group INTEGER

auto increment id

user groups

schema
name auth_group VARCHAR(80)

name of group

user groups

schema
id auth_user INTEGER

auto increment id

user

schema
password auth_user VARCHAR(128)

None

user

schema
is_superuser auth_user BOOLEAN

None

user

schema
first_name auth_user VARCHAR(30)

None

user

schema
last_name auth_user VARCHAR(30)

None

user

schema