-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `rlfdata`
--

-- --------------------------------------------------------

--
-- Table structure for table `frame_type`
--

CREATE TABLE `frame_type` (
  `id` int(6) NOT NULL,
  `Glazing Type` varchar(26) DEFAULT NULL,
  `Aluminum operable` decimal(3,2) DEFAULT NULL,
  `Aluminum with Thermal Break` decimal(3,2) DEFAULT NULL,
  `Reinforced Vinyl/Aluminum Clad Wood operable` decimal(3,2) DEFAULT NULL,
  `Wood/Vinyl operable` decimal(3,2) DEFAULT NULL,
  `Insulated Fiberglass/Viny operable` decimal(3,2) DEFAULT NULL,
  `Aluminum Fixed` decimal(3,2) DEFAULT NULL,
  `Aluminum with Thermal Break  Fixed` decimal(3,2) DEFAULT NULL,
  `Reinforced Vinyl/Aluminum Clad Wood Fixed` decimal(3,2) DEFAULT NULL,
  `Wood/Vinyl  Fixed` decimal(3,2) DEFAULT NULL,
  `Insulated Fiberglass/Viny  Fixed` decimal(3,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frame_type`
--

INSERT INTO `frame_type` (`id`, `Glazing Type`, `Aluminum operable`, `Aluminum with Thermal Break`, `Reinforced Vinyl/Aluminum Clad Wood operable`, `Wood/Vinyl operable`, `Insulated Fiberglass/Viny operable`, `Aluminum Fixed`, `Aluminum with Thermal Break  Fixed`, `Reinforced Vinyl/Aluminum Clad Wood Fixed`, `Wood/Vinyl  Fixed`, `Insulated Fiberglass/Viny  Fixed`) VALUES
(1, 'Clear 1 Layer', '7.24', '6.12', '5.14', '5.05', '4.61', '6.42', '6.07', '5.55', '5.55', '5.35'),
(2, 'Clear 2 Layer', '4.62', '3.42', '3.00', '2.87', '5.83', '3.61', '3.22', '2.86', '2.84', '2.72'),
(3, 'Clear 3 Layer', '3.80', '2.60', '2.25', '2.19', '1.91', '2.76', '2.39', '2.05', '2.01', '1.93'),
(4, 'Low-e, low-solar 2 layer', '3.83', '2.68', '2.33', '2.21', '1.89', '2.75', '2.36', '2.03', '2.01', '1.90'),
(5, 'Low-e, low-solar 3 layer', '3.22', '2.07', '1.76', '1.71', '1.45', '2.13', '1.76', '1.44', '1.40', '1.33'),
(6, 'Low-e, high-solar 2 layer', '4.05', '2.89', '2.52', '2.39', '2.07', '2.99', '2.60', '2.26', '2.24', '2.13'),
(7, 'Low-e, high -solar 3-layer', '3.54', '2.36', '2.02', '1.97', '1.70', '2.47', '2.10', '1.77', '1.73', '1.66'),
(8, 'Heat-absorbing 1-layer', '7.24', '6.12', '5.14', '5.05', '4.61', '6.42', '6.07', '5.55', '5.55', '5.35'),
(9, 'Heat-absorbing 2-layer', '4.62', '3.42', '3.00', '2.87', '2.53', '3.61', '3.22', '2.86', '2.84', '2.72'),
(10, 'Heat-absorbing 3-layer', '3.80', '2.60', '2.25', '2.19', '1.91', '2.76', '2.39', '2.05', '2.01', '1.93'),
(11, 'Reflective 1-layer', '7.24', '6.12', '5.14', '5.05', '4.61', '6.42', '6.07', '5.55', '5.55', '5.35'),
(12, 'Reflective 2-layer', '4.62', '3.42', '3.00', '2.87', '2.53', '3.61', '3.22', '2.86', '2.84', '2.72'),
(13, 'Reflective 3-layer', '3.80', '2.60', '2.25', '2.19', '1.91', '2.76', '2.39', '2.05', '2.01', '1.93');

-- --------------------------------------------------------

--
-- Table structure for table `iacl`
--

CREATE TABLE `iacl` (
  `id` int(6) NOT NULL,
  `Glazing Type` varchar(26) DEFAULT NULL,
  `Drapes- open Weave Light` decimal(3,2) DEFAULT NULL,
  `Drapes- Closed Weave Dark` decimal(3,2) DEFAULT NULL,
  `Drapes- Closed Weave Light` decimal(3,2) DEFAULT NULL,
  `Roller Shades opaque Dark` decimal(3,2) DEFAULT NULL,
  `Roller Shades Transluscent light` decimal(3,2) DEFAULT NULL,
  `Roller Shades opaque light` decimal(3,2) DEFAULT NULL,
  `Blinds Medium` decimal(3,2) DEFAULT NULL,
  `Blinds White` decimal(3,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `iacl`
--

INSERT INTO `iacl` (`id`, `Glazing Type`, `Drapes- open Weave Light`, `Drapes- Closed Weave Dark`, `Drapes- Closed Weave Light`, `Roller Shades opaque Dark`, `Roller Shades Transluscent light`, `Roller Shades opaque light`, `Blinds Medium`, `Blinds White`) VALUES
(1, 'Clear 1 Layer', '0.64', '0.71', '0.45', '0.64', '0.34', '0.44', '0.74', '0.66'),
(2, 'Clear 2 Layer', '0.72', '0.81', '0.57', '0.76', '0.48', '0.55', '0.82', '0.74'),
(3, 'Clear 3 Layer', '0.72', '0.81', '0.57', '0.76', '0.48', '0.55', '0.82', '0.74'),
(4, 'Low-e, low-solar 2 layer', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00'),
(5, 'Low-e, low-solar 3 layer', '0.79', '0.88', '0.68', '0.85', '0.60', '0.66', '0.88', '0.82'),
(6, 'Low-e, high-solar 2 layer', '0.76', '0.86', '0.64', '0.82', '0.57', '0.62', '0.86', '0.79'),
(7, 'Low-e, high -solar 3-layer', '0.76', '0.86', '0.64', '0.82', '0.57', '0.62', '0.86', '0.79'),
(8, 'Heat-absorbing 1-layer', '0.68', '0.72', '0.50', '0.67', '0.40', '0.49', '0.76', '0.69'),
(9, 'Heat-absorbing 2-layer', '0.73', '0.82', '0.59', '0.77', '0.51', '0.58', '0.83', '0.76'),
(10, 'Heat-absorbing 3-layer', '0.73', '0.82', '0.59', '0.77', '0.51', '0.58', '0.83', '0.76'),
(11, 'Reflective 1-layer', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00'),
(12, 'Reflective 2-layer', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00'),
(13, 'Reflective 3-layer', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00', '1.00');

-- --------------------------------------------------------

--
-- Table structure for table `lighting`
--

CREATE TABLE `lighting` (
  `id` int(100) NOT NULL,
  `user_id` int(100) DEFAULT NULL,
  `project_id` int(100) DEFAULT NULL,
  `type_of_light` varchar(200) DEFAULT NULL,
  `use_per_day` int(100) DEFAULT NULL,
  `use_per_month` int(100) DEFAULT NULL,
  `number` int(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lighting`
--

INSERT INTO `lighting` (`id`, `user_id`, `project_id`, `type_of_light`, `use_per_day`, `use_per_month`, `number`) VALUES
(1, 1, 2, 'Tubelight (50 W)', 1, 1, 1),
(2, 1, 2, 'Spotlight (50 W)', 2, 2, 2),
(3, 1, 2, 'Energy Saver Lights (24W)', 3, 3, 3),
(4, 1, 2, 'LED Spotlight(5W)', 4, 4, 4),
(5, 1, 2, 'LED Spotlight(5W)', 4, 4, 4);

-- --------------------------------------------------------

--
-- Table structure for table `shgc`
--

CREATE TABLE `shgc` (
  `id` int(6) NOT NULL,
  `Glazing Type` varchar(26) DEFAULT NULL,
  `Aluminum operable` decimal(3,2) DEFAULT NULL,
  `Aluminum with Thermal Break` decimal(3,2) DEFAULT NULL,
  `Reinforced Vinyl/Aluminum Clad Wood operable` decimal(3,2) DEFAULT NULL,
  `Wood/Vinyl operable` decimal(3,2) DEFAULT NULL,
  `Insulated Fiberglass/Viny operable` decimal(3,2) DEFAULT NULL,
  `Aluminum Fixed` decimal(3,2) DEFAULT NULL,
  `Aluminum with Thermal Break  Fixed` decimal(3,2) DEFAULT NULL,
  `Reinforced Vinyl/Aluminum Clad Wood Fixed` decimal(3,2) DEFAULT NULL,
  `Wood/Vinyl  Fixed` decimal(3,2) DEFAULT NULL,
  `Insulated Fiberglass/Viny  Fixed` decimal(3,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shgc`
--

INSERT INTO `shgc` (`id`, `Glazing Type`, `Aluminum operable`, `Aluminum with Thermal Break`, `Reinforced Vinyl/Aluminum Clad Wood operable`, `Wood/Vinyl operable`, `Insulated Fiberglass/Viny operable`, `Aluminum Fixed`, `Aluminum with Thermal Break  Fixed`, `Reinforced Vinyl/Aluminum Clad Wood Fixed`, `Wood/Vinyl  Fixed`, `Insulated Fiberglass/Viny  Fixed`) VALUES
(1, 'Clear 1 Layer', '0.75', '0.75', '0.64', '0.64', '0.64', '0.78', '0.78', '0.75', '0.75', '0.75'),
(2, 'Clear 2 Layer', '0.67', '0.67', '0.57', '0.57', '0.57', '0.69', '0.69', '0.67', '0.67', '0.67'),
(3, 'Clear 3 Layer', '0.60', '0.60', '0.51', '0.51', '0.51', '0.62', '0.62', '0.60', '0.60', '0.60'),
(4, 'Low-e, low-solar 2 layer', '0.37', '0.37', '0.31', '0.31', '0.31', '0.38', '0.38', '0.36', '0.36', '0.36'),
(5, 'Low-e, low-solar 3 layer', '0.25', '0.25', '0.21', '0.21', '0.21', '0.25', '0.25', '0.24', '0.24', '0.24'),
(6, 'Low-e, high-solar 2 layer', '0.62', '0.62', '0.52', '0.52', '0.52', '0.64', '0.64', '0.61', '0.61', '0.61'),
(7, 'Low-e, high -solar 3-layer', '0.55', '0.55', '0.46', '0.46', '0.46', '0.56', '0.56', '0.54', '0.54', '0.54'),
(8, 'Heat-absorbing 1-layer', '0.64', '0.64', '0.54', '0.54', '0.54', '0.66', '0.66', '0.64', '0.64', '0.64'),
(9, 'Heat-absorbing 2-layer', '0.55', '0.55', '0.46', '0.46', '0.46', '0.56', '0.56', '0.54', '0.54', '0.54'),
(10, 'Heat-absorbing 3-layer', '0.31', '0.31', '0.26', '0.26', '0.26', '0.31', '0.31', '0.30', '0.30', '0.30'),
(11, 'Reflective 1-layer', '0.28', '0.28', '0.24', '0.24', '0.24', '0.29', '0.29', '0.27', '0.27', '0.27'),
(12, 'Reflective 2-layer', '0.27', '0.27', '0.22', '0.22', '0.22', '0.27', '0.27', '0.26', '0.26', '0.26'),
(13, 'Reflective 3-layer', '0.31', '0.31', '0.26', '0.26', '0.26', '0.31', '0.31', '0.30', '0.30', '0.30');

-- --------------------------------------------------------

--
-- Table structure for table `walls_materials`
--

CREATE TABLE `walls_materials` (
  `id` int(100) NOT NULL,
  `user_id` int(100) DEFAULT NULL,
  `project_id` int(100) DEFAULT NULL,
  `core_materail` varchar(200) DEFAULT NULL,
  `inner_finishing` varchar(200) DEFAULT NULL,
  `outer_finishing` varchar(200) DEFAULT NULL,
  `insulation` varchar(200) DEFAULT NULL,
  `r_value` varchar(100) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `frame_type`
--
ALTER TABLE `frame_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `iacl`
--
ALTER TABLE `iacl`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lighting`
--
ALTER TABLE `lighting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `shgc`
--
ALTER TABLE `shgc`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `walls_materials`
--
ALTER TABLE `walls_materials`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `frame_type`
--
ALTER TABLE `frame_type`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `iacl`
--
ALTER TABLE `iacl`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `lighting`
--
ALTER TABLE `lighting`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `shgc`
--
ALTER TABLE `shgc`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `walls_materials`
--
ALTER TABLE `walls_materials`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;
COMMIT;

