2 id INTEGER PRIMARY KEY,
6 CREATE SEQUENCE BalanceSeq
START 1;
9 (id, name, amount
) VALUES
13 id INTEGER PRIMARY KEY,
17 joined
TIMESTAMP NOT NULL,
18 FOREIGN KEY (bal
) REFERENCES Balance(id) ON DELETE CASCADE);
20 CREATE SEQUENCE WebUserSeq
START 1;
23 (id, name, bal
) VALUES
26 CREATE TABLE WebGroup(
27 id INTEGER PRIMARY KEY,
30 CREATE SEQUENCE WebGroupSeq
START 4;
48 CREATE TABLE Membership(
51 PRIMARY KEY (grp
, usr
),
52 FOREIGN KEY (grp
) REFERENCES WebGroup(id) ON DELETE CASCADE,
53 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE);
55 INSERT INTO Membership
59 CREATE TABLE Transaction(
60 id INTEGER PRIMARY KEY,
64 stamp
TIMESTAMP NOT NULL);
66 CREATE SEQUENCE TransactionSeq
START 1;
72 PRIMARY KEY (trn
, usr
),
73 FOREIGN KEY (trn
) REFERENCES Transaction(id) ON DELETE CASCADE,
74 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE);
77 id INTEGER PRIMARY KEY,
83 votes
INTEGER NOT NULL,
84 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE);
86 CREATE SEQUENCE PollSeq
START 1;
88 CREATE TABLE PollChoice(
89 id INTEGER PRIMARY KEY,
93 FOREIGN KEY (pol
) REFERENCES Poll(id) ON DELETE CASCADE);
95 CREATE SEQUENCE PollChoiceSeq
START 1;
100 PRIMARY KEY (usr
, cho
),
101 FOREIGN KEY (usr
) REFERENCES WebUser(id) ON DELETE CASCADE,
102 FOREIGN KEY (cho
) REFERENCES PollChoice(id) ON DELETE CASCADE);