TABLE

COLUMN NAME

NULL

Type

Constraint

DEFINITION

CUSTOMER

cust_id

not null

NUMBER(6)

PK

Unique Customer ID

cont_lname

not null

VARCHAR2(25)

Contact Last name

cont_fname

null

VARCHAR2(25)

Contact First name

co_name

null

VARCHAR2(25)

Company Name

lname

null

VARCHAR2(25)

Driver Last Name

fname

null

VARCHAR2(25)

Driver First Name

address

null

VARCHAR2(25)

Street address

city

null

VARCHAR2(25)

City

state

null

VARCHAR2(25)

State or Provence

country

null

VARCHAR2(25)

Country

postal_code

null

VARCHAR2(25)

Postal Code

phone

null

VARCHAR2(25)

Phone including area code

license_state

null

VARCHAR2(25)

Driver's License State

license_no

null

VARCHAR2(25)

Driver's License Number

dob

null

DATE

Driver's date of birth

RESERVATION

resv_id

not null

NUMBER(6)

PK

Reservation Number

cust_id

null

NUMBER(6)

Customer Number

pick_up_period

null

DATE

Date & Time of Pickup

pick_up_site

null

VARCHAR2(25)

Location of Pickup

drop_off_period

null

DATE

Date & Time of Dropoff

drop_off_site

null

VARCHAR2(25)

Location of Dropoff

cc_no

null

VARCHAR2(25)

Credit Card Number

cc_type

null

VARCHAR2(25)

Master Card or Visa

cc_exp

null

VARCHAR2(25)

Credit Card Expiration date

last_name

not null

VARCHAR2(25)

Last Name

first_name

null

VARCHAR2(25)

First Name

car _type

not null

VARCHAR2(25)

Kind of car (subcompact, compact, full size)

emp_id

null

VARCHAR2(25)

Employee Number

quantity

null

NUMBER(3)

Number of Cars Reserved

comments

null

VARCHAR2(350)

Comments

option_id

null

NUMBER(6)

Options

RENTAL

rental_id

not null

NUMBER(6)

PK

Rental ID Number

resv_id

null

NUMBER(6)

Reservation ID

cust_id

not null

NUMBER(6)

Customer Number

pick_up_period

not null

DATE

Date & Time of Pickup

pick_up_site

null

VARCHAR2(25)

Location of Pickup

drop_off_period

not null

DATE

Date & Time of Drop-off

drop_off_site

null

VARCHAR2(25)

Location of Drop-off

car_type

not null

VARCHAR2(25)

Kind of car (subcompact, compact, full size)

car_status

null

VARCHAR2(25)

Car Availability

cc_no

null

VARCHAR2(25)

Credit Card Number

cc_type

null

VARCHAR2(25)

Master Card or Visa

cc_exp

null

VARCHAR2(25)

Expiration date

cc_auth_no

null

VARCHAR2(25)

Credit Card Authorization Number

driver_license_no

null

VARCHAR2(25)

Driver's License Number

emp_id

null

NUMBER(6)

Employee Number

car_reg_no

not null

VARCHAR2(25)

Car Registration Number

payment_meth

null

VARCHAR2(25)

Cash or Credit Card

daily_rate

null

NUMBER(4,2)

Rate Guaranteed at Reservation

PARKING LOT

space_id

not null

NUMBER(6)

PK

Location Unique ID

lot_name

null

VARCHAR2(25)

Name of Lot within a site

row

null

VARCHAR2(25)

PK

Row in parking lot

parking_space_no

null

VARCHAR2(25)

PK

Parking Space Number

site_name

null

VARCHAR2(25)

Office Location

address

null

VARCHAR2(25)

Office street address

city

null

VARCHAR2(25)

Office street address

state

null

VARCHAR2(25)

State or Provence

postal_code

null

VARCHAR2(25)

zip code

phone

null

VARCHAR2(25)

phone

manager

null

VARCHAR2(25)

Site Manager's Name

total_spaces

null

NUMBER(6)

Number of Parking Spaces/Lot

directions

null

VARCHAR2(250)

Directions to Car

CAR

vin

not null

VARCHAR2(20)

PK

Vehicle Identification Number

car_type_id

not null

NUMBER(6)

Size & Price of Car

car_status_id

null

NUMBER(6)

Indicates Availability

location_id

null

NUMBER(6)

Indicates parking location

make

null

VARCHAR2(20)

Make of Car

model

null

VARCHAR2(20)

Model of Car

car_reg_no

null

VARCHAR2(20)

Plate Number of Car

color

null

VARCHAR2(20)

Car Color

year

null

VARCHAR2(20)

Year of Car

reg_state

null

VARCHAR2(20)

State car is registered in

reg_expiration

null

VARCHAR2(20)

Expiration date of Car Registration

mileage

null

NUMBER(6)

Current Mileage

CAR_STATUS

Car_Status_ID

not null

NUMBER(6)

PK

Unique ID for Car Status table

vin

not null

VARCHAR2(20)

Vehicle Identification Number

available_flag

null

CHAR(3)

Returns Yes is Car is Available

rented_flag

not null

CHAR(3)

Set to yes if car is currently rented

returned_flag

not null

CHAR(3)

Set to yes is car is returned from rental

fleet_car_flag

null

CHAR(3)

Leased Car yes or no, yes indicates yes

CAR_RATE

Car_type_id

not null

NUMBER(6)

Size & Price of Car Unique ID

rate

null

NUMBER(4,2)

Daily Rate of Car

Description

null

VARCHAR2(20)

Size of Car (subcompact, compact, or full size)

EMPLOYEE

emp_id

not null

NUMBER(6)

Employee ID

dept_name

null

VARCHAR2(25)

Department Number

ss_no

null

VARCHAR2(25)

Social Security Number

emp_no

null

VARCHAR2(25)

Employee Number

fname

null

VARCHAR2(25)

First Name

lname

null

VARCHAR2(25)

Last Name

e_mail

null

VARCHAR2(25)

E-mail address

address

null

VARCHAR2(50)

Street address

city

null

VARCHAR2(25)

City

state

null

VARCHAR2(25)

State or Provence

country

null

VARCHAR2(25)

Country

postal_code

null

VARCHAR2(25)

Postal Code

home_phone

null

VARCHAR2(25)

Phone including area code

work_phone

null

VARCHAR2(25)

Work Phone

dept_id

null

VARCHAR2(25)

Department ID

dob

null

DATE

Date of Birth

date_hired

null

DATE

Date Hired

salary

null

NUMBER(7,2)

Salary

emrgncy_cont

null

VARCHAR2(25)

Emergency Contact

emrgncy_cont_phone

null

VARCHAR2(25)

Emergency Contact Phone Number

office

null

VARCHAR2(25)

Office Working in