CREATE TABLE driver
( driver_id NUMBER(10) NOT NULL PRIMARY KEY,
  first_name VARCHAR2(25),
  middle_name  VARCHAR2(25),
  last_name  VARCHAR2(25),
  gender VARCHAR2(1),
  date_of_birth DATE,
  license_points NUMBER(4,2) default 0,
  comments CLOB,
  address_id NUMBER(10),
  contact_info_id NUMBER(1),
  created DATE,
  updated DATE
)

CREATE SEQUENCE DRIVER_SEQ 
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    NOMAXVALUE
    NOCYCLE
    NOCACHE
    ORDER


CREATE TABLE car (
   car_id NUMBER(10) NOT NULL PRIMARY KEY,
   driver_id NUMBER(10),
   make VARCHAR2(10), 
   model VARCHAR2(10), 
   year NUMBER(4),
   mileage NUMBER(10),
   created DATE,
   updated DATE
)

CREATE SEQUENCE CAR_SEQ 
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    NOMAXVALUE
    NOCYCLE
    NOCACHE
    ORDER



CREATE TABLE driver_address (
   address_id NUMBER(10) NOT NULL PRIMARY KEY,
   address_line1 VARCHAR2(30),
   address_line2 VARCHAR2(30),
   city VARCHAR2(30),
   state VARCHAR2(2),
   zip NUMBER(5),
   date_moved_in  DATE,
   created DATE,
   updated DATE
)

CREATE SEQUENCE DRIVER_ADDRESS_SEQ
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    NOMAXVALUE
    NOCYCLE
    NOCACHE
    ORDER

CREATE TABLE contact_info (
   contact_info_id NUMBER(10) NOT NULL PRIMARY KEY,
   home_phone      VARCHAR2(30),
   work_phone      VARCHAR2(30),
   email_address   VARCHAR2(100),
   created         DATE,
   updated         DATE
 )


CREATE SEQUENCE CONTACT_INFO_SEQ
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    NOMAXVALUE
    NOCYCLE
    NOCACHE
    ORDER