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)