DB Schema - graflu0/TSM_MobOp GitHub Wiki

DB Schema eines city-Objekts

Tabelle City
ID -> PK
name
country -> FK
continent -> FK
longitude
lattitude
show_on_screen
device -> FK

Tabelle device -> erstes Device = System-Device
ID -> PK
device_nr
registration_date

Tabelle group
ID -> PK
device -> FK
creation_date
modification_date
Name

Tabelle city_group
ID -> PK
city_id -> FK
group_id -> FK

Tabelle country
ID -> PK
name
short_name

Tabelle continent
ID -> PK
name

Tabelle user_location
ID -> PK
date
device -> FK
longitude
lattitude

Tabelle city_user_location
ID -> PK
city -> FK
usage -> FK