Structure BackEnd

Structure BackEnd BackEnd Structure
Table hosts
Field Type Comments
id int(11) identifier
host_name varchar(50) domain
protected_key varchar(50) key (formed...)
date_create timestamp creation date
creator_password varchar(150) password (formed...)
host_cash int(11)
host_group int(4)
host_status int(4)
site_activate int(2)
site_frontend int(2)
site_environment int(2)

Table host_groups
Field Type Comments
id int(11) identifier
group_description varchar(50) name

Table host_statuses
Field Type Comments
id int(11) identifier
status_description varchar(50) name

Table host_templates
Field Type Comments
host_id int(11) identifier
storehouse_template varchar(150) name

Table interface
Field Type Comments
id int(11) identifier
name varchar(255) name

Table interface_name
Field Type Comments
id int(11) identifier
interface_id int(11) id table interface
interface_name varchar(255) name
interface_lang varchar(10) lang

Таблица lang
Field Type Comments
id int(11) identifier
name varchar(100) name
description varchar(100) description

Table test_host_statuses
Field Type Comments
id int(11) identifier
status_description varchar(50) name