api_historicalheadinvoice


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
deleted timestamptz 35,6 √ null
invoice_number float8 17,17 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
from_date timestamptz 35,6 √ null
to_date timestamptz 35,6 √ null
total_amount float8 17,17 null
exchange_rate float8 17,17 √ null
total_travels float8 17,17 null
total_travels_directs float8 17,17 null
total_appraisal float8 17,17 null
total_handling float8 17,17 null
total_materials float8 17,17 null
total_custody_cpv float8 17,17 null
total_custody_vault float8 17,17 null
total_custody_personal_atm float8 17,17 null
total_pieces float8 17,17 null
total_fixed_costs_packing float8 17,17 null
total_vigilant float8 17,17 null
total_atm_supply float8 17,17 null
total_atm_failure_1_2_levels float8 17,17 null
history_id serial 10 √ nextval('api_historicalheadinvoice_history_id_seq'::regclass)
history_date timestamptz 35,6 null
history_change_reason varchar 100 √ null
history_type varchar 1 null
company_contact_id int4 10 √ null
contract_id int4 10 √ null
employee_id int4 10 √ null
history_user_id int4 10 √ null
auth_user.id api_historicalheadin_history_user_id_52ee6476_fk_auth_user R
office_id int4 10 √ null
serviceorder_id int4 10 √ null
type_service_order_id int4 10 √ null
currency_id int4 10 √ null
due_date timestamptz 35,6 √ null
tax_exempt bool 1 null
tax_rate float8 17,17 √ null
total_disccount float8 17,17 √ null
total_tax_amount float8 17,17 √ null
file_uploaded text 2147483647 √ null
fuel_charge float8 17,17 null
total_fuel_charge float8 17,17 null
total_vouchers float8 17,17 null
total_cost_appraisal float8 17,17 null
total_cost_handling float8 17,17 null
total_amount_chest float8 17,17 null
total_insurance_chest float8 17,17 null
total_qty_chest float8 17,17 null
total_cost_materials float8 17,17 null
total_travels_points float8 17,17 null
product_and_service_id int4 10 √ null
total_cost_travels float8 17,17 null

Indexes

Constraint Name Type Sort Column(s)
api_historicalheadinvoice_pkey Primary key Asc history_id
api_historicalheadinvoice_company_contact_id_960efc82 Performance Asc company_contact_id
api_historicalheadinvoice_contract_id_53f2bc57 Performance Asc contract_id
api_historicalheadinvoice_currency_id_4471d506 Performance Asc currency_id
api_historicalheadinvoice_employee_id_08eb4461 Performance Asc employee_id
api_historicalheadinvoice_history_user_id_52ee6476 Performance Asc history_user_id
api_historicalheadinvoice_id_a7a53ff0 Performance Asc id
api_historicalheadinvoice_office_id_59eb6907 Performance Asc office_id
api_historicalheadinvoice_product_and_service_id_b2baf6dd Performance Asc product_and_service_id
api_historicalheadinvoice_serviceorder_id_d952045c Performance Asc serviceorder_id
api_historicalheadinvoice_type_service_order_id_af88965f Performance Asc type_service_order_id

Relationships

Close relationships within degrees of separation