/* 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)
)