web-project/database.puml at master · uni-aau/web-project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
@startuml
!theme plain

entity "User" {
  +user_id : int [PK]
  --
  #wallet_id : int [FK]
  username : varchar [Unique]
  firstname: varchar
  lastname: varchar
  email : varchar [Unique]
  is_admin : boolean
  has_connected_bank_account boolean
  password_hash : varchar
  profile_picture_location varchar
}

entity "Wallet" {
  +wallet_id : int [PK]
  --
  balance : decimal
  available_balance : decimal
}

entity "Station" {
  +station_id : int [PK]
  --
  station_name : varchar
  description: varchar
  station_address : varchar
  longitude : decimal
  latitude : decimal
  station_image_location : varchar
}

entity "BikeCategory" {
  +category_id : int [PK]
  --
  category_name : varchar
  price: float
}

entity "BikeModel" {
  +model_id : int [PK]
  --
  #category_id : int [FK]
  model_name : varchar
  price : float
}

entity "Bike" {
  +bike_id : int [PK]
  --
  #station_id : int [FK]
  #model_id : int [FK]
  #assigned_to : int [FK]
  bike_name: varchar
  is_available : boolean
  status : bike_status [Enum]
  size : int
  price : float
  bike_image_location varchar
}

entity "ParkingSpot" {
  +spot_id : int [PK]
  --
  #station_id : int [FK]
  spot_number : int
  #category_id : int [FK]
}

entity "ParkingSpotCategory" {
  +spot_id, category_id : int [PK]
  --
  #spot_id : int [FK]
  #category_id : int [FK]
}

entity "Ticket" {
  +ticket_id : int [PK]
  --
  #user_id : int [FK]
  #bike_id : int [FK]
  #model_id : int [FK]
  #category_id : int [FK]
  booked_type : booked_type [Enum]
  status : booking_status [Enum]
  booking_time : timestamp
  renting_start : timestamp
  renting_end : timestamp
  price : float
}

entity "Transaction" {
  +transaction_id : int [PK]
  --
  #ticket_id : int [FK]
  #user_id : int [FK]
  amount : decimal
  transaction_type : varchar
  timestamp : timestamp
}

entity "StationReview" {
  +review_id : int [PK]
  --
  #station_id : int [FK]
  #user_id : int [FK]
  #model_id : int [FK]
  title : varchar
  rating : int
  comment : text
  timestamp : timestamp
}

User ||--o{ Wallet : "owns"
User ||--o{ Ticket : "books"
User ||--o{ Transaction : "performs"
User ||--o{ StationReview : "writes"
Station ||--o{ Bike : "hosts"
Station ||--o{ StationReview : "receives"
Station ||--o{ ParkingSpot : "contains"
BikeCategory ||--o{ BikeModel : "includes"
BikeModel ||--o{ Bike : "includes"
BikeModel ||--o{ StationReview : "receives"
BikeCategory ||--o{ Ticket : "categorized in"
BikeModel ||--o{ Ticket : "categorized in"
Bike ||--o{ Ticket : "categorized in"
BikeCategory ||--o{ ParkingSpot : "accommodates"
ParkingSpot ||--o{ ParkingSpotCategory : "hosts"

@enduml