ins_inspection_invoice

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
version int4 10 null
created_by varchar 255 √ null
created_date timestamp 29,6 √ null
last_modified_by varchar 255 √ null
last_modified_date timestamp 29,6 √ null
inspection_id uuid 2147483647 null
ins_inspection.id fk_ins_inspection_invoice_on_inspection R
status_id uuid 2147483647 null
ins_inspection_invoice_status.id fk_ins_inspection_invoice_on_status R
external_invoice_number varchar 255 √ null
invoice_number varchar 255 null
reference varchar 255 √ null
generated_at timestamp 29,6 null
due_at timestamp 29,6 √ null
amount numeric 19,2 null
taxe numeric 19,2 √ null
prefix varchar 255 √ null
payment_on timestamp 29,6 √ null
third_party_id uuid 2147483647 null
thirdp_base_third_party.id fk_ins_inspection_invoice_on_third_party R
type_id uuid 2147483647 null
ins_inspection_invoice_type.id fk_ins_inspection_invoice_on_type R
amount_with_taxe numeric 19,2 null

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_invoice Primary key Asc id
idx_ins_inspection_invoice_inspection Performance Asc inspection_id
idx_ins_inspection_invoice_status Performance Asc status_id
idx_ins_inspection_invoice_third_party Performance Asc third_party_id
idx_ins_inspection_invoice_type Performance Asc type_id

Relationships

Close relationships within degrees of separation