shop_settlements

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
transfer_logs.shop_settlement_id transfer_logs_shop_settlement_id_fkey R
shop_id INT 10 null
shops.id shop_settlements_shop_id_fkey R
period DATETIME 23 null
sales DOUBLE 22 null
commission DOUBLE 22 null
transfer_amount DOUBLE 22 null
status enum('PENDING', 'TEMP_LOCKED', 'FINALIZED', 'TRANSFERRED') 11 PENDING
created_at DATETIME 23 CURRENT_TIMESTAMP(3)
updated_at DATETIME 23 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
shop_settlements_shop_id_fkey Performance Asc shop_id

Relationships

Close relationships within degrees of separation