> INTEGER Object
> TEXT Keyword
> REAL Value
>
>  Or perhaps you'd prefer to give each object a name:
>
> TEXT Object
> TEXT Keyword
> REAL Value

Or both

create table objects (
  object_id integer,
  object_name text,
  object_keyword text,
  object_value real
);

with best wishes

Artur
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to