Module: PresetJobsHelper

Defined in:

app/helpers/preset_jobs_helper.rb

Overview

== Schema Information

Table name: service_jobs

id :integer not null, primary key
measurecomp_job_number :string(255)
customer_id :integer
address_id :integer
cross_street1 :string(255)
cross_street2 :string(255)
cross_street1_direction :string(255)
cross_street2_direction :string(255)
home_phone_contact_point_id :integer
cell_phone_contact_point_id :integer
business_phone_contact_point_id :integer
estimated_size_sqft :float
job_date :datetime
measurecomp_order_number :string(255)
job_comments :string(255)
state :string(255)
creator_id :integer
updater_id :integer
created_at :datetime
updated_at :datetime
reference_number :string(255)
serial_number :string(255)
tstat_count :integer
type :string(255)
order_id :integer
email_contact_point_id :integer
delivery_id :integer
display_format_celsius :boolean default(FALSE), not null
early_start :boolean default(TRUE), not null
temperature_control_mode :string(255) default("F"), not null
temperature_comfort :integer default(82), not null
temperature_economy :integer default(68), not null
temperature_vacation :integer default(50), not null
monday_periods_hour :integer default(["6", "8", "17", "23"]), is an Array
monday_periods_minute :integer default(["0", "30", "0", "0"]), is an Array
is_specified :boolean default(FALSE), not null
line_item_id :integer
monday_periods :string(255) default([""6:00"", ""8:30"", ""17:00"", ""23:00""]), is an Array
tuesday_periods :string(255) default([""6:00"", ""8:30"", ""17:00"", ""23:00""]), is an Array
wednesday_periods :string(255) default([""6:00"", ""8:30"", ""17:00"", ""23:00""]), is an Array
thursday_periods :string(255) default([""6:00"", ""8:30"", ""17:00"", ""23:00""]), is an Array
friday_periods :string(255) default([""6:00"", ""8:30"", ""17:00"", ""23:00""]), is an Array
saturday_periods :string(255) default([""6:00"", "NULL", "NULL", ""23:00""]), is an Array
sunday_periods :string(255) default([""6:00"", "NULL", "NULL", ""23:00""]), is an Array
floor_temperature_max :integer default(82), not null
floor_temperature_min :integer default(41), not null
completed_on :date
contact_id :integer