Geno Anthony M.Tombiga

Maramag Car Rental system database 

table name =admin

admin_id = primary key, auto_incremental
name - varchar(50) 
contact -  varchar(11) 
address - varchar(100) 
username -  varchar(30)
password - varchar(30) 


table name = car

car_id = primary key, auto_incremental
car_name - varchar(30) 
description - varchar(100) 
car_model_year -  int(4) 
car_brand - varchar(25) 
color - varchar(15) 
plate_number -  varchar(11)
rate -  float 
owner_id - int(11) 
status - int(2)

table name = carimage

image_id = primary key, auto_incremental
image_description -  varchar(50)
car_id - int(11) 

table name = carreview

review_id = primary key, auto_incremental
review - varchar(100) 
review_score -  int(1) 
date - date 
customer_id -  int(11)
car_id -  int(11) 

table name = customer 

customer_id = primary key, auto_incremental
customer_name - varchar(50) 
address - varchar(100) 
contact - varchar(11) 
profile_image - blob 
fb_account - varchar(50) 

table name = customercredential

credential_id = primary key, auto_incremental
credential_name - varchar(30) 
file_upload - blob 
customer_id - int(11)

table name = carowner

owner_id = primary key, auto_incremental
owner_name - varchar(50) 
address - varchar(100) 
contact - varchar(11) 
profile_image - blob 
fb_account - varchar(50)

table name = payment

payment_id = primary key, auto_incremental
rental_id - int(11)
payment_amount - float 
add_charges - float 
payment_date - date 
admin_id - int(11)