I need a database design to maintain the entity, its properties and also to store the historical changes of the property values
Entity: Any object. For example car
Properties: Color, Engine type, Height, Width
Example: I created a main table with obj_id and obj_name. Properties table with prop_id and prop_name

Create table object (obj_id number, obj_name varchar2, created_date, created_by,last_updated_by,start_date,end_date);
insert into object values(1,'Car');

create table obj_prop (prop_id number, prop_name varchar2, created_date, created_by,last_updated_by,start_date,end_date);
insert into obj_prop values (1,'Color');
insert into obj_prop values (2,'Engine_type');
insert into obj_prop values (3,'Height');
insert into obj_prop values (4,'width');

create table obj_prop_assoc (assoc_id number,obj_id number,prop_id number, prop_value varchar2, created_date, created_by,last_updated_by,start_date,end_date);
insert into obj_prop_assoc values (1,1,1,'White');
insert into obj_prop_assoc values (2,1,2,'Diesel');
insert into obj_prop_assoc values (3,1,3,'250cm');
insert into obj_prop_assoc values (4,1,4,'500cm');

So, If any new object/property has to be added I can add in above tables.

Question

1.Is this is the best design to follow?

2. How can I apply constraints on property values?

If I have another table to store different colors
Create table colors(color_id,color_name)
insert into colors(1,'Violet');
insert into colors(2,'Indigo');
insert into colors(3,'Blue');
insert into colors(4,'Green');
insert into colors(5,'Yellow');
insert into colors(6,'Orange');
insert into colors(7,'Red');

Now I want to apply constraint on obj_prop_assoc table prop_name column to have one of the values from the colors table for Color property (Foreign Key Constraint) . How can I do this?

Thanks.

create table cars (
  color       varcahr2(30),
  engine_type varchar2(30),
  height      number,
  width       number,
  ...
);

create table cars_hist (
  color       varcahr2(30),
  engine_type varchar2(30),
  height      number,
  width       number,
  ...
  changed_date date,
  change_type  varchar2(1),
  changed_by   varchar2(30),
  ...
);