X-Git-Url: http://shamusworld.gotdns.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=database-schema.txt;h=ec3e0d6b076b14830b497fcde91f91f8cb823838;hb=HEAD;hp=3b5a34bafb70a1671cf2d6f6cd77f2d35f746cbb;hpb=f3116511d09acfd5b32d3412c82c4337d89f2ad9;p=schematic

diff --git a/database-schema.txt b/database-schema.txt
index 3b5a34b..ec3e0d6 100644
--- a/database-schema.txt
+++ b/database-schema.txt
@@ -8,7 +8,7 @@ VID (P-key) | VLID | signedNDA | Name
 CREATE TABLE Vendor (vid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, vlid INT, signedNDA TINYINT(1) NOT NULL DEFAULT 0, name VARCHAR(100), FOREIGN KEY (vlid) REFERENCES VendorLevel(vlid)) ENGINE=INNODB;
 
 VendorLevel
-VLID (P-key) | VendorUseable | Color | Description
+VLID (P-key) | VendorUsable | Color | Description
 CREATE TABLE VendorLevel (vlid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, vendorUsable TINYINT(1) NOT NULL DEFAULT 0, color INT(4), description VARCHAR(100)) ENGINE=INNODB;
 
 VendorType
@@ -56,8 +56,8 @@ DTID (P-key) | Description
 CREATE TABLE DocumentType (dtid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, description VARCHAR(100)) ENGINE=INNODB;
 
 Notes
-NID (P-key) | POID | Note
-CREATE TABLE Notes (nid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, poid INT, note VARCHAR(200)) ENGINE=INNODB;
+NID (P-key) | UID | POID | Note
+CREATE TABLE Notes (nid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, uid INT, poid INT, note VARCHAR(200)) ENGINE=INNODB;
 
 Alerts
 AID (P-key) | UID | NID | Date | Description