schema.sql 964 B

123456789101112131415161718192021222324252627282930313233
  1. -- This is the database schema for PostgreSQL.
  2. begin;
  3. create table collection (
  4. path varchar primary key not null,
  5. parent_path varchar references collection (path));
  6. create table item (
  7. name varchar primary key not null,
  8. tag varchar not null,
  9. collection_path varchar references collection (path) not null);
  10. create table header (
  11. key varchar not null,
  12. value varchar not null,
  13. collection_path varchar references collection (path) not null,
  14. primary key (key, collection_path));
  15. create table line (
  16. key varchar not null,
  17. value varchar not null,
  18. item_name varchar references item (name) not null,
  19. timestamp timestamp not null,
  20. primary key (key, item_name));
  21. create table property (
  22. key varchar not null,
  23. value varchar not null,
  24. collection_path varchar references collection (path) not null,
  25. primary key (key, collection_path));
  26. commit;