|
Field |
Type |
Null |
Default |
|
barnumber |
tinyint(1) |
No |
0 |
|
barcodes |
varchar(18) |
No |
|
|
barcodes2 |
varchar(15) |
No |
|
|
enddate |
varchar(12) |
No |
|
|
1 |
0505BH12 |
2 5 6 34 4 |
|
|
Field |
Type |
Null |
Default |
|
Moodinfo |
tinyint(1) |
No |
0 |
|
1 |
|
1 |
|
1 |
|
1 |
|
1 |
|
2 |
|
2 |
|
2 |
|
2 |
|
2 |
|
2 |
|
2 |
|
3 |
|
3 |
|
3 |
|
3 |
|
3 |
|
3 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
5 |
|
5 |
|
5 |
|
5 |
|
6 |
|
Field |
Type |
Null |
Default |
|
Gender |
tinyint(1) |
No |
0 |
|
Age |
tinyint(1) |
No |
0 |
|
Profession |
tinyint(1) |
No |
0 |
|
1 |
7 |
1 |
|
2 |
6 |
3 |
|
2 |
4 |
5 |
|
2 |
5 |
4 |
|
2 |
3 |
6 |
|
2 |
4 |
6 |
|
2 |
5 |
6 |
|
2 |
4 |
6 |
|
2 |
4 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
1 |
3 |
2 |
|
1 |
3 |
2 |
|
1 |
3 |
2 |
|
1 |
3 |
2 |
|
1 |
3 |
2 |
|
1 |
3 |
2 |
|
1 |
3 |
2 |
|
1 |
7 |
2 |
|
1 |
5 |
2 |
|
1 |
6 |
0 |
|
1 |
7 |
9 |
|
1 |
3 |
2 |
|
2 |
7 |
7 |
|
2 |
6 |
9 |
|
1 |
5 |
8 |
|
1 |
7 |
1 |
|
2 |
5 |
8 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
2 |
5 |
6 |
|
1 |
5 |
2 |
|
Field |
Type |
Null |
Default |
|
Name |
char(30) |
No |
|
|
Age |
tinyint(3) |
No |
0 |
|
Gender |
char(6) |
No |
|
|
Job |
char(150) |
No |
|
|
Jobnearest |
char(10) |
No |
0 |
|
Positivejob |
char(200) |
No |
|
|
Negativejob |
char(200) |
No |
|
|
Soundsjob |
char(200) |
No |
|
|
Coloursjob |
char(200) |
No |
|
|
Favcolour |
char(50) |
No |
|
|
Favshape |
char(1) |
No |
|
|
Moodimage1 |
tinyint(1) |
No |
0 |
|
Moodimage2 |
tinyint(1) |
No |
0 |
|
Moodimage3 |
tinyint(1) |
No |
0 |
|
Moodimage4 |
tinyint(1) |
No |
0 |
|
Moodimage5 |
tinyint(1) |
No |
0 |
|
Moodimage6 |
tinyint(1) |
No |
0 |
|
Lowerimage |
char(5) |
No |
|
|
Upperimage |
char(5) |
No |
|
|
Agegroup1 |
char(255) |
No |
|
|
Agegroup2 |
char(255) |
No |
|
|
Agegroup3 |
char(255) |
No |
|
|
Agegroup4 |
char(255) |
No |
|
|
Agegroup5 |
char(255) |
No |
|
|
Jib |
19 |
Female |
Student |
Student |
Socialising |
Monotony of lectures |
Coughing, sneezing, rustling, whispering, the placing down of pens.. |
Dark blue lecture slides, white lab coats.. |
Green |
A |
6 |
4 |
2 |
5 |
1 |
3 |
Young |
Old |
Green. Laughter. Crying. |
Red. Shouting. Drum solos.. |
Blue, rhythm guitar |
Purple |
Yellow. Silence. |
|
Rob |
21 |
Male |
Student / Graphic Design |
Creative |
Lots of creativity, nice variable job. |
Can be very long hours, and relativly underpaid when starting out. |
Computers. Mouse / Keyboard clicks. Relaxed studio environment = music most of the time. Talking about projects. |
I guess i see more colours than most. I suppose as we are staring at the computer out colour pallatte is decided by our system so silvers / greys ... |
Blue / Silver |
B |
6 |
2 |
2 |
5 |
2 |
2 |
Old |
Young |
Pink / Light blue. No logo |
Dark colours Sports logos - Adidas / Nike etc |
All of the above and below. |
Green / Khaki / Jeans Blue. |
Grey / Brown |
|
Tom |
21 |
Male |
Student / illustrator |
Student |
Lots of free time - it is something that I enjoy doing |
non distict line between work and leisure |
music from my computer |
OS X layout and anything that is contained within the windows |
blue |
B |
6 |
1 |
4 |
2 |
3 |
5 |
young |
old |
light blue, pink |
dark green |
orang yellow and green |
marron |
white and grey |
|
Becca |
19 |
Female |
Student Nurse |
Student |
Working with people, training for something i want to do and the fun of being a student! Good prospects at the end of three years and a degree. |
Clearing up puke and crap all day!!! Can be emotional and upsetting. Not a normal student uni course. Long hours and lack of sleep, no money! |
Quiet, talking, occasional screams of pain/moans when on wards. Bleeping monitors, humidified oxygen bubbling. |
Blue uniforms, yellow clinical waste. NHS logo. Green equipment. |
Purple |
A |
2 |
4 |
6 |
5 |
1 |
3 |
Young |
Old |
Bright colours, games and toys logos. Laughter. |
Drinks logos, School things, parties. |
Drinks logos, work noises, paper sounds, money noise. |
Quieter |
Relaxed quiet, seaside noise? board games |
|
Tom |
23 |
Male |
Unemployed |
0 |
n/a |
n/a |
n/a |
n/a |
Blue |
A |
2 |
3 |
6 |
5 |
1 |
4 |
young |
old |
Bright Colours, Primary Colours, Loud Noises. |
Black, White, Shades of Primary Colours, Loud Noises. |
Pastels, Full Spectrum but not bright colours. |
Pastels, Full Spectrum but not bright colours. |
Greys, Browns, Greens, Beige, Darker Shades. |
|
katy |
21 |
Female |
student |
Student |
get to have creative freedom, no boundaries, set my own brief |
am skint and i hate deadlines! |
a sewing machine of all shapes and sizes- industrial and domestic |
all different types i am surrounded by metres of fabric all day. i see lots of scissors, pins needles |
blue |
a |
2 |
5 |
4 |
6 |
3 |
1 |
young |
old |
wizz pop bang! day glow colours |
hoodies, white and black |
strips, tonal colurs graphic prints |
sighing |
beige. flowers |
|
Patrick |
17 |
Male |
Student |
Student |
Friends, new things, prospects |
Boredom, Repetativeness, Limits, Authority |
Talk |
Cream - on the walls, in the blend of people - a neutral orangey cream. |
Blue |
A |
5 |
1 |
3 |
4 |
2 |
3 |
young |
old |
high pitched shouting, yellow, green - Kickers, Mc Donalds, the park |
blue, laughing, banter, drone, Fred Perry, black, enthusiasm |
Brown, Blue, "Mad frit" slow, quiet |
dark green, brown. Muttering, moaning, low, slow Marks and spencers |
Chariy Shops, grey, white, plaid, tartan, Grins, slobber, Sombre |
|
stef |
32 |
Male |
project manager |
Science |
different everyday, travel, meet people, wine and parties |
long hours (some times) |
printer, my boss talking |
red green blue |
purple |
a |
2 |
1 |
1 |
1 |
1 |
2 |
young |
old |
pop music nike etc |
none |
none |
none |
snoring |
|
none |
22 |
Female |
student |
Student |
being creative, exploring, getting hands dirty. |
competive, lots of other good designers out there. |
cars |
silver = my mac, |
blue |
a |
2 |
3 |
1 |
5 |
6 |
4 |
young |
old |
laughing, pink |
loud music, red |
busy street noise, blue |
people talking, walking, green |
gray, yellow, television |
|
jason |
35 |
Male |
technician |
Teacher |
teaching |
keeping up with the software |
computer fans and buzzing screens |
red,green & blue |
orange |
a |
2 |
1 |
3 |
6 |
1 |
4 |
old |
young |
shouting running laughing primary colours |
blacks dark reds greens |
complamentry colours blue/orange etc |
neutrals |
pastal coulours |
|
Daniel |
29 |
Male |
fashion/light designer |
Creative |
Everyday is different from the other. Meet a lot of interesting people and see a lot of good gigs. |
Staying up late, heavy lifting, unstable income. |
sewing machine and instruments |
blue, green and black |
black |
a |
5 |
3 |
1 |
6 |
2 |
6 |
young |
old |
similar brand logos, pink and sound of no social anthenas (perhapse spelt wrong) |
chewinggum sounds, cheesy pop, red, phonelogos |
gold/white, sound of speeding cars, ikea logo (establishing themselfs) |
navy blue, logo of banks (bills, housemorgage etc), sounds of reason |
beige, bingosounds, color line logo (cruise line logo) |
|
sonia |
29 |
Female |
fashion designer/ entrepreneur |
0 |
exciting colourful fun creative |
lonely poorly payed |
sewing machine mouse clicking sound a pencil makes whilst drawing sound of radio one in the background |
brown orange |
pink |
a |
2 |
5 |
6 |
4 |
1 |
3 |
young |
old |
barbie pink giggling crying coca cola scooby doo spider man blue |
black alco pops e.g bacardie breezers |
red laughing green pink |
barcardi children playing yellow |
birds singing dogs barking |
|
natalie |
23 |
Female |
none |
Creative |
dont have to get up so early |
boring |
chickens, pc fans, floorboards creeking, people talking on tv |
pc screen, dimmed lilacs & pinks, dirtied neutrals |
bright pink towards cerise |
b |
2 |
4 |
6 |
5 |
1 |
3 |
old |
young |
playing, earthy colours for boys, sweet for girls |
rowdy crowds, laughing, clubs, sports, stripes & symbols |
busy bars, work & transport, noises, clothing logos |
office/car noises, parenting, bill & bank logos, smart, suits etc |
tv, quiet & relaxed, pottering, coughing noises, war symbols, golden virginia, muted greys, pastels & pale browns |
|
none |
28 |
Female |
Solicitor |
Law |
Rewarding, Respected |
Hard work, Long hours |
Telephone, Computer, Voices |
Orange and black |
Blue |
A |
5 |
2 |
6 |
4 |
3 |
1 |
Young |
Old |
Yellow |
Purple |
Blue |
Green |
Red |
|
none |
27 |
Female |
Marketing Exec |
Creative |
lots of projects, access to senior management, help collegaues do a better job, creative aspects, always different |
admin based sometimes |
people talking if its busy or air con |
blue (our logo and creatives use blue a lot) |
red/varies |
A |
5 |
1 |
2 |
4 |
3 |
6 |
young |
old |
video games, tv, shouting, playing, |
mobile phones, talking badly, dressing badly, nike |
music, drinking, cars, |
birds (gardening), holidays - sea, young children |
gardening - green, birds, |
|
Roger |
54 |
Male |
Estimator |
Creative |
New Projects |
Information overload |
printer and aircon |
white and grey |
blue |
A |
6 |
3 |
4 |
5 |
1 |
2 |
Young |
Young |
Pink shrill voices |
Noise Brown |
phones black |
voices brown |
breathin brown |
|
Kit |
19 |
Male |
Artist and Designer |
Creative |
Doing what I love, meeting beautiful people and doing exciting things |
Long hours, stress |
none |
none |
Blue |
B |
4 |
1 |
6 |
5 |
1 |
3 |
young |
old |
none |
none |
none |
none |
none |
|
Zoe |
25 |
Female |
admin |
Office |
good team, social |
boring work sometimes |
a/c, computers, phones, talking |
beige, white, blue square |
purple/pink |
a |
2 |
4 |
6 |
5 |
1 |
3 |
young |
old |
bright colours |
hoodies, sport |
new business deals, activity |
having family, dinners |
slippers, pipe and worn tarten blankets! |
|
none |
26 |
Female |
fashion designer |
Creative |
creative |
mostly deskbound |
computer noise |
colour palette of the forthcoming season! |
blue |
a |
6 |
1 |
3 |
4 |
2 |
5 |
young |
old |
primary colours, pastel shades. |
bright colours/ black |
black, cream, |
red |
grey, beige |
|
Joseph |
23 |
Male |
Designer |
Creative |
Draw pictures all the time, and listen to I-Tunes. |
No friggin jobs out there! |
Click click, tap tap. |
White, blue, green and grey. |
blue |
a |
2 |
4 |
1 |
5 |
3 |
6 |
young |
old |
yellow mcdonalds bleeps |
white,grey nike loud bleeps |
green, brown, Costa bleeps (phones) |
black, white, MORPHY RICHARDS car locks on doors |
white. Specsavers small change - pennys |
|
Josie |
21 |
Female |
Student |
Student |
Gives you a chance to practice and develop your knowledge for a future career |
Mostly poor |
Music, computer keyboard tapping |
Navy, Red |
Blue |
A |
5 |
2 |
1 |
3 |
6 |
4 |
Young |
Old |
Loud tapping sounds, Red |
Arguing, Red |
Music, Blue |
Music, Green |
Peace-no noise, Green |
|
Devon |
47 |
Female |
Construction |
Office |
Interesting work, decently paid |
Not as interesting as arts/humanities |
Talking |
grey, beige,blue |
red |
a |
6 |
3 |
5 |
2 |
1 |
4 |
young |
old |
primary colours, metallics, O2, giggling |
Gant, Carhartt, Nike, Vodaphone, shouting, heavy bass, navy blue, black, house/trance music, Burberry |
Stella McCartney, bright pastels, soft rock/ pop music |
black, brown, Prada |
waves on the shore (sound), white, cream, light blue |
|
Paul |
38 |
Male |
Electrical Engineer |
0 |
Working within the construction industry provides a wide range of sectors/clients to choose from. |
too much competition and not enough niche markets. |
mobile phones on trains whilst commuting, road traffic and office telephones. |
black or dark clothing (especially winter time) computers i.e.Microsoft, Google & MSN. |
Blue |
A |
2 |
5 |
4 |
1 |
3 |
6 |
Old |
Young |
Childrens TV tunes, Pink, sweets |
Ring tones, pop music, bright colours, sports wear logos |
music, browns, designer logos |
brown, green, red |
grey, blue, daytime TV |
|
stacy |
22 |
Female |
student / waitress |
Science |
you can do it when you want / you meet people and make money |
gets boring and repetative, contantly need motivation and encoragement / making mistakes, working with the public constantly. |
typing, music, talking, ther sound of the mac being turned on / talking, shouting, sound of footsteps, sound of water, platescrashing together |
blue, yellow red,/ red, purple people, children, food, |
pink |
a |
2 |
1 |
6 |
5 |
4 |
3 |
young |
old |
pink blue |
red |
clothes labels |
cream |
brown, sound of a breaze |
|
none |
48 |
Female |
orientationist and tour guide |
Teacher |
Out of office Meeting new people Enjoy the job |
Driving in |
Traffic |
All the company signs on buildings in the ciry Camels at the race track Electricity pylons Blue creek Blue skies |
Blue |
a |
2 |
5 |
6 |
1 |
3 |
4 |
old |
young |
hip hop & pop reds, yellows |
hip hop & pop & rave black & white |
rave & new age & rock black & white |
rock & roll all the colours of the rainbow |
Classic music beige / crimson |
|
Rufus |
45 |
Female |
Political Visionary |
Creative |
Leadership, ideas, forward thinking, discipline, wanton destruction |
Bad hours. Negotiations. The new terrorist laws.. |
Gunfire, screams of agony, bomb shells, my own voice (speeches) |
Red, amnesty international logo, red cross, |
Red |
A |
2 |
4 |
6 |
5 |
1 |
3 |
Young |
Old |
Crying, weakness |
Revolution, gunfire. |
Revolution, strategy |
Conformists |
Useless |
|
wiliam |
9 |
Male |
school |
Student |
playing, science, itc - working with computers |
hard work, homework |
kids shouting |
blue, green, yellow |
red |
a |
2 |
3 |
4 |
1 |
6 |
4 |
young |
old |
toy sounds |
talking, music |
shouting |
chattering, cooks, types, cleaning, washing machine |
tv, light pink |
|
jane |
53 |
Female |
legal secretary |
Law |
interesting nice hours |
low pay |
voices phone ringing computer sounds |
white blue grey |
red |
a |
6 |
4 |
2 |
5 |
1 |
3 |
old |
young |
circles toys |
orange music cars |
computers music |
vacuum computers voices music red |
pink yellow sound of waterr |
|
Chantal |
34 |
Female |
Mother |
Creative |
Hearing my kids laugh |
Lack of sleep |
Laughter, Crying, New words, television, hoover, barking |
I see every colour. |
Blue |
A |
2 |
5 |
3 |
6 |
1 |
4 |
Young |
Old |
Pop music, laughter, playing, crying, all bright colours, |
stroppy arguments, cheap motorbikes, noisey bars, khaki, blue, olive, cream, |
bars, cars, music, olive, blue, cream |
television, music, brown, cream, |
shouting, television, brown |
|
Ryan |
24 |
Male |
Student |
Student |
I dont have to work in a job i hate. Also learn new things all the time and progress my knowledge & chosen skils. I feel i am becoming a more compleate person as i continue doing what i enjoy. |
I never have much money. Well except for student loan day!! |
The humming of my PC. |
Cream is the colour of my room so that is the colour i see the most. |
Blue |
A |
2 |
4 |
1 |
5 |
4 |
2 |
Young |
Old |
High pitched voices, |
Mobile phones, Loud music |
Pub noice, Mobile Phones, |
Day time Tv, Soap theme tunes, Old music. |
Classical music, Day time Tv, Eastenders and such |
|
Lisa |
35 |
Female |
teacher |
Teacher |
rewarding, stimulating, fun, school holidays |
can be stressful at times |
children |
many colours and images as i work in a nin uniform school and very stimulating colourful classroom full of childrens own work |
orange |
A |
4 |
2 |
6 |
5 |
1 |
4 |
YOUNG |
OLD |
PINK PURPLE RED |
BLUE SILVER WHITE LOUD MUSIC |
BLACK BLUE |
BLACK PINK |
GREEN BROWN |
|
none |
36 |
Male |
sales |
Office |
fairly easy work, meet customers |
boring, dealing with customer complaints |
forklift, talking |
blue, yellow |
blue |
b |
2 |
4 |
6 |
5 |
1 |
3 |
young |
old |
bright colours, toys, laughter |
school, text books, chalk board. drinking |
clubbing, pubbing, dinners, outings |
driving, business |
golf |
|
none |
40 |
Female |
Doctor |
Emergency |
Helping those in need. Challenging work environment. Team work. Intellectually stimulating. |
Abuse, stress, workload. Fear of failure and consequent lawsuits, pressure of constant professionalism, losing my stethoscope. |
Obs machines, coughing, complaints, footsteps, talking, phones, pagers, lots of beeping.. |
stethoscopes, blue scrubs, white paper and folders, IVs |
green |
A |
2 |
4 |
6 |
5 |
1 |
3 |
young |
old |
crying, yellow |
laughing, singing, shouting music television, red. |
discussion, cars, offices, orange. |
gazeebos, pimms, blue. |
white, the ocean, benches, pigeons |
|
Capn Jen |
67 |
Female |
Army psychiatrist |
Emergency |
...comfy sofas. The ability to help others through the dark times, watch them change and improve into better, stronger, shiner people and then release them back into the community. |
When they inevitably forget to take their pills and slaughter the community., |
screaming, crying, shouting, talking. |
red, white, oh the white.. |
white. |
A |
2 |
4 |
6 |
5 |
3 |
1 |
old |
young |
white, purity |
arguments with parents, suicide, red |
holiday, blue |
murder, psychosis maroon |
valium black |
|
tony |
24 |
Male |
animation student |
Student |
creative, working in 3d |
long hours, large workload, need alot of patience |
computer hum, screen flicker, animation sounds |
whatever the character needs |
navy blue |
b |
2 |
4 |
6 |
5 |
1 |
3 |
young |
old |
bold colours |
mid colours, browns and yellows, pink |
duller colours, jeans |
greens, blues, pale |
pastel colours, grey, silver hair |
|
Sharlene |
24 |
Female |
animation student |
Student |
highly creative, varied work - backgrounds, animation, charaters, story etc |
long hours, hard work - patience |
talking, screen flicker, computers switching on/off |
red/brown, and multi colours |
red/pink |
a |
2 |
4 |
6 |
5 |
1 |
3 |
young |
old |
playing, nursery, fads |
puperty - shouting, drinking |
first job, money logo |
family, chors, farmhouse colours |
retierment homes, white, grey, pastel colours |
|
Julie |
72 |
Female |
retired |
0 |
spend time with all the family, relaxing, spend time with friends |
dull sometimes, getting older by the day-forgetfull |
talking, children running about |
mainly white |
light pink |
a |
2 |
6 |
4 |
5 |
1 |
3 |
young |
old |
building blocks, wooden toys, rocking horse |
courting |
marriage |
working, business and family |
pension book, retirement, family |
|
none |
50 |
Male |
postman |
Outdoor |
exercise, outdoor-fresh air, teamwork and valuable service |
the hours-inconvienient |
birds singing, sorting machine |
red and yellow |
blue |
b |
2 |
4 |
6 |
5 |
1 |
3 |
young |
old |
loud toy sounds |
learning to drive, socialising |
recent fashion colours |
none |
pastels, greys |
|
none |
28 |
Male |
none |
0 |
none |
no money |
none |
tv |
navy |
b |
2 |
5 |
6 |
4 |
4 |
3 |
young |
old |
none |
none |
none |
none |
none |
|
none |
16 |
Female |
school |
Student |
socialising |
working, revising for GCSEs |
shouting, running, talking, teachers moaning |
green and yellow |
yellow |
a |
2 |
1 |
6 |
5 |
1 |
3 |
young |
old |
shouting |
drinking |
working |
family |
caring for them |
|
none |
33 |
Male |
retail manager |
Office |
flexible, meet people, friendly office environment |
customer complaints, low wage for work put in |
computers, talk, customers, phones |
blue, white, pale green |
green |
b |
2 |
3 |
6 |
5 |
1 |
3 |
young |
old |
primary bright colours |
none, drinking smoking babies! |
cars, bbqs |
none |
wrinkles |
|
Phil |
19 |
Male |
Student |
Student |
It is fun. |
It also mean that I will be heavily in debt after a few years. |
People talking, pencils scribbling, paper moving. |
Blue and white. |
Brown. |
A |
2 |
4 |
6 |
5 |
3 |
1 |
old |
young |
yellow, screaming |
green, complaining |
red, shouting |
Burgandy, laughing |
beige, grumbling |
|
jerry |
37 |
Male |
construction |
Outdoor |
fresh air, get to build stuff, good exercise |
out in most weathers, not great pay, hard labour |
traffic, cement mixer, power tools and heavy machinary |
red, bright yellow safty vests and helmuts, orange and yellow |
dark red |
b |
2 |
4 |
6 |
5 |
1 |
2 |
young |
old |
crawling, bibs, high chairs, playing and crying |
going out, first times, sex |
finding your career path |
family |
death |
|
Rebecca |
21 |
Female |
Student |
Student |
Constant learning and self development. Every day is different. |
Peoples perceptions of studnets and the debts! |
I listen to the radio all day! |
Cameras... etc |
Pink |
A |
5 |
3 |
2 |
1 |
4 |
6 |
OLD |
YOUNG |
Primary yellows and greens. Yelling in excitement, tears. Teddy bears, toys etc |
Pink, purple, navy blue. Heavy rock music. Muttering. Silence. |
Whites and blacks. Wide spectrum of colours. Fashionable colurs Dance music. Pub sounds. |
Pastel shades. Pushchairs, shcools, cooking sounds. |
Beige, brown, khaki. Silence. Bus sunds. The news in the background. |