123
Tables (6)
Density
- measures — int (11) — Primary key — NOT NULL
- enviroment — varchar(50)
- event — varchar(50)
- public transport (public_transport) — varchar(50)
- trading area (trading_area) — varchar(50)
- user id (user_id) — int (11) — Foreign key → User.user id — NOT NULL
Enviroment
- env code — int (11) — Primary key — NOT NULL
- dust — int(11)
- temperture — int(11)
- humidity — int(11)
- rainfall
- adress — varchar(50) — Foreign key → Trading Area.adress — NOT NULL
Event
- event code (evnet_code) — int (11) — Primary key — NOT NULL
- evnet name (evnet_name) — varchar(50)
- event date (event_date) — int(11)
- last year participant (last_year_participant) — int(11)
- adress — varchar(50) — Foreign key → Trading Area.adress — NOT NULL
Public Transport (Public_transport)
- pt code — int (11) — Primary key — NOT NULL
- subway — varchar(50)
- bus — varchar(50)
- taxi — varchar(50)
- adress — varchar(50) — Foreign key → Trading Area.adress — NOT NULL
Trading Area (Trading_Area)
- adress — varchar(50) — Primary key — NOT NULL
- population — int(11)
- measures — int (11) — Foreign key → Density.measures — NOT NULL
User
- user id (user_id) — int (11) — Primary key — NOT NULL
- user name (user_name) — varchar(50)
- user location (user_location) — varchar(50)
- phone number (phone_number) — int(50)