billing

90848 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('money.billing_id_seq'::regclass)
account_adjustment.billing account_adjustment_billing_fkey N
xact int8 19 null
billing_ts timestamptz 35,6 null
voided bool 1 false
voider int4 10 √ null
void_time timestamptz 35,6 √ null
amount numeric 6,2 null
billing_type text 2147483647 null
btype int4 10 null
billing_type.id billing_btype_fkey R
note text 2147483647 √ null
create_date timestamptz 35,6 now()
period_start timestamptz 35,6 √ null
period_end timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
billing_pkey Primary key Asc id
m_b_create_date_idx Performance Asc create_date
m_b_period_end_idx Performance Asc period_end
m_b_period_start_idx Performance Asc period_start
m_b_time_idx Performance Asc billing_ts
m_b_voider_idx Performance Asc voider
m_b_xact_idx Performance Asc xact

Relationships

Close relationships within degrees of separation