[DEMO] database dbhub schema

Login

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

None

None

schema
enable schema_database BOOLEAN

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
id schema_table INTEGER

The primary key

store table's schema here.

schema
name schema_table VARCHAR(100)

Table name

store table's schema here.

schema
comment schema_table TEXT

Comment for this table

store table's schema here.

Deleted schema
database_id schema_table INTEGER

Related database

store table's schema here.

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
id auth_user INTEGER

auto increment id

user

schema
password auth_user VARCHAR(128)

None

user

schema
last_login auth_user DATETIME

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
email auth_user VARCHAR(254)

None

user

schema
is_staff auth_user BOOLEAN

None

user

schema
is_active auth_user BOOLEAN

None

user

schema
date_joined auth_user DATETIME

None

user

schema
username auth_user VARCHAR(150)

None

user

schema
id auth_group INTEGER

auto increment id

user groups

schema
name auth_group VARCHAR(80)

name of group

user groups

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