Schema diagram with editable notes

Tables and relationships from your SQL. Scroll inside the diagram to explore a large schema.

3 SQL statement(s) in the source were not used in this snapshot. This edition does not treat them as understood tables or relationships. Unused statement starts: CREATE SCHEMA app | CREATE SCHEMA audit | CREATE INDEX idx_orders_customer ON app.orders (customer_id)

Edit table and column notes below, then save a new copy. Names, columns and relationships stay unchanged.

Relationships

Editable notes

Open a table to edit its notes. Changes stay in this browser until you save a new copy.

app.customers

People and companies who buy from us.

Synthetic client-facing note: this table lists made-up buyers in the demo shop. It is not a real customer list. Add your own wording here, then use Save edited copy. That save does not change dictionary.csv.

Column	Type	Notes
id	INTEGER	primary key
full_name	VARCHAR
email	TEXT	Unique email address used for login.
status	VARCHAR
created_at	TIMESTAMP WITHOUT TIME ZONE

app.addresses

Column	Type	Notes
id	INTEGER	primary key
customer_id	INTEGER	links to app.customers(id)
line1	VARCHAR
city	VARCHAR
postal_code	VARCHAR

app.categories

Column	Type	Notes
id	INTEGER	primary key
name	VARCHAR
parent_category_id	INTEGER	links to app.categories(id)

app.suppliers

Column	Type	Notes
id	INTEGER	primary key
name	VARCHAR
active	BOOLEAN

app.products

Items we sell to customers.

Column	Type	Notes
id	INTEGER	primary key
sku	VARCHAR
name	VARCHAR
price	NUMERIC
category_id	INTEGER	links to app.categories(id)
supplier_id	INTEGER	links to app.suppliers(id)

app.orders

Column	Type	Notes
id	INTEGER	primary key
customer_id	INTEGER	links to app.customers(id)
billing_address_id	INTEGER	links to app.addresses(id)
shipping_address_id	INTEGER	links to app.addresses(id)
order_date	DATE
total_amount	NUMERIC

app.order_items

Column	Type	Notes
order_id	INTEGER	primary key, links to app.orders(id)
product_id	INTEGER	primary key, links to app.products(id)
quantity	INTEGER
unit_price	NUMERIC

app.payments

Column	Type	Notes
id	INTEGER	primary key
order_id	INTEGER	links to app.orders(id)
amount	NUMERIC
method	VARCHAR
paid_at	TIMESTAMP WITHOUT TIME ZONE

app.invoices

Column	Type	Notes
id	INTEGER	primary key
order_id	INTEGER	links to app.orders(id)
customer_id	INTEGER	links to app.customers(id)
issued_at	TIMESTAMP WITHOUT TIME ZONE
total_amount	NUMERIC

app.inventory

Column	Type	Notes
id	INTEGER	primary key
product_id	INTEGER	links to app.products(id)
warehouse	VARCHAR
quantity_on_hand	INTEGER

audit.login_events

Column	Type	Notes
id	INTEGER	primary key
customer_id	INTEGER	links to app.customers(id)
user_agent	TEXT	Raw browser string, kept only for fraud checks.
happened_at	TIMESTAMP WITHOUT TIME ZONE

audit.change_log

Column	Type	Notes
id	INTEGER	primary key
customer_id	INTEGER	links to app.customers(id)
table_name	VARCHAR
changed_at	TIMESTAMP WITHOUT TIME ZONE