manual_payment_concepts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
statement_id VARCHAR 36 null
staff_payment_statements.id fk_manual_concept_statement C
concept_type VARCHAR 20 null
amount DECIMAL 12,2 null
description VARCHAR 255 √ null
documentation_ref VARCHAR 255 √ null
created_at DATETIME 19 null
updated_at DATETIME 19 √ null
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_manual_concept_statement Performance Asc statement_id

Relationships

Close relationships within degrees of separation