puli_contratti - Laravel Schema Designer

contracts

id increments
number string (40)
contract_type_id ^FK integer
customer_id ^FK integer
machine_id ^FK integer
date_start date
date_end date
date_end_effective date
end_notes string
notes string
timestamps timestamps
softDeletes softDeletes
automatic_renewal boolean

contract_types

id increments
timestamps timestamps
softDeletes softDeletes

contract_files

id increments
timestamps timestamps
softDeletes softDeletes

contract_costs

id increments
discount_on_spare_parts float
labor_hourly_cost float
list_code string
timestamps timestamps
softDeletes softDeletes

contract_transfer_costs

id increments
has_km_price boolean
standard_km_price float
standard_fixed_price float
urgent_km_price float
urgent_fixed_price float
included_transfers integer
remaining_transfers integer
timestamps timestamps

contract_checkups

id increments
is_billable boolean
is_guaranteed boolean
guaranteed_checkups integer
remaining_guaranteed_checkups bigInteger
timestamps timestamps
notes text

contract_gifts

id increments
timestamps timestamps
article string
qty string
delivered boolean
notes string

contract_warranties

id increments
standard_warranty_months string
season_warranty_from_one date
season_warranty_to_one decimal
season_warranty_from_two string
season_warranty_to_two string
extended_warranty boolean
timestamps timestamps
ragionare_se_possono_esserci_piu_stagioni string

contract_warranties_articles

id increments
timestamps timestamps
article string
qty string
notes string

contract_billing

id increments
is_periodic boolean
periodic_fee float
periodic_base_fee float
periodic_months_interval integer
is_hourly boolean
hourly_price float
is_short_period boolean
short_period_first_day_cost float
short_period_daily_cost float
prepaid boolean
postpaid boolean
is_redeemable boolean
redemption_price float
is_flexible boolean
timestamps timestamps
softDeletes softDeletes
estimated_usage_hours_fee_period integer
extra_usage_hourly_cost string

contract_services

id increments
timestamps timestamps
has_periodic_checks boolean
periodic_checks_interval integer
period_checks_forewarning_days string
has_labor_hours boolean
has_labor_hourly_limit boolean
labor_hours_limit integer
all_articles boolean
no_articles boolean

contract_periodic_checks_intervals

id increments
timestamps timestamps
softDeletes softDeletes

contract_service_replacement_articles

id increments
timestamps timestamps
article_id integer
notes string
qty integer

contract_excluded_services

id increments
timestamps timestamps
extraordinary_interventions boolean
extraordinary_intervention_hourly_price float
extraordinary_labor_hours boolean
extraordinary_labor_hourly_price float
all_articles boolean
no_articles boolean

contract_excluded_services_replacement_articles

id increments
timestamps timestamps
article_id integer
notes string
qty string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01