-- 1. Projects Table CREATE TABLE Projects ( project_id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(200) NOT NULL, location_city VARCHAR(100), location_state VARCHAR(50), project_type VARCHAR(100), -- e.g., 'Three-Season Sunroom' year_completed YEAR, description TEXT ); -- 2. Project_Images Table CREATE TABLE Project_Images ( image_id INT PRIMARY KEY AUTO_INCREMENT, project_id INT NOT NULL, image_url VARCHAR(500) NOT NULL, caption VARCHAR(255), image_type ENUM('Interior','Exterior','Detail'), FOREIGN KEY (project_id) REFERENCES Projects(project_id) ); -- 3. Project_Features Table CREATE TABLE Project_Features ( feature_id INT PRIMARY KEY AUTO_INCREMENT, project_id INT NOT NULL, feature_name VARCHAR(100), details VARCHAR(255), FOREIGN KEY (project_id) REFERENCES Projects(project_id) ); -- 4. Sunroom_Specifics Table CREATE TABLE Sunroom_Specifics ( spec_id INT PRIMARY KEY AUTO_INCREMENT, project_id INT NOT NULL, roof_style VARCHAR(100), -- e.g., 'Studio Roof' season_type VARCHAR(100), -- e.g., 'Three-Season' insulated BOOLEAN, FOREIGN KEY (project_id) REFERENCES Projects(project_id) ); -- 5. Warranty_Info Table CREATE TABLE Warranty_Info ( warranty_id INT PRIMARY KEY AUTO_INCREMENT, project_id INT NOT NULL, labor_warranty VARCHAR(100), product_warranty VARCHAR(100), FOREIGN KEY (project_id) REFERENCES Projects(project_id) );
Skip to main content

No Guesswork! See Real Numbers with Our Cost Calculators

Get Your Ballpark Price Now!
Open Search
Book a Design Consultation
Search for topics or resources
Enter your search below and hit enter or click the search icon.
Close Search
Past Projects

Sunroom with Studio Roof in Strongsville

This studio roof sunroom was built in Strongsville, OH. This is a three season sunroom.

Project Year: 2020

 

 

 

Contact Info

Cleveland, OH- Northeast Ohio
(440) 202-7331
Monday-Thursday
8:00 a.m. - 8:30 p.m.
Friday
8:00 a.m. - 6:00 p.m.
Saturday
9:00 a.m. - 4:00 p.m.
Sunday
2:00 p.m. - 8:00 p.m.

Talk To Us

Free In-Home Consultation

Start creating the home you’ve always wanted — with expert help.
Our free in-home design consultation is the easiest way to explore your options and make confident decisions. Whether you’re upgrading your windows, remodeling your bath, adding a sunroom, or improving your doors, our team is here to help you bring your vision to life.

Why Book Your Free Consultation?

Tailored to Your Home – Every home is unique, and so is our approach. We’ll assess your space and recommend the right solutions for your needs, style, and budget.
Hands-On With Options – See and feel product samples, finishes, and colors; all in the comfort of your own home.
Expert Guidance, No Pressure – Our goal is to educate and inspire, not to sell. You’ll have all the information you need to make the right choice; at no cost or obligation.

We’ll Be In Touch Soon!