Skip to content

Instantly share code, notes, and snippets.

@odigity
Created May 21, 2022 17:24
Show Gist options
  • Save odigity/1b36860cab60462dd94c48f07d7e850c to your computer and use it in GitHub Desktop.
Save odigity/1b36860cab60462dd94c48f07d7e850c to your computer and use it in GitHub Desktop.
Django 3.0 Default Schema
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