Schema Library

Popular database schema diagrams

Explore the real database schemas behind popular projects. Every diagram shows tables, columns, primary keys, and foreign key relationships - rendered from official migrations and docs.

* 1 * 1 * 1 users instance_id uuid id uuid PK aud varchar(255) role varchar(255) email varchar(255) encrypted_password varchar(255) email_confirmed_at timestamptz invited_at timestamptz confirmation_token varchar(255) confirmation_sent_at timestamptz recovery_token varchar(255) recovery_sent_at timestamptz email_change_token_current varchar(255) email_change_token_new varchar(255) email_change varchar(255) email_change_sent_at timestamptz last_sign_in_at timestamptz raw_app_meta_data jsonb raw_user_meta_data jsonb is_super_admin bool created_at timestamptz updated_at timestamptz phone text phone_confirmed_at timestamptz phone_change text phone_change_token varchar(255) phone_change_sent_at timestamptz confirmed_at timestamptz email_change_confirm_status smallint banned_until timestamptz reauthentication_token varchar(255) reauthentication_sent_at timestamptz is_sso_user bool deleted_at timestamptz is_anonymous bool identities provider_id text user_id uuid FK identity_data jsonb provider text last_sign_in_at timestamptz created_at timestamptz updated_at timestamptz email text id text PK sessions id uuid PK user_id uuid FK created_at timestamptz updated_at timestamptz factor_id uuid aal aal_level not_after timestamptz refreshed_at timestamptz user_agent text ip inet tag text refresh_tokens instance_id uuid id bigint PK token varchar(255) user_id varchar(255) FK revoked bool created_at timestamptz updated_at timestamptz parent varchar(255) session_id uuid instances id uuid PK uuid uuid raw_base_config text created_at timestamptz updated_at timestamptz audit_log_entries instance_id uuid id uuid PK payload json created_at timestamptz ip_address varchar(64) schema_migrations version varchar(255) PK

Supabase.

Supabase

Supabase Database Schema Diagram

* 1 * 1 users id text PK name text email text emailVerified timestamptz image text accounts id text PK userId text FK type text provider text providerAccountId text refresh_token text access_token text expires_at int token_type text scope text id_token text session_state text sessions id text PK sessionToken text userId text FK expires timestamptz verification_tokens identifier text token text expires timestamptz

NextAuth.js.

NextAuth.js

NextAuth.js Database Schema (Auth.js)

* 1 users id bigint PK name varchar email varchar email_verified_at timestamp password varchar remember_token varchar(100) created_at timestamp updated_at timestamp password_reset_tokens email varchar PK token varchar created_at timestamp sessions id varchar PK user_id bigint FK ip_address varchar(45) user_agent text payload longtext last_activity int jobs id bigint PK queue varchar payload longtext attempts tinyint reserved_at int available_at int created_at int failed_jobs id bigint PK uuid varchar connection text queue text payload longtext exception longtext failed_at timestamp cache key varchar PK value mediumtext expiration int cache_locks key varchar PK owner varchar expiration int

Laravel.

Laravel

Laravel Database Schema Diagram

* 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 auth_user id int PK password varchar(128) last_login timestamp is_superuser boolean username varchar(150) first_name varchar(150) last_name varchar(150) email varchar(254) is_staff boolean is_active boolean date_joined timestamp auth_group id int PK name varchar(150) auth_permission id int PK name varchar(255) content_type_id int FK codename varchar(100) auth_user_groups id int PK user_id int FK group_id int FK auth_user_user_permissions id int PK user_id int FK permission_id int FK auth_group_permissions id int PK group_id int FK permission_id int FK django_content_type id int PK app_label varchar(100) model varchar(100) django_admin_log id int PK action_time timestamp object_id text object_repr varchar(200) action_flag smallint change_message text content_type_id int FK user_id int FK django_session session_key varchar(40) PK session_data text expire_date timestamp

Django.

Django

Django Auth Database Schema Diagram

* 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 customers id text PK email varchar name varchar phone varchar description text default_currency varchar(3) balance int metadata jsonb created timestamptz deleted_at timestamptz products id text PK name varchar description text active bool type varchar metadata jsonb created timestamptz updated timestamptz prices id text PK product_id text FK unit_amount int currency varchar(3) billing_interval varchar interval_count int active bool type varchar created timestamptz subscriptions id text PK customer_id text FK status varchar collection_method varchar current_period_start timestamptz current_period_end timestamptz cancel_at_period_end bool canceled_at timestamptz trial_start timestamptz trial_end timestamptz default_payment_method_id text FK metadata jsonb created timestamptz subscription_items id text PK subscription_id text FK price_id text FK quantity int created timestamptz invoices id text PK customer_id text FK subscription_id text FK status varchar amount_due int amount_paid int currency varchar(3) attempt_count int due_date timestamptz paid_at timestamptz hosted_invoice_url text created timestamptz invoice_line_items id text PK invoice_id text FK price_id text FK amount int currency varchar(3) description text quantity int period_start timestamptz period_end timestamptz payment_methods id text PK customer_id text FK type varchar card_brand varchar card_last4 varchar(4) card_exp_month smallint card_exp_year smallint billing_country varchar(2) created timestamptz payment_intents id text PK customer_id text FK invoice_id text FK amount int currency varchar(3) status varchar payment_method_id text FK client_secret text created timestamptz

Stripe.

Stripe

Stripe Billing Database Schema Diagram

* 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 * 1 customers id uuid PK email varchar first_name varchar last_name varchar phone varchar created_at timestamptz updated_at timestamptz addresses id uuid PK customer_id uuid FK label varchar line1 varchar line2 varchar city varchar state varchar postal_code varchar country varchar(2) is_default bool categories id uuid PK name varchar slug varchar parent_id uuid FK description text created_at timestamptz products id uuid PK title varchar slug varchar description text category_id uuid FK price_cents int currency varchar(3) inventory_count int is_active bool created_at timestamptz updated_at timestamptz product_images id uuid PK product_id uuid FK url text alt_text varchar position int created_at timestamptz carts id uuid PK customer_id uuid FK status varchar created_at timestamptz updated_at timestamptz expires_at timestamptz cart_items id uuid PK cart_id uuid FK product_id uuid FK quantity int unit_price_cents int added_at timestamptz orders id uuid PK customer_id uuid FK status varchar total_cents int currency varchar(3) shipping_address_id uuid FK billing_address_id uuid FK placed_at timestamptz paid_at timestamptz shipped_at timestamptz order_items id uuid PK order_id uuid FK product_id uuid FK quantity int unit_price_cents int total_cents int created_at timestamptz payments id uuid PK order_id uuid FK provider varchar provider_payment_id text amount_cents int currency varchar(3) status varchar created_at timestamptz reviews id uuid PK product_id uuid FK customer_id uuid FK rating smallint title varchar body text created_at timestamptz

E-commerce.

E-commerce

E-commerce Database Schema Diagram (PostgreSQL)