|
S
swanside author
I have a Table called reports as in this.
I am going to start a new project using the Calenders, but in the table I have 40 entries.
I want the Calender to pick up these fields in Monthly View
R001, R004 AND R055
Then when the day in the calender is selected, it will show
`Normal_Hours`,
`Time_Half_Hours`,
`Double_Time`,
`Expenses`,
How can I get the Calender to interact with this table please?
Thanks
Paul.
-- phpMyAdmin SQL Dump
-- version 3.1.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 09, 2009 at 12:55 PM
-- Server version: 5.1.34
-- PHP Version: 5.2.9-2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `calender`
--
-- --------------------------------------------------------
--
-- Table structure for table `report`
--
CREATE TABLE IF NOT EXISTS `report` (
`R001` varchar(50) DEFAULT NULL COMMENT 'File No',
`R002` varchar(50) DEFAULT NULL COMMENT 'Customer Name',
`R003` datetime DEFAULT NULL COMMENT 'Date',
`R004` varchar(200) DEFAULT NULL COMMENT 'Order Site Address',
`R005` varchar(3) DEFAULT NULL COMMENT 'Adequate Access',
`R006` varchar(200) DEFAULT NULL COMMENT 'Adequate Access Safety Controls',
`R007` varchar(3) DEFAULT NULL COMMENT 'Air Quality Satisfied',
`R008` varchar(200) DEFAULT NULL COMMENT 'Air Quality Satisfied safety Controls',
`R009` varchar(3) DEFAULT NULL COMMENT 'Electric Isolated',
`R010` varchar(200) DEFAULT NULL COMMENT 'Electric Isolated Safety Controls',
`R011` varchar(3) DEFAULT NULL COMMENT 'Gas Isolated ',
`R012` varchar(200) DEFAULT NULL COMMENT 'Gas Isolated Safety Controls ',
`R013` varchar(3) DEFAULT NULL COMMENT 'Temperature Reasonable ',
`R014` varchar(200) DEFAULT NULL COMMENT 'Temperature Reasonable Safety Controls ',
`R015` varchar(3) DEFAULT NULL COMMENT 'Dangerous Substances ',
`R016` varchar(200) DEFAULT NULL COMMENT 'Dangerous Substances Safety Controls ',
`R017` varchar(30) DEFAULT NULL COMMENT 'Other Risks',
`R018` varchar(200) DEFAULT NULL COMMENT 'Other Risks Safety Controls ',
`R019` varchar(500) DEFAULT NULL COMMENT 'Work Details ',
`R020` varchar(250) DEFAULT NULL COMMENT 'Appliance Details ',
`R021` varchar(200) DEFAULT NULL COMMENT 'Make Of Appliance ',
`R022` varchar(100) DEFAULT NULL COMMENT 'Age',
`R023` varchar(10) DEFAULT NULL COMMENT 'Operating Pressure mb ',
`R024` varchar(10) DEFAULT NULL COMMENT 'Operating_Pressure_Input ',
`R025` varchar(5) DEFAULT NULL COMMENT 'Safety_Device',
`R026` varchar(100) DEFAULT NULL COMMENT 'Air_Supply ',
`R027` varchar(10) DEFAULT NULL COMMENT 'Flue_Flow_Test ',
`R028` varchar(5) DEFAULT NULL COMMENT 'Flue_Spillage',
`R029` varchar(5) DEFAULT NULL COMMENT 'Visual_Check',
`R030` varchar(5) DEFAULT NULL COMMENT 'Serviced_To_Schedule ',
`R031` varchar(10) DEFAULT NULL COMMENT 'Owner_Of_Appliance ',
`R032` varchar(5) DEFAULT NULL COMMENT 'Safe_For_Use',
`R033` varchar(20) DEFAULT NULL COMMENT 'Gas_Soundness',
`R034` varchar(10) DEFAULT NULL COMMENT 'Initial_Test_Pressure',
`R035` varchar(10) DEFAULT NULL COMMENT 'Rest_Pressure_After_Test',
`R036` varchar(10) DEFAULT NULL COMMENT 'Working_Pressure_At_Meter',
`R037` varchar(10) DEFAULT NULL COMMENT 'Installation_Pipework',
`R038` varchar(10) DEFAULT NULL COMMENT 'Is_Installation_Sound',
`R039` varchar(10) DEFAULT NULL COMMENT 'Is_Emergency_Control_Access',
`R040` varchar(10) DEFAULT NULL COMMENT 'Is_Earth_Bonding_Correct',
`R041` varchar(5) DEFAULT NULL COMMENT 'Warning_Notices_Raised',
`R042` varchar(10) DEFAULT NULL COMMENT 'Is_Installation_Safe',
`R043` varchar(20) DEFAULT NULL COMMENT 'Electrical_Test',
`R044` varchar(10) DEFAULT NULL COMMENT 'Earth_Cont',
`R045` varchar(10) DEFAULT NULL COMMENT 'IR_Phase_To_Earth',
`R046` varchar(10) DEFAULT NULL COMMENT 'IR_Neutral_To_Earth',
`R047` varchar(10) DEFAULT NULL COMMENT 'Phase_To_Earth_Loop_Impeadence',
`R048` varchar(5) DEFAULT NULL COMMENT 'Polarity',
`R049` varchar(5) DEFAULT NULL COMMENT 'Rccd_Operation',
`R050` varchar(5) DEFAULT NULL COMMENT 'Correct_Fuse',
`R051` varchar(1000) DEFAULT NULL COMMENT 'Work_Carried_Out',
`R052` varchar(1000) DEFAULT NULL COMMENT 'Materials_Used',
`R053` longtext COMMENT 'Customer_Signature',
`R054` varchar(100) DEFAULT NULL COMMENT 'Customer_Surname',
`R055` varchar(100) DEFAULT NULL COMMENT 'Engineers_Name',
`R056` longtext COMMENT 'Engineers_Signature',
`R057` varchar(10) DEFAULT NULL COMMENT 'Boiler_Flues_Cleaned',
`R058` varchar(10) DEFAULT NULL COMMENT 'Flue_Correctly_Sealed',
`R059` varchar(10) DEFAULT NULL COMMENT 'Burner_Stripped_And_Serviced',
`R060` varchar(10) DEFAULT NULL COMMENT 'Combustion_Chambers_Cleaned',
`R061` varchar(10) DEFAULT NULL COMMENT 'Retarders_Correctly_Fitted',
`R062` varchar(10) DEFAULT NULL COMMENT 'Heating_And_Primary_Pumps_Tested',
`R063` varchar(10) DEFAULT NULL COMMENT 'Secondary_Hot_Water_Pumps_Tested',
`R064` varchar(10) DEFAULT NULL COMMENT 'Boiler_Controls_Tested',
`R065` varchar(10) DEFAULT NULL COMMENT 'Nozzel_Correct_Size',
`R066` varchar(10) DEFAULT NULL COMMENT 'Fire_Valve_Tested',
`R067` varchar(10) DEFAULT NULL COMMENT 'Output_BTUS_Kw',
`R068` varchar(10) DEFAULT NULL COMMENT 'CO_CO2_Ratio',
`R069` varchar(10) DEFAULT NULL COMMENT 'CO_ppm',
`R070` varchar(10) DEFAULT NULL COMMENT 'CO2%',
`R071` varchar(10) DEFAULT NULL COMMENT 'O2%',
`R072` varchar(10) DEFAULT NULL COMMENT 'Flue_Temperature_C',
`R073` varchar(10) DEFAULT NULL COMMENT 'Efficiency%',
`R074` varchar(200) DEFAULT NULL COMMENT 'Appliances_Other_Than_Boilers_Overhauled',
`R075` varchar(500) DEFAULT NULL COMMENT 'Defects_Noted_Faults_Found',
`R076` varchar(10) DEFAULT NULL COMMENT 'Gas_Type',
`R077` varchar(100) DEFAULT NULL COMMENT 'Model_No',
`R078` varchar(100) DEFAULT NULL COMMENT 'Serial_No',
`R079` varchar(250) DEFAULT NULL COMMENT 'Departures_From_17th_Edition',
`R080` varchar(250) DEFAULT NULL COMMENT 'Method_Of_Protection_Against_Indirect_Contact',
`R081` varchar(10) DEFAULT NULL COMMENT 'Earthing',
`R082` varchar(10) DEFAULT NULL COMMENT 'Main_Equipotential_Bonding',
`R083` varchar(250) DEFAULT NULL COMMENT 'Comments_On_Exsisting_Installation',
`R084` varchar(250) DEFAULT NULL COMMENT 'Other',
`R085` varchar(10) DEFAULT NULL COMMENT 'Attendance_1_Time_In',
`R086` varchar(10) DEFAULT NULL COMMENT 'Attendance_1_Time_Out',
`R087` varchar(10) DEFAULT NULL COMMENT 'Attendance_2_Time_In',
`R088` varchar(10) DEFAULT NULL COMMENT 'Attendance_2_Time_',
`R089` varchar(10) DEFAULT NULL COMMENT 'Attendance_3_Time_In',
`R090` varchar(10) DEFAULT NULL COMMENT 'Attendance_3_Time_Out',
`R091` varchar(20) DEFAULT NULL COMMENT 'IQ_Unit_Details',
`R092` varchar(10) DEFAULT NULL COMMENT 'Control_Panel',
`R093` varchar(10) DEFAULT NULL COMMENT 'Trend_Relays',
`R094` varchar(10) DEFAULT NULL COMMENT 'Zone_Valves',
`R095` varchar(10) DEFAULT NULL COMMENT 'Trend_Sensors',
`R096` varchar(10) DEFAULT NULL COMMENT 'Time_Settings',
`R097` varchar(10) DEFAULT NULL COMMENT ' IQ_Unit_Operation ',
`R098` varchar(10) DEFAULT NULL COMMENT 'IQ_Unit_Modem',
`R099` varchar(10) DEFAULT NULL COMMENT '3_Port_Valve',
`R100` varchar(10) DEFAULT NULL COMMENT 'Boiler_Sequencing',
`R101` varchar(10) DEFAULT NULL COMMENT 'Frost_Protection',
`R102` varchar(10) DEFAULT NULL COMMENT 'Compensation_Circuit',
`R103` varchar(10) DEFAULT NULL COMMENT 'Optimisation_Circuit',
`R104` varchar(10) DEFAULT NULL COMMENT 'British_Summer_Time',
`R105` varchar(200) DEFAULT NULL COMMENT 'Setpoints_Altered_From_SET_Stratagey',
`R106` varchar(200) DEFAULT NULL COMMENT 'Notes',
`R107` varchar(100) DEFAULT NULL COMMENT 'AHU_Details',
`R108` varchar(10) DEFAULT NULL COMMENT 'Filters_Changed',
`R109` varchar(10) DEFAULT NULL COMMENT 'Heat_Ex_Cleaned',
`R110` varchar(10) DEFAULT NULL COMMENT 'Damper_Motors',
`R111` varchar(10) DEFAULT NULL COMMENT 'Pressure_Switches',
`R112` varchar(10) DEFAULT NULL COMMENT 'Local_Isolation',
`R113` varchar(10) DEFAULT NULL COMMENT 'Belts_Changed',
`R114` varchar(10) DEFAULT NULL COMMENT 'Supply_Air_Fan',
`R115` varchar(10) DEFAULT NULL COMMENT 'Exhaust_Air_Fan',
`R116` varchar(10) DEFAULT NULL COMMENT 'Covers_Secure',
`R117` varchar(10) DEFAULT NULL COMMENT 'AHU_Functional',
`R118` varchar(200) DEFAULT NULL COMMENT 'Filter_Sizes',
`R119` varchar(10) DEFAULT NULL COMMENT 'Is_There_A_Canopy',
`R120` varchar(10) DEFAULT NULL COMMENT 'Is_It_Made_From_Stainless_Steel',
`R121` varchar(10) DEFAULT NULL COMMENT 'Is_Gas_Pipe_Clipped_Correctly',
`R122` varchar(10) DEFAULT NULL COMMENT 'Is_Gas_Pipe_Sleeved_Through_Walls',
`R123` varchar(10) DEFAULT NULL COMMENT 'Is_Gas_Pipe_Correctly_Identified',
`R124` varchar(10) DEFAULT NULL COMMENT 'Is_Mech_Vent_Interlocked',
`R125` varchar(10) DEFAULT NULL COMMENT 'Label_On_Control',
`R126` varchar(10) DEFAULT NULL COMMENT 'Control_Installed_Correctly',
`R127` varchar(10) DEFAULT NULL COMMENT 'Gas_Test_Point_Present',
`R128` varchar(10) DEFAULT NULL COMMENT 'Applied_Let_By_Test',
`R129` varchar(10) DEFAULT NULL COMMENT 'Let_By_Satisfactory',
`R130` varchar(10) DEFAULT NULL COMMENT 'Applied_Test_Pressure',
`R131` varchar(10) DEFAULT NULL COMMENT 'Pressure_Test_Results_Satisfactory',
`R132` varchar(10) DEFAULT NULL COMMENT 'Gas_Pipework_Volume_For_Kitchen',
`R133` varchar(10) DEFAULT NULL COMMENT 'Does_Appliance_Have_Visible_CE_Or_ID_Mark',
`R134` varchar(10) DEFAULT NULL COMMENT 'Is_There_A_Readable_Maunfacturers_Data_Plate',
`R135` varchar(10) DEFAULT NULL COMMENT 'Are_There_Any_User_Instructions_With_Appliance',
`R136` varchar(10) DEFAULT NULL COMMENT 'Is_The_Appliance_Fitted_With_Local_Electrical_Isolation',
`R137` varchar(10) DEFAULT NULL COMMENT 'Can_The_Electrical_Isolator_Be_Easily_Accessed',
`R138` varchar(10) DEFAULT NULL COMMENT 'Is_The_Appliance_Fitted_With_Local_Gas_Isolation',
`R139` varchar(10) DEFAULT NULL COMMENT 'Can_The_Gas_Appliance_Be_Easily_Accessed',
`R140` varchar(10) DEFAULT NULL COMMENT 'Is_There_A_Sufficent_Canopy_For_The_Appliance',
`R141` varchar(10) DEFAULT NULL COMMENT 'Are_The_Gas_Connections_Correct_Type',
`R142` varchar(10) DEFAULT NULL COMMENT 'Is_There_A_Hot_Surface_Notice',
`R143` varchar(10) DEFAULT NULL COMMENT 'Are_There_Any_Signs_Of_Heat_Distress',
`R144` varchar(10) DEFAULT NULL COMMENT 'Does_The_Appliance_Have_An_Overheat',
`R145` varchar(10) DEFAULT NULL COMMENT 'Does_The_Overheat_Work',
`R146` varchar(10) DEFAULT NULL COMMENT 'Is_The_Appliance_Fixed_To_The_Floor',
`R147` varchar(10) DEFAULT NULL COMMENT 'Is_There_An_RCCD',
`R148` varchar(10) DEFAULT NULL COMMENT 'FFD_For_Appliance',
`R149` varchar(10) DEFAULT NULL COMMENT 'FFD_Working',
`R150` varchar(10) DEFAULT NULL COMMENT 'Flue_For_Appliance',
`R151` varchar(10) DEFAULT NULL COMMENT 'Flue_Operating',
`R152` varchar(10) DEFAULT NULL COMMENT 'Burners_Clean',
`R153` varchar(10) DEFAULT NULL COMMENT 'Pilot_Assembly_In_Good_Order',
`R154` varchar(10) DEFAULT NULL COMMENT 'Retaining_Chain_Present',
`R155` varchar(10) DEFAULT NULL COMMENT 'Gas_Governor_For_Appliance',
`R156` varchar(10) DEFAULT NULL COMMENT 'Appliance_Standing_Pressure',
`R157` varchar(10) DEFAULT NULL COMMENT 'Appliance_Working_Pressure',
`R158` varchar(10) DEFAULT NULL COMMENT 'Observations_Of_Appliance',
`R159` varchar(10) DEFAULT NULL COMMENT 'Is_A_Sight_Glass_Fitted',
`R160` varchar(10) DEFAULT NULL COMMENT 'If_Yes_State_Colour',
`R161` varchar(10) DEFAULT NULL COMMENT ' Is_The_Condenser_Clean ',
`R162` varchar(10) DEFAULT NULL COMMENT 'Is_The_Evaporator_Clean',
`R163` varchar(10) DEFAULT NULL COMMENT 'Is_There_A_Filter_Dryer_Fitted',
`R164` varchar(10) DEFAULT NULL COMMENT 'Are_All_Rotating_Parts_Covered',
`R165` varchar(10) DEFAULT NULL COMMENT 'Does_The_Appliance_Have_An_Over_Pressure_Safety_Device',
`R166` varchar(10) DEFAULT NULL COMMENT 'Are_The_LP_And_HP_Switches_Working',
`R167` varchar(10) DEFAULT NULL COMMENT 'Check_Ref_Charge',
`R168` varchar(10) DEFAULT NULL COMMENT 'Test_For_Leaks',
`R169` varchar(10) DEFAULT NULL COMMENT 'Clean_Filters',
`R170` varchar(10) DEFAULT NULL COMMENT 'Clean_Condenser',
`R171` varchar(10) DEFAULT NULL COMMENT 'Units_In_Good_Order',
`R172` varchar(10) DEFAULT NULL COMMENT 'Check_Condense_Pump',
`R173` varchar(10) DEFAULT NULL COMMENT 'Is_Unit_Under_BMS_Control',
`R174` varchar(10) DEFAULT NULL COMMENT 'Suction_Pressure',
`R175` varchar(10) DEFAULT NULL COMMENT 'High_Pressure',
`externalPK` varchar(50) DEFAULT NULL,
`customerPK` varchar(100) DEFAULT NULL,
`locationPK` varchar(100) DEFAULT NULL,
`userPK` varchar(100) DEFAULT NULL,
`template` varchar(100) DEFAULT NULL,
`formDate` datetime DEFAULT NULL,
`dateTimeStarted` datetime DEFAULT NULL,
`dateTimeMobileReleased` datetime DEFAULT NULL,
`currentStatus` varchar(100) DEFAULT NULL,
`reportGuid` varchar(200) NOT NULL,
`Normal_Hours` double DEFAULT NULL,
`Time_Half_Hours` double DEFAULT NULL,
`Double_Time` double DEFAULT NULL,
`Expenses` double DEFAULT NULL,
`R176` varchar(100) DEFAULT NULL COMMENT 'Job Status',
`R177` varchar(10) DEFAULT NULL COMMENT 'Number Of Stages',
`R178` varchar(10) DEFAULT NULL COMMENT 'Stage 2 Gas Pressure mb',
`R179` varchar(10) DEFAULT NULL COMMENT 'Stage 2 Co/Co2%',
`R180` varchar(10) DEFAULT NULL COMMENT 'Stage 2 Co ppm',
`R181` varchar(10) DEFAULT NULL COMMENT 'Stage 2 Co2%',
`R182` varchar(10) DEFAULT NULL COMMENT 'Stage 2 O2%',
`R183` varchar(10) DEFAULT NULL COMMENT 'Stage 2 Flue Temperature C',
`R184` varchar(10) DEFAULT NULL COMMENT 'Stage 2 Efficiency %',
`R185` varchar(10) DEFAULT NULL COMMENT 'Stage 3 Gas Pressure mb',
`R186` varchar(10) DEFAULT NULL COMMENT 'Stage 3 Co/Co2%',
`R187` varchar(10) DEFAULT NULL COMMENT 'Stage 3 Co ppm',
`R188` varchar(10) DEFAULT NULL COMMENT 'Stage 3 Co2%',
`R189` varchar(10) DEFAULT NULL COMMENT 'Stage 3 O2%',
`R190` varchar(10) DEFAULT NULL COMMENT 'Stage 3 Flue Temperature C',
`R191` varchar(10) DEFAULT NULL COMMENT 'Stage 3 Efficiency %',
`R192` varchar(10) DEFAULT NULL COMMENT 'Stage 4 Gas Pressure mb',
`R193` varchar(10) DEFAULT NULL COMMENT 'Stage 4 Co/Co2%',
`R194` varchar(10) DEFAULT NULL COMMENT 'Stage 4 Co ppm',
`R195` varchar(10) DEFAULT NULL COMMENT 'Stage 4 Co2%',
`R196` varchar(10) DEFAULT NULL COMMENT 'Stage 4 O2%',
`R197` varchar(10) DEFAULT NULL COMMENT 'Stage 4 Flue Temperature C',
`R198` varchar(10) DEFAULT NULL COMMENT 'Stage 4 Efficiency %',
`R199` varchar(10) DEFAULT NULL COMMENT 'Stage 5 Gas Pressure mb',
`R200` varchar(10) DEFAULT NULL COMMENT 'Stage 5 Co/Co2%',
`R201` varchar(10) DEFAULT NULL COMMENT 'Stage 5 Co ppm',
`R202` varchar(10) DEFAULT NULL COMMENT 'Stage 5 Co2%',
`R203` varchar(10) DEFAULT NULL COMMENT 'Stage 5 O2%',
`R204` varchar(10) DEFAULT NULL COMMENT 'Stage 5 Flue Temperature C',
`R205` varchar(10) DEFAULT NULL COMMENT 'Stage 5 Efficiency %',
`R206` varchar(10) DEFAULT NULL COMMENT 'Stage 6 Gas Pressure mb',
`R207` varchar(10) DEFAULT NULL COMMENT 'Stage 6 Co/Co2%',
`R208` varchar(10) DEFAULT NULL COMMENT 'Stage 6 Co ppm',
`R209` varchar(10) DEFAULT NULL COMMENT 'Stage 6 Co2%',
`R210` varchar(10) DEFAULT NULL COMMENT 'Stage 6 O2%',
`R211` varchar(10) DEFAULT NULL COMMENT 'Stage 6 Flue Temperature C',
`R212` varchar(10) DEFAULT NULL COMMENT 'Stage 6 Efficiency %',
`R213` varchar(10) DEFAULT NULL COMMENT 'Stage 7 Gas Pressure mb',
`R214` varchar(10) DEFAULT NULL COMMENT 'Stage 7 Co/Co2%',
`R215` varchar(10) DEFAULT NULL COMMENT 'Stage 7 Co ppm',
`R216` varchar(10) DEFAULT NULL COMMENT 'Stage 7 Co2%',
`R217` varchar(10) DEFAULT NULL COMMENT 'Stage 7 O2%',
`R218` varchar(10) DEFAULT NULL COMMENT 'Stage 7 Flue Temperature C',
`R219` varchar(10) DEFAULT NULL COMMENT 'Stage 7 Efficiency %',
`R220` varchar(10) DEFAULT NULL COMMENT 'Stage 8 Gas Pressure mb',
`R221` varchar(10) DEFAULT NULL COMMENT 'Stage 8 Co/Co2%',
`R222` varchar(10) DEFAULT NULL COMMENT 'Stage 8 Co ppm',
`R223` varchar(10) DEFAULT NULL COMMENT 'Stage 8 Co2%',
`R224` varchar(10) DEFAULT NULL COMMENT 'Stage 8 O2%',
`R225` varchar(10) DEFAULT NULL COMMENT 'Stage 8 Flue Temperature C',
`R226` varchar(10) DEFAULT NULL COMMENT 'Stage 8 Efficiency %',
`R227` varchar(10) DEFAULT NULL COMMENT 'Stage 9 Gas Pressure mb',
`R228` varchar(10) DEFAULT NULL COMMENT 'Stage 9 Co/Co2%',
`R229` varchar(10) DEFAULT NULL COMMENT 'Stage 9 Co ppm',
`R230` varchar(10) DEFAULT NULL COMMENT 'Stage 9 Co2%',
`R231` varchar(10) DEFAULT NULL COMMENT 'Stage 9 O2%',
`R232` varchar(10) DEFAULT NULL COMMENT 'Stage 9 Flue Temperature C',
`R233` varchar(10) DEFAULT NULL COMMENT 'Stage 9 Efficiency %',
`R234` varchar(10) DEFAULT NULL COMMENT 'Stage 10 Gas Pressure mb',
`R235` varchar(10) DEFAULT NULL COMMENT 'Stage 10 Co/Co2%',
`R236` varchar(10) DEFAULT NULL COMMENT 'Stage 10 Co ppm',
`R237` varchar(10) DEFAULT NULL COMMENT 'Stage 10 Co2%',
`R238` varchar(10) DEFAULT NULL COMMENT 'Stage 10 O2%',
`R239` varchar(10) DEFAULT NULL COMMENT 'Stage 10 Flue Temperature C',
`R240` varchar(10) DEFAULT NULL COMMENT 'Stage 10 Efficiency %',
`R241` varchar(10) DEFAULT NULL COMMENT 'Deareator Make',
`R242` varchar(10) DEFAULT NULL COMMENT 'Deareator Model',
`R243` varchar(10) DEFAULT NULL COMMENT 'Deareator Seriel',
`R244` varchar(10) DEFAULT NULL COMMENT 'Deareator Guarantee No',
`Photo` longtext,
`Job_No` varchar(50) NOT NULL,
`R245` varchar(30) DEFAULT NULL COMMENT 'Deareator Art no',
`R246` varchar(30) DEFAULT NULL COMMENT 'Deareator Year Of Manufacture',
`R247` varchar(30) DEFAULT NULL COMMENT 'Deareator Capacitiy Litres',
`R248` varchar(30) DEFAULT NULL COMMENT 'Deareator Maximum Temp',
`R249` varchar(30) DEFAULT NULL COMMENT 'Deareator Maximum Pressure',
`R250` varchar(30) DEFAULT NULL COMMENT 'Deareator Pipe Size',
`R251` varchar(30) DEFAULT NULL COMMENT 'Deareator Flanged or Screwed',
`R252` varchar(30) DEFAULT NULL COMMENT 'Deareator Asset Number',
`R253` varchar(30) DEFAULT NULL COMMENT 'CWBS Make',
`R254` varchar(30) DEFAULT NULL COMMENT 'CWBS Model',
`R255` varchar(30) DEFAULT NULL COMMENT 'CWBS Serial No',
`R256` varchar(30) DEFAULT NULL COMMENT 'CWBS Pump Model',
`R257` varchar(30) DEFAULT NULL COMMENT 'CWBS Pump Voltage',
`R258` varchar(30) DEFAULT NULL COMMENT 'CWBS pump RPM',
`R259` varchar(30) DEFAULT NULL COMMENT 'CWBS Vessel Model',
`R260` varchar(30) DEFAULT NULL COMMENT 'CWBS Vessel Capacity Litres',
`R261` varchar(30) DEFAULT NULL COMMENT 'CWBS Vessel Precharge Pressure',
`R262` varchar(30) DEFAULT NULL COMMENT 'CWBS Vessel actual Pressure',
`R263` varchar(30) DEFAULT NULL COMMENT 'CWBS Asset No',
`R264` varchar(30) DEFAULT NULL COMMENT 'Dosing Pot ',
`R265` varchar(30) DEFAULT NULL COMMENT 'Dosing Pot ',
`R266` varchar(30) DEFAULT NULL COMMENT 'Dosing Pot ',
`R267` varchar(30) DEFAULT NULL COMMENT 'Dosing Pot ',
`R268` varchar(30) DEFAULT NULL COMMENT 'Dosing Pot ',
`R269` varchar(30) DEFAULT NULL COMMENT 'Dosing Pot ',
`R270` varchar(30) DEFAULT NULL COMMENT 'Dosing Pot ',
`R271` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 1 Make',
`R272` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 1 Model (Code) ',
`R273` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 1 Serial Number',
`R274` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 1 Capacity (Litres)',
`R275` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 1 Maximum Pressure',
`R276` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 1 Precharge Pressure',
`R277` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 1 Actual Pressure',
`R278` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 1 Asset No',
`R279` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 2 Make',
`R280` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 2 Model (Code) ',
`R281` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 2 Serial Number',
`R282` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 2 Capacity (Litres)',
`R283` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 2 Maximum Pressure',
`R284` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 2 Precharge Pressure',
`R285` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 2 Actual Pressure',
`R286` varchar(30) DEFAULT NULL COMMENT 'DHW Pressure Vessel 2 Asset No',
`R287` varchar(30) DEFAULT NULL COMMENT 'Gas Sol Valve Make',
`R288` varchar(30) DEFAULT NULL COMMENT 'Gas Sol Valve Model',
`R289` varchar(30) DEFAULT NULL COMMENT 'Gas Sol Valve Serial No',
`R290` varchar(30) DEFAULT NULL COMMENT 'Gas Sol Valve Voltage',
`R291` varchar(30) DEFAULT NULL COMMENT 'Gas Sol Valve Pipe Size',
`R292` varchar(30) DEFAULT NULL COMMENT 'Gas Sol Valve Asset No',
`R293` varchar(30) DEFAULT NULL COMMENT 'Flue Dilution Fan Make',
`R294` varchar(30) DEFAULT NULL COMMENT 'Flue Dilution Fan Model',
`R295` varchar(30) DEFAULT NULL COMMENT 'Flue Dilution Fan Serial No',
`R296` varchar(30) DEFAULT NULL COMMENT 'Flue Dilution Fan Voltage',
`R297` varchar(30) DEFAULT NULL COMMENT 'Flue Dilution Fan Asset No',
`R298` varchar(10) DEFAULT NULL COMMENT 'Additional Time For Apprentice / Labourer',
`R299` varchar(30) DEFAULT NULL COMMENT 'Assistants Name',
`R300` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Make',
`R301` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Model',
`R302` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Serial No',
`R303` varchar(30) DEFAULT NULL COMMENT 'Pressure Set WO No',
`R304` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Code',
`R305` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Voltage',
`R306` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Cold Fill Pressure',
`R307` varchar(30) DEFAULT NULL COMMENT 'Pressure Set High Pressure',
`R308` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Low Pressure',
`R309` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Differential',
`R310` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Working Pressure',
`R311` varchar(30) DEFAULT NULL COMMENT 'Pressure Set FFLoop',
`R312` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Single or Twin Pump',
`R313` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Pump Make',
`R314` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Pump Model',
`R315` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Pump Serial',
`R316` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Pump RPM',
`R317` varchar(30) DEFAULT NULL COMMENT 'Pressure Set Pump Voltage',
`R318` varchar(10) DEFAULT NULL COMMENT 'Internal Pressure Vessal Make',
`R319` varchar(10) DEFAULT NULL COMMENT 'Internal Pressure Vessal Model',
`R320` varchar(10) DEFAULT NULL COMMENT 'Internal Pressure Vessal Serial No',
`R321` varchar(10) DEFAULT NULL COMMENT 'Internal Pressure Vessal Capacity Litres',
`R322` varchar(10) DEFAULT NULL COMMENT 'Internal Pressure Vessal Maximum Temperature',
`R323` varchar(10) DEFAULT NULL COMMENT 'Internal Pressure Vessal maximum Pressure',
`R324` varchar(10) DEFAULT NULL COMMENT 'Internal Pressure Vessal Precharge Pressure',
`R325` varchar(10) DEFAULT NULL COMMENT 'Internal Pressure Vessal Actual Pressure',
`R326` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No1 Make',
`R327` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No1 Model',
`R328` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No1 Serial No',
`R329` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No1 Capacity Litres',
`R330` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No1 Maximum Temp',
`R331` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No1 Maximum Pressure',
`R332` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No1 Precharge Pressure',
`R333` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No1 Actual Pressure',
`R334` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No2 Make',
`R335` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No2 Model',
`R336` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No2 Serial No',
`R337` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No2 Capacity Litres',
`R338` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No2 Maximum Temp',
`R339` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 2 Maximum Pressure',
`R340` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 2 Precharge Pressure',
`R341` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 2 Actual Pressure',
`R342` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 3 Make',
`R343` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 3 Model',
`R344` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 3 Serial No',
`R345` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 3 Capacity Litres',
`R346` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 3 Maximum Temp',
`R347` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 3 Maximum Pressure',
`R348` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 3 Precharge Pressure',
`R349` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 3 Actual Pressure',
`R350` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 4 Make',
`R351` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 4 Model',
`R352` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 4 Serial No',
`R353` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 4 Capacity Litres',
`R354` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 4 Maximum Temp',
`R355` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 4 Maximum Pressure',
`R356` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 4 Precharge Pressure',
`R357` varchar(10) DEFAULT NULL COMMENT 'External Pressure Vessel No 4 Actual Pressure',
`R358` varchar(10) DEFAULT NULL COMMENT 'Minor Works System Type',
`R359` varchar(10) DEFAULT NULL COMMENT 'Minor Works Overcurent Protective Device BS',
`R360` varchar(10) DEFAULT NULL COMMENT 'Minor Works Overcurent Protective Device Type',
`R361` varchar(10) DEFAULT NULL COMMENT 'Minor Works Overcurent Protective Device Rating',
`R362` varchar(10) DEFAULT NULL COMMENT 'Minor Works RCD BS',
`R363` varchar(10) DEFAULT NULL COMMENT 'Minor Works RCD Type',
`R364` varchar(10) DEFAULT NULL COMMENT 'Minor Works RCD Tripping Current',
`R365` varchar(10) DEFAULT NULL COMMENT 'Minor Works Details Of Modified Circuit',
`R366` varchar(10) DEFAULT NULL COMMENT 'Minor Works Reference Method',
`R367` varchar(10) DEFAULT NULL COMMENT 'Minor Works CSA of Lives',
`R368` varchar(10) DEFAULT NULL COMMENT 'Minor Works CSA of CPC',
`R369` varchar(10) DEFAULT NULL COMMENT 'Minor Works Maximum DIsconnection Time',
`R370` varchar(10) DEFAULT NULL COMMENT 'Minor Works Max Zs',
`R371` varchar(5) DEFAULT NULL COMMENT 'Minor Works Confirmation',
`R372` varchar(10) DEFAULT NULL COMMENT 'Minor Works R1 + R2',
`R373` varchar(10) DEFAULT NULL COMMENT 'Minor Works R2',
`R374` varchar(10) DEFAULT NULL COMMENT 'Minor Works IR Line/Line',
`R375` varchar(10) DEFAULT NULL COMMENT 'Minor Works IR Line/Neutral',
`R376` varchar(10) DEFAULT NULL COMMENT 'Minor Works RCD Operating Time 1x',
`R377` varchar(10) DEFAULT NULL COMMENT 'Minor Works RCD Operating Time 5x',
`R378` varchar(20) DEFAULT NULL COMMENT 'Minor Works IEE Regs date',
`R379` varchar(20) DEFAULT NULL COMMENT 'Minor Works Position',
`R380` varchar(200) DEFAULT NULL COMMENT 'Minor Works Comments on Existing Installation',
`R381` varchar(100) DEFAULT NULL COMMENT 'Minor Works Agreed Limitations',
`R382` varchar(10) DEFAULT NULL COMMENT 'Minor Works Confirmation Of Earthing',
`R383` varchar(10) DEFAULT NULL COMMENT 'Minor Works Confirmation Of Bonding',
`R384` varchar(10) DEFAULT NULL COMMENT 'Minor Works Confirmation Of Polarity',
PRIMARY KEY (`reportGuid`,`Job_No`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|