staff_payment_statement_payments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
statement_id VARCHAR 36 null
staff_payment_statements.id fk_sps_payment_statement C
amount DECIMAL 12,2 null
payment_date DATE 10 null
reference VARCHAR 100 null
method VARCHAR 50 √ null
note VARCHAR 255 √ null
created_at DATETIME 19 null
updated_at DATETIME 19 √ null
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null
registered_at_utc DATETIME 26 √ null

Indexes

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

Relationships

Close relationships within degrees of separation