-
SqLite
Optional
-
CREATE TABLE test_PollingStation ( PollingStationID int NOT NULL, Name varchar(255) NOT NULL, PRIMARY KEY (PollingStationID)); CREATE TABLE test_Voters ( ClientID int NOT NULL, CardNumber varchar(8) NOT NULL, IssueDate DATE NOT NULL, PollingStation int NOT NULL, PRIMARY KEY (ClientID), FOREIGN KEY (PollingStation) REFERENCES test_PollingStation(PollingStationID)); INSERT INTO test_PollingStation VALUES (1, "Cavendish"); INSERT INTO test_PollingStation VALUES (2, "UNZA");
-
<dependencies> <dependency> <groupId>org.eclipse.persistence</groupId> <artifactId>javax.persistence</artifactId> <version>2.2.1</version> </dependency> </dependencies>