invoices


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('invoices_id_seq'::regclass)
all_invoices.id Implied Constraint R
invoices_history.id Implied Constraint R
latest_payments.id Implied Constraint R
latest_secrets.id Implied Constraint R
payments.fk_invoice payments_fk_invoice_fkey R
secrets.fk_invoice secrets_fk_invoice_fkey R
order_id text 2147483647 null
first_name text 2147483647 null
last_name text 2147483647 null
email text 2147483647 null
amount numeric 0 null
origin text 2147483647 null
reference text 2147483647 √ null
due_date date 13 null
created_at timestamp 29,6 now()
metadata jsonb 2147483647 '{}'::jsonb
vat numeric 0 √ null
invalidated_at timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
invoices_pkey Primary key Asc id
invoices_order_id_key Must be unique Asc order_id

Relationships

Close relationships within degrees of separation