Relation between Category & UserInfo

nechromancer · nechromancer · commit a7a1ac8935ef · 2012-05-04T16:05:09.000-04:00
diff --git a/JavaSource/sql/db-relationships.sql b/JavaSource/sql/db-relationships.sql
@@ -72,6 +72,11 @@ ALTER TABLE CATEGORY ADD
       CONSTRAINT FK_CATEGORY_PARENT
       FOREIGN    KEY (PARENT_ID)
       REFERENCES CATEGORY(CATEGORY_ID);
+
+ALTER TABLE CATEGORY ADD 
+      CONSTRAINT FK_CATEGORY_USER
+      FOREIGN    KEY (CREATED_BY)
+      REFERENCES USER_INFO(USER_INFO_ID);       
       
 ALTER TABLE VEHICLE ADD 
       CONSTRAINT FK_VEHICLE_MAKE
