Created
May 21, 2022 17:24
-
-
Save odigity/1b36860cab60462dd94c48f07d7e850c to your computer and use it in GitHub Desktop.
Django 3.0 Default Schema
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
auth_group | |
id | |
name varchar(150) NOT NULL UNIQUE | |
auth_group_permissions | |
id | |
group_id integer NOT NULL REFERENCES "auth_group"("id") DEFERRABLE INITIALLY DEFERRED | |
permission_id integer NOT NULL REFERENCES "auth_permission"("id") DEFERRABLE INITIALLY DEFERRED | |
auth_permission | |
id | |
content_type_id integer NOT NULL REFERENCES "django_content_type"("id") DEFERRABLE INITIALLY DEFERRED | |
codename varchar(100) NOT NULL | |
name varchar(255) NOT NULL | |
auth_user | |
id | |
password varchar(128) NOT NULL | |
last_login datetime NULL | |
is_superuser bool NOT NULL | |
username varchar(150) NOT NULL UNIQUE | |
last_name varchar(150) NOT NULL | |
email varchar(254) NOT NULL | |
is_staff bool NOT NULL | |
is_active bool NOT NULL | |
date_joined datetime NOT NULL | |
first_name varchar(150) NOT NULL | |
auth_user_groups | |
id | |
user_id integer NOT NULL REFERENCES "auth_user"("id") DEFERRABLE INITIALLY DEFERRED | |
group_id integer NOT NULL REFERENCES "auth_group"("id") DEFERRABLE INITIALLY DEFERRED | |
auth_user_user_permissions | |
id | |
user_id integer NOT NULL REFERENCES "auth_user"("id") DEFERRABLE INITIALLY DEFERRED | |
permission_id integer NOT NULL REFERENCES "auth_permission"("id") DEFERRABLE INITIALLY DEFERRED | |
django_admin_log | |
id | |
action_time datetime NOT NULL | |
object_id text NULL | |
object_repr varchar(200) NOT NULL | |
change_message text NOT NULL | |
content_type_id integer NULL REFERENCES "django_content_type"("id") DEFERRABLE INITIALLY DEFERRED | |
user_id integer NOT NULL REFERENCES "auth_user"("id") DEFERRABLE INITIALLY DEFERRED | |
action_flag smallint unsigned NOT NULL CHECK("action_flag" >= 0) | |
django_content_type | |
id | |
app_label varchar(100) NOT NULL | |
model varchar(100) NOT NULL | |
django_migrations | |
id | |
app varchar(255) NOT NULL | |
name varchar(255) NOT NULL | |
applied datetime NOT NULL | |
django_session | |
session_key varchar(40) NOT NULL PRIMARY KEY | |
session_data text NOT NULL | |
expire_date datetime NOT NULL |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment