uhhhh...and so quickly we reach the limits of my understanding here. Whoops.
So I thought I was demonstrating that command with that one line I
referenced. Does it help to put the whole table setup? Or would all the
tables be helpful? Again here I used the Mental Health Clinic Database
(from the tutorial) as a guideline. This table is an intermediary to deal
with a many to many relationship.
CREATE TABLE "Vulnerability" (
"Vuln ID" INTEGER NOT NULL,
"Vulnerability" INTEGER NOT NULL,
"VulnInstance" NUMERIC(10) DEFAULT 1,
CONSTRAINT PK_ISSUE PRIMARY KEY ("Vulnerability", "Vuln ID" ),
CONSTRAINT FK_ISSUE FOREIGN KEY ("Vulnerability") REFERENCES "Issue Type"
("Issue ID"),
CONSTRAINT FK_SCAN_VULN FOREIGN KEY ("Vuln ID") REFERENCES "Scan" ("Scan
ID")
);
--
View this message in context:
http://nabble.documentfoundation.org/Base-Field-Defaut-Disables-Save-tp2890141p3264635.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted