12
UMLClass
396
240
240
216
visitor
--
<<PK>>
- visitor_id: INTEGER
--
- ip_address: INTEGER
- platform_id: INTEGER
- browser_id: INTEGER
- is_mobile: INTEGER
- is_human: INTEGER
- ip_range_id: INTEGER
style=autoresize
bg=MAGENTA
Relation
552
120
48
144
lt=-
m1=n
m2=1
10.0;100.0;10.0;10.0
UMLClass
744
240
228
204
request
--
<<PK>>
- request_id: INTEGER
--
- visitor_id: INTEGER
- route_id: INTEGER
- referer_id: INTEGER
--
- time: INTEGER
- status: INTEGER
style=autoresize
bg=CYAN
Relation
624
276
144
60
lt=-
m1=1
m2=n
10.0;20.0;100.0;20.0
UMLClass
252
12
240
120
platform
--
<<PK>>
- platform_id: INTEGER
--
- name: TEXT UNIQUE
--
style=autoresize
bg=MAGENTA
UMLClass
744
564
228
156
city
--
<<PK>>
- city_id: INTEGER
--
- name: TEXT
- country_id: INTEGER
- region_id: INTEGER
style=autoresize
bg=ORANGE
Relation
960
588
132
60
lt=-
m1=1
m2=n
90.0;20.0;10.0;20.0
Relation
624
588
144
60
lt=-
m1=1
m2=n
100.0;20.0;10.0;20.0
UMLClass
396
564
240
156
ip_range
--
<<PK>>
- ip_range_id
--
- low: INTEGER UNIQUE
- high: INTEGER UNIQUE
- city_id: INTEGER
style=autoresize
bg=ORANGE
Relation
504
444
48
144
lt=-
m1=1
m2=n
10.0;100.0;10.0;10.0
UMLClass
1068
240
216
120
route
--
<<PK>>
- route_id: INTEGER
--
- name: TEXT UNIQUE
--
style=autoresize
bg=CYAN
UMLClass
540
12
228
120
browser
--
<<PK>>
- browser_id: INTEGER
--
- name: TEXT UNIQUE
--
style=autoresize
bg=MAGENTA
Relation
456
120
48
144
lt=-
m1=n
m2=1
10.0;100.0;10.0;10.0
UMLClass
816
12
228
120
referer
--
<<PK>>
- referer_id: INTEGER
--
- name: TEXT UNIQUE
--
style=autoresize
bg=CYAN
Relation
852
120
48
144
lt=-
m1=n
m2=1
10.0;100.0;10.0;10.0
Relation
960
276
132
60
lt=-
m1=n
m2=1
10.0;20.0;90.0;20.0
UMLClass
1068
564
228
132
country
--
<<PK>>
- country_id: INTEGER
--
- name: TEXT UNIQUE
- code: TEXT UNIQUE
style=autoresize
bg=ORANGE
Relation
936
708
48
120
lt=-
m1=1
m2=n
10.0;80.0;10.0;10.0
Relation
1080
684
48
144
lt=-
m1=1
m2=n
10.0;10.0;10.0;100.0
UMLClass
912
804
228
132
region
--
<<PK>>
- region_id: INTEGER
--
- name: TEXT
- country_id: INTEGER
style=autoresize
bg=ORANGE