Saltar al contenido

app.vendor_bank_detail_changes

TablaSeguridad a nivel de fila activa

Append-only log of every person who created or edited a vendor's bank details. Anyone listed here cannot approve payment to the vendor (sod_vendor_payment).

Clave primaria: id

Columnas de app.vendor_bank_detail_changes
ColumnaTipoAdmite nulosDescripción
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org, derived from app.vendors on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id
vendor_iduuidNoVendor whose bank details changed.Hace referencia a app.vendors.id
vendor_bank_account_iduuidNoBank account that changed.Hace referencia a app.vendor_bank_accounts.id
changed_byuuidSíPerson who made the change, from the session.Hace referencia a app.people.id
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidSíPerson who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidSíPerson who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
deleted_attimestamp with time zoneSíSoft delete time. A row with deleted_at set is ignored by every access helper.