diff options
| -rw-r--r-- | sql/Pg-database.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 3657ac63..29adb6b8 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -37,6 +37,13 @@ INSERT INTO entity_class (id,class) VALUES (6,'Referral'); SELECT setval('entity_class_id_seq',7); +CREATE TABLE entity_class_to_entity ( + entity_class_id integer not null references entity_class(id), + entity_id integer not null references entity(id) + ); + +COMMENT ON TABLE entity_class_to_entity IS $$ Relation builder for classes to entity $$; + CREATE TABLE country ( id serial PRIMARY KEY, |