Welcome to UK Golf Courses Database
Description:
This database includes golf courses with high detailed information and it's completely uptodate(2008).
Please be sure that this is the newest version and 4th version of "UK Golf Courses Database" with completely uptodate(2008) datas.
Regarding to "old" customers, if you're an old customer for the previous "UK Golf Courses Database", please inform us.
The database is available with SQL and EXCEL versions.
Fields:
1) ID
2) CAT
3) COURSE NAME
4) ADDRESS1
5) ADDRESS2
6) TOWN
7) POSTCODE
8) SECRETARY NAME
9) SECRETARY PHONE
10) SECRETARY FAX
11) WEBSITE
12) EMAIL
13) COURSE INFO PHONE
14) PROFESSIONAL
15) PROFESSIONAL PHONE
16) NUMBER OF HOLES
17) YARDAGE
18) PAR
19) YARDAGE MARKERS
20) CHANGING ROOMS
21) HANDICAP CERTIFICATE
22) DRIVING RANGE
23) SOFTSPIKES REQUIRED
24) SOCIETY
25) CLUB TYPE
26) COURSE TYPE
27) GREENFEES WEEKDAYS
28) GREENFEES WEEKENDS
29) PROSHOP
30) CLUBHIRE
31) CLUBREPAIR
32) CUSTOM FIT
33) TROLLEY HIRE
34) ELECTRIC ROLLEY REPAIR
35) BUGGY HIRE
36) LESSONS
37) COURSE PLANNER
38) BAR
39) BREAKFAST
40) LUNCH
41) AFTERNOON TEA
42) DINNER
43) ACCOMODATION
Structure:
Sample from db:PHP Code:CREATE TABLE ukgolf
(
ID int,
CAT varchar(255),
COURSENAME varchar(255),
ADDRESS1 varchar(255),
ADDRESS2 varchar(255),
TOWN varchar(255),
POSTCODE varchar(255),
SECRETARYNAME varchar(255),
SECRETARYPHONE varchar(255),
SECRETARYFAX varchar(255),
WEBSITE varchar(255),
EMAIL varchar(255),
COURSEINFOPHONE varchar(255),
PROFESSIONAL varchar(255),
PROFESSIONALPHONE varchar(255),
NUMBEROFHOLES varchar(255),
YARDAGE varchar(255),
PAR varchar(255),
YARDAGEMARKERS varchar(255),
CHANGINGROOMS varchar(255),
HANDICAPCERTIFICATE varchar(255),
DRIVINGRANGE varchar(255),
SOFTSPIKESREQUIRED varchar(255),
SOCIETY varchar(255),
CLUBTYPE varchar(255),
COURSETYPE varchar(255),
GREENFEESWEEKDAYS varchar(255),
GREENFEESWEEKENDS varchar(255),
PROSHOP varchar(255),
CLUBHIRE varchar(255),
CLUBREPAIR varchar(255),
CUSTOMFIT varchar(255),
TROLLEYHIRE varchar(255),
ELECTRICROLLEYREPAIR varchar(255),
BUGGYHIRE varchar(255),
LESSONS varchar(255),
COURSEPLANNER varchar(255),
BAR varchar(255),
BREAKFAST varchar(255),
LUNCH varchar(255),
AFTERNOONTEA varchar(255),
DINER varchar(255),
ACCOMODATION varchar(255)
)ENGINE=MyISAM DEFAULT CHARACTER SET utf8;
Filetypes: SQL and EXCELPHP Code:INSERT INTO `ukgolf` VALUES(1, '3', '3 Hammers Golf Complex', 'Old Stafford Road', 'Coven', 'Wolverhampton', 'WV10 7PP', 'Julian Chesson', '1902790428', '1902791777', 'www.3hammers.co.uk', 'info@3hammers.co.uk', '1902790428', 'Andrew Proudman, Piers Ward & Martin OConnor', '1902790428', '18 Hole', '1438', '54', 'No', 'Yes', 'No', 'Yes', 'No', 'Mon , Tue , Wed , Thur', 'Pay&Play', 'Parkland', '', '', 'Yes', 'No', 'Yes', 'Yes', 'No', 'No', 'No', 'Yes', 'No', 'Yes', 'No', 'Yes', 'No', 'Yes', 'No');
Records: 3.037
Price: 69$
Regards



