7Mg9qh1U

1CREATE TABLE IF NOT EXISTS result(
2municipalityID SMALLINT,
3districtID     SMALLINT,
4sectionID      SMALLINT,
5tableID        SMALLINT,
6partyID        SMALLINT,
7provinceID     SMALLINT, 
8votes          INTEGER,
9	
10introducir el código aquí
11CREATE TABLE IF NOT EXISTS  tableElection ( 
12municipalityID  SMALLINT,
13districtID      SMALLINT,
14sectionID         SMALLINT,
15tablesID        SMALLINT,
16possibleVotes   INTEGER,
17totalVotes      INTEGER,
18nullVotes       INTEGER,
19blankVotes      INTEGER,
20pollingstationID SMALLINT NOT NULL,
21CONSTRAINT pk_tableElection PRIMARY KEY 
22(municipalityID,districtID,sectionID,tablesID), 
23CONSTRAINT fk_tableElection_pollingstation FOREIGN KEY 
24(pollingstationID) 
25                         REFERENCES pollingstation(ID) 
26                               ON DELETE CASCADE ON UPDATE CASCADE
27
28);
29	
30ALTER TABLE result
31ADD FOREIGN KEY (districtID) REFERENCES tableElection (districtID);
32
33
34ALTER TABLE result
35ADD FOREIGN KEY (sectionID) REFERENCES tableElection (ID);
36
37
38ALTER TABLE result
39ADD FOREIGN KEY (tableID) REFERENCES tableElection(tableID);