/* Types of entity, for example - person, country, region */
create table EntityType(
    id varchar(32),
    name varchar(1024)
);

/* Attribute of entity, for example birthday of person */
create table Attribute(
    id varchar(32),
    entityTypeId varchar(32) REFERENCES EntityType(id), /* it is an attribute type*/
    name varchar(1024)
);

/* Entity of entity type. For example, concrete person Andrey Ivanov, or Country Germany */
create table Entity(
    id varchar(32),
    name varchar(1024),
    entityTypeId varchar(32) REFERENCES EntityType(id)
);

/* Real values of attributes. */
create table Parameter(
    entityId varchar(32) REFERENCES Entity(id),
    attributeId varchar(32) REFERENCES Attribute(id),
    varcharValue varchar(4096),
    datetimeValue timestamp,
    PRIMARY KEY (entityId, attributeId)
);

/* Types of entity, for example - person, country, region */
create table EntityType(
    id varchar(32),
    nameId varchar(1024) REFERENCES Resource(id)
);

/* Attribute of entity, for example birthday of person */
create table Attribute(
    id varchar(32),
    entityTypeId varchar(32) REFERENCES EntityType(id), /* it is an attribute type*/
    nameId varchar(1024) REFERENCES Resource(id)
);

/* Entity of entity type. For example, concrete person Andrey Ivanov, or Country Germany */
create table Entity(
    id varchar(32),
    nameId varchar(1024) REFERENCES Resource(id),
    entityTypeId varchar(32) REFERENCES EntityType(id)
);

/* Real values of attributes. */
create table Parameter(
    entityId varchar(32) REFERENCES Entity(id),
    attributeId varchar(32) REFERENCES Attribute(id),
    varcharValueId varchar(4096) REFERENCES Resource(id),
    datetimeValue timestamp,
    PRIMARY KEY (entityId, attributeId)
);

create table Language (
  langId varchar(32),
  name varchar (32)
)

create table Resource (
  resId varchar(32),
  langId varchar(32),
  value varchar(4096)
)

Комьпьютер Онитрон 5
Процессор: Core2Duo 2.6Ггц
Тип охлаждения: жидкий

create table Parameter(
    entityId varchar(32) REFERENCES Entity(id),
    attributeId varchar(32) REFERENCES Attribute(id),
    varcharValue varchar(4096),
    textValue text,
    integerValue integer,
    floatValue float,
    datetimeValue timestamp,
    booleanValue boolean,
    entityValue varchar(32) REFERENCES Entity(id), /* types for list options like computer, person, city , country and so on. */
    PRIMARY KEY (entityId, attributeId)
);

create table Entity(
    id varchar(32),
    entityTypeId varchar(32) REFERENCES EntityType(id),
    -- другие поля
);

create table EntityResource (
  resId varchar(32) Primary Key,
  langId varchar(32),
  value varchar(4096)
  EntityId varchar(32) REFERENCES Entity(id)
  UNIQUE INDEX (resId, langId)
)

create table Entity(
    id varchar(32),
    nameId varchar(1024) REFERENCES Resource(id),
    entityTypeId varchar(32) REFERENCES EntityType(id),
	-- other fields
);

create table Attribute(
    id varchar(32),
    entityTypeId varchar(32) REFERENCES EntityType(id),
	-- other fields
);

create table Resource (
  resId varchar(32) Primary Key,
  langId varchar(32),
  value varchar(4096)
  EntityId varchar(32) REFERENCES Entity(id)
  AttributeId varchar(32) REFERENCES Attribute(id)
  UNIQUE INDEX (resId, langId)
)

create table Entity(
    id varchar(32),
    nameId varchar(1024) REFERENCES Resource(id),
    entityTypeId varchar(32) REFERENCES EntityType(id),
	-- other fields
);

create table Attribute(
    id varchar(32),
    entityTypeId varchar(32) REFERENCES EntityType(id),
	-- other fields
);

create table EntityResource (
  resId varchar(32) Primary Key,
  langId varchar(32),
  value varchar(4096)
  EntityId varchar(32) REFERENCES Entity(id)
  UNIQUE INDEX (resId, langId)
)

create table AttributeResource (
  resId varchar(32) Primary Key,
  langId varchar(32),
  value varchar(4096)
  AttributeId varchar(32) REFERENCES Attribute(id)
  UNIQUE INDEX (resId, langId)
)

create table Resource(
    id varchar(32),	
    varcharValue varchar(4096),
    textValue text,
    PRIMARY KEY (id)
);

create table Language(
    id varchar(32),
    name varchar(32),
    PRIMARY KEY (id)
);

create table main.LanguageResource(
    id varchar(32),
    resourceId varchar(32) REFERENCES Resource(id),
    languageId varchar(32) REFERENCES Language(id), 
    varcharValue varchar(4096),
    textValue text,
    PRIMARY KEY (id)
);

create table main.Attribute(
    id varchar(32),
    entityTypeId varchar(32) REFERENCES EntityType(id),
    nameId varchar(32) REFERENCES Resource(id),
	-- other fields
    PRIMARY KEY (id)
);

create table main.Parameter(
    entityId varchar(32) REFERENCES Entity(id),
    attributeId varchar(32) REFERENCES Attribute(id),
    stringValueId varchar(32) REFERENCES Resource(id),
    integerValue integer,
    floatValue float,
    datetimeValue timestamp,
    booleanValue boolean,
    entityValue varchar(32) REFERENCES Entity(id),
    PRIMARY KEY (entityId, attributeId)
);