
--
-- Database: `golfleague`
--
DROP SCHEMA IF EXISTS golfleague;
CREATE SCHEMA golfleague;
USE golfleague;
-- --------------------------------------------------------

--
-- Table structure for table `golfers`
--


 CREATE TABLE `golfleague`.`golfers` (
`golfer_id` INT NOT NULL ,
`last_name` VARCHAR( 20 ) NOT NULL ,
`first_name` VARCHAR( 20 ) NOT NULL ,
`status` VARCHAR( 10 ) NOT NULL ,
PRIMARY KEY ( `golfer_id` )
) TYPE = MYISAM ;

--
-- Table structure for table `handicaps`
--

 CREATE TABLE `golfleague`.`handicaps` (
`handicap_id` INT NOT NULL ,
`date` DATE NOT NULL ,
`golfer_id` INT NOT NULL ,
`handicap` INT NOT NULL ,
PRIMARY KEY ( `handicap_id` )
) TYPE = MYISAM ;

--
-- Table structure for table `rounds`
--

 CREATE TABLE `golfleague`.`rounds` (
`round_id` INT NOT NULL ,
`golfer_id` INT NOT NULL ,
`date` DATE NOT NULL ,
`handicap_id` INT NOT NULL ,
`course` CHAR( 20 ) NOT NULL ,
`score` INT NOT NULL ,
`points` INT NOT NULL ,
PRIMARY KEY ( `round_id` )
) TYPE = MYISAM ;

