Table Skins

Skins are the different styles and contents a site can have depending on their needs. For example, one skin can have different colors/font-sizes and different copy for a specific holiday.

is_default
INT
If specific skin is default of template equals 1, otherwise equals 0.
name
VARCHAR
Name of the skin.

Table sites

Sites is where the basic information will be, such as it's URL and it's associated template.

url
VARCHAR
Website URL of the website
template_id
INT
Foreign Key that identifies which template this site is associated with.

Table Skins Config

This is where each skins styles and copy are defined. For example, it can have one configuration for the main title of a skin to be red, and in another the main title can be blue and have a completely different copy.

skin_id
INT
Foreign Key that identifies which skin this configuration is associated with.
item_name
VARCHAR
Name of the configuration item.
value
VARCHAR
The CSS or HTML code which this item represents
type
VARCHAR
Whether this item is HTML or CSS

Table Skins Templates

This is where is defined which skins each template is using, and since one template can be used by multiple sites, the site_id is also defined.

skin_id
INT
Foreign Key that represents the skin ID
template_id
INT
Foreign Key that represents the template ID
site_id
INT
Foreign Key that represents the site ID

Table Templates

Templates are the basic building blocks/html structure.

name
VARCHAR
Name of the template.
file_path
VARCHAR
File Path where the template file is located.