summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/Pg-database.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index bc9244a2..b28c41e7 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -715,8 +715,7 @@ CREATE TABLE warehouse (
);
--
CREATE TABLE inventory (
- entity_id integer references entity(id) not null PRIMARY KEY,
- entity_class_id integer references entity_class(id) not null check (entity_class_id = 3),
+ entity_id integer references employee(entity_id) not null,
warehouse_id int,
parts_id int,
trans_id int,