CentreId CentreName TownId CentreTypeIdPostCode SquareMetresNumberUnits

1 Pavilion Shopp180 3 EN8 7BZ 15143 62

2 Times Square 170 3 SM1 1LF 15143 71
4 Norman Park 9 3 CB3 8EL 15228 11
7 Cannon Park S48 3 CV4 7EH 15329 36
12 Kingsmead Sho 69 3 GU14 7SJ 15515 69
13 Market Quay 68 3 PO16 15515 0
19 Old George Ma148 3 SP1 2NH 15794 37
20 The Nicholson'113 3 SL6 1LB 15794 64
25 The Longford 70 3 TW13 4BH 15979 85
26 Southgate Sho15 3 BA1 1TQ 16072 34
30 Meridian Shop86 3 PO9 1UN 16258 33
31 Metropolitan C11 3 S70 1SX 16258 53
35 Crompton Plac21 3 BL1 1RS 16351 47
37 Martineau Pla 19 3 B2 4UQ 16400 27
38 Market Centre52 3 CW1 2NG 16480 26
39 Wellington Sh 2 3 GU11 1DB 16493 44
43 Cornmill Shop 54 3 DL1 1NH 16596 64
45 The Mall 11 3 S70 1SB 16630 34
49 Barkers Arcad97 3 W8 5HW 16722 10
52 Town Square S 128 3 OL1 1XD 16723 32
54 Observatory S154 3 SL1 1LN 16908 48
55 Beacon Shoppi124 3 NE29 6QF 16908 43
56 Kirkby Shoppi 103 3 L32 8RD 16928 70
mberUnits
CentreTypeId CentreTypeName
1 Factory Outlet
2 Retail Park
3 Shopping Centre
4 Shopping Park
EnvironmentId EnvironmentName
1 Land
2 Air
3 Water
FamilyId FamilyName
1 Reptile
2 Fish
3 Bird
4 Amphibian
5 Mammal
6 Insect
HabitatId HabitatName EnvironmentIBackColour ForeColour
1 Grasslands 1 Light green Black
2 Forest 1 Dark green White
3 Fresh water 3 LightBlue Dark blue
4 Salt water 3 #78aaf5 White
5 Desert 1 #d6a740 Black
6 Urban 1 #222 White
7 Sky 2 #0a66f0 White
ProductId ProductName Animal HabitatId Legs FamilyId WeightGrams
1 Sammy Snake 1 0 1 950
2 Pokyo Penguin 4 2 3 850
3 Fenella Frog 3 4 4 400
4 Layla Lemur 2 2 5 550
5 Dave Dachsund 1 4 5 775
6 Kylie Camel 5 4 5 1200
7 Jeremy Jackdaw 7 2 3 295
8 Faye Fox 6 4 5 420
9 Oliver Owl 7 2 3 380
10 Cleopatra Clownfish 4 0 2 290
11 Oscar Otter 3 4 5 340
12 Bob Butterfly 7 6 6 450
13 Englebert Elephant 1 4 5 1450
14 Petronella Parakeet 2 2 3 520
15 Rheinhardt Rattlesnake 5 0 1 890
16 Nora Natterjack toa 3 4 4 560
17 Yoko Yak 1 4 5 1350
18 Malcolm Meerkat 1 4 5 670
19 Imogen Impala 1 4 5 990
ProductionCost
7.19
4.5
10.79
4.28
5.85
3.15
7.65
4.95
6.75
2.69
13.72
5.85
3.15
4.05
7.65
6.75
10.79
14.85
3.59
PurchaseId PurchaseDate
15763 2017-01-04
16093 2017-01-07
17158 Friday, January 13, 2017
17637 Tuesday, January 17, 2017
17851 Thursday, January 19, 2017
18325 Monday, January 23, 2017
18822 Sunday, January 29, 2017
19027 Monday, January 30, 2017
19052 Tuesday, January 31, 2017
19271 Wednesday, February 1, 2017
19273 Wednesday, February 1, 2017
19289 Wednesday, February 1, 2017
19398 Wednesday, February 1, 2017
19965 Thursday, February 9, 2017
20799 Saturday, February 18, 2017
20809 Saturday, February 18, 2017
21371 Friday, February 24, 2017
22311 Monday, March 6, 2017
22791 Thursday, March 9, 2017
23031 Sunday, March 12, 2017
23375 Monday, March 13, 2017
23820 Tuesday, March 14, 2017
24064 Wednesday, March 15, 2017
 PurchaseDateTime ProductId CentreId Quantity
2017-04-01 [Link] 1 252 2
2017-07-01 [Link] 1 341 2
1/13/2017 [Link] PM 1 360 2
1/17/2017 [Link] PM 1 309 2
1/19/2017 [Link] PM 1 270 2
1/23/2017 [Link] PM 1 326 2
1/29/2017 [Link] AM 1 331 2
1/30/2017 [Link] PM 1 383 2
1/31/2017 [Link] PM 1 255 2
2/1/2017 [Link] 1 375 2
2/1/2017 [Link] 1 251 2
2/1/2017 [Link] 1 379 2
2/1/2017 [Link] 1 351 2
2/9/2017 [Link] 1 361 2
2/18/2017 [Link] PM 1 373 2
2/18/2017 [Link] PM 1 310 2
2/24/2017 [Link] PM 1 313 2
3/6/2017 [Link] 1 250 2
3/9/2017 [Link] 1 382 2
3/12/2017 [Link] 1 236 2
3/13/2017 [Link] PM 1 240 2
3/14/2017 [Link] PM 1 379 2
3/15/2017 [Link] PM 1 235 2
Price PaymentDate StaffId
8.5 NULL 4644
8.5 NULL 5573
8.5 NULL 5182
8.5 NULL 4922
8.5 NULL 4719
8.5 NULL 4991
8.5 NULL 5027
8.5 NULL 5296
8.5 NULL 4664
8.5 NULL 5380
8.5 NULL 4627
8.5 NULL 5274
8.5 NULL 5519
8.5 NULL 5469
8.5 NULL 5235
8.5 NULL 4930
8.5 NULL 4933
8.5 NULL 4622
8.5 NULL 5334
8.5 NULL 4554
8.5 NULL 4571
8.5 NULL 5273
8.5 NULL 4553
RegionId RegionName
1 East Anglia
2 East Midlands
3 London
4 North
5 North West
6 South East
7 South West
8 West Midlands
9 Yorkshire & Humberside
TownId TownName RegionId
1 Aintree 5
2 Aldershot 6
3 Altrincham 5
4 Andover 6
5 Ashford 6
6 Ashton Under 5
7 Aylesbury 6
8 Banbury 6
9 Barhill 1
10 Barking 3
11 Barnsley 9
12 Barrow In Fur 4
13 Basildon 6
14 Basingstoke 6
15 Bath 7
16 Bedford 6
17 Bexleyheath 3
18 Birkenhead 5
19 Birmingham 8
20 Blackburn 5
21 Bolton 5
22 Bootle 5
23 Borehamwood 6