gGbw5WPM

1//%% NEW FILE Stand BEGINS HERE %%
2
3-- PLEASE DO NOT EDIT THIS CODE
4-- This code was generated using the UMPLE 1.29.1.4450.6749b7105 modeling language!
5
6
7
8CREATE TABLE IF NOT EXISTS `stand`
9(
10  /*------------------------*/
11  /* MEMBER VARIABLES       */
12  /*------------------------*/
13  
14  /*stand Attributes*/
15  stand_id VARCHAR(255),
16  navn VARCHAR(255),
17  PRIMARY KEY(stand_id)
18
19);
20
21
22
23
24
25
26//%% NEW FILE Vote BEGINS HERE %%
27
28-- PLEASE DO NOT EDIT THIS CODE
29-- This code was generated using the UMPLE 1.29.1.4450.6749b7105 modeling language!
30
31
32
33CREATE TABLE IF NOT EXISTS `vote`
34(
35  /*------------------------*/
36  /* MEMBER VARIABLES       */
37  /*------------------------*/
38
39  /*vote Associations*/
40  stand_stand_id VARCHAR(255),
41  
42  /*vote Attributes*/
43  bruker_id VARCHAR(255),
44  vekt INT,
45  PRIMARY KEY(bruker_id, stand_stand_id)
46
47);
48
49
50ALTER TABLE `vote` ADD CONSTRAINT `fk_vote_stand_stand_id` FOREIGN KEY (`stand_stand_id`) REFERENCES `stand`(`stand_id`);