1 CREATE SEQUENCE plugin_contribtracker_legal_structure_pk_seq ;
2 CREATE TABLE plugin_contribtracker_legal_structure (
3 struct_id integer DEFAULT nextval('plugin_contribtracker_legal_structure_pk_seq') NOT NULL,
4 struct_name text DEFAULT '' NOT NULL,
5 PRIMARY KEY (struct_id)
8 CREATE SEQUENCE plugin_contribtracker_role_pk_seq ;
9 CREATE TABLE plugin_contribtracker_role (
10 role_id integer DEFAULT nextval('plugin_contribtracker_role_pk_seq') NOT NULL,
12 role_description text,
16 CREATE SEQUENCE plugin_contribtracker_actor_pk_seq ;
17 CREATE TABLE plugin_contribtracker_actor (
18 actor_id integer DEFAULT nextval('plugin_contribtracker_actor_pk_seq') NOT NULL,
22 actor_description text,
24 PRIMARY KEY (actor_id),
25 FOREIGN KEY (struct_id) REFERENCES plugin_contribtracker_legal_structure (struct_id)
28 CREATE SEQUENCE plugin_contribtracker_contribution_pk_seq ;
29 CREATE TABLE plugin_contribtracker_contribution (
30 contrib_id integer DEFAULT nextval('plugin_contribtracker_contribution_pk_seq') NOT NULL,
33 contrib_description text,
35 PRIMARY KEY (contrib_id),
36 FOREIGN KEY (group_id) REFERENCES groups (group_id)
39 CREATE SEQUENCE plugin_contribtracker_participation_pk_seq ;
40 CREATE TABLE plugin_contribtracker_participation (
41 participation_id integer DEFAULT nextval('plugin_contribtracker_participation_pk_seq') NOT NULL,
45 PRIMARY KEY (participation_id),
46 FOREIGN KEY (contrib_id) REFERENCES plugin_contribtracker_contribution (contrib_id),
47 FOREIGN KEY (actor_id) REFERENCES plugin_contribtracker_actor (actor_id),
48 FOREIGN KEY (role_id) REFERENCES plugin_contribtracker_role (role_id)