000

Tables (4)

counted (CountedCar)

  • tStamp (Key) — INT — Primary key — NOT NULL
  • countedCars (Field) — SMALLINT
  • gpsLatitude (Field2) — DECIMAL(11, 9)
  • gpsLongitude (Field3) — DECIMAL(11, 9)
  • areaNumber (Field4) — SMALLINT

counted (AreaCategories)

  • tStamp (Key) — INT — Primary key — NOT NULL
  • Type1 (Field) — INT
  • Type2 (Field2) — INT
  • Type3 (Field3) — INT
  • Type4 (Field4) — INT

nomcarz (NominatedCar)

  • tStamp (Key) — INT — Primary key — NOT NULL
  • numberPlate (Field) — CHAR(32)
  • distance (Field2) — SMALLINT
  • gpaLatitude (Field3) — DECIMAL(11, 9)
  • gpsLongitude (Key5) — DECIMAL(11, 9) — NOT NULL
  • violenceCategory (Field4) — SMALLINT

nomcarz (ViolenceCategories)

  • tStamp (Key) — INT — Primary key — NOT NULL
  • Type1 (Field) — INT
  • Type2 (Field2) — INT
  • Type3 (Field3) — INT
  • Type4 (Field4) — INT