m_client_charge

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_client_charge_paid_by.client_charge_id FK_m_client_charge_paid_by_m_client_chargeR
client_id BIGINT 19 null
m_client.id FK_m_client_charge_m_clientR
charge_id BIGINT 19 null
m_charge.id FK_m_client_charge_m_chargeR
is_penalty BIT 1 null
charge_time_enum SMALLINT 5 null
charge_due_date DATE 10 √ NULL
charge_calculation_enum SMALLINT 5 null
amount DECIMAL 19,6 null
amount_paid_derived DECIMAL 19,6 √ NULL
amount_waived_derived DECIMAL 19,6 √ NULL
amount_writtenoff_derived DECIMAL 19,6 √ NULL
amount_outstanding_derived DECIMAL 19,6 null
is_paid_derived BIT 1 √ NULL
waived BIT 1 √ NULL
is_active BIT 1 √ NULL
inactivated_on_date DATE 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_m_client_charge_m_charge Performance Asc charge_id
FK_m_client_charge_m_client Performance Asc client_id

Relationships

Close relationships within degrees of separation