-
Notifications
You must be signed in to change notification settings - Fork 0
/
caratrent_db.doc
10 lines (9 loc) · 37.9 KB
/
caratrent_db.doc
1
2
3
4
5
6
7
8
9
10
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-type" content="text/html;charset=utf-8" />
</head>
<body><h1>Database caratrent_db</h1><h2>Table structure for table admin</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><b>UserName</b></td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Password</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">updationDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">0000-00-00 00:00:00</td></tr></table><h2>Table structure for table admin</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><b>UserName</b></td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Password</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">updationDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">0000-00-00 00:00:00</td></tr></table><h2>Table structure for table driver</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><b>d_id</b></td><td class="print">int(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">d_name</td><td class="print">varchar(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">pwd</td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">d_add</td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">d_contact</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><b>car_id</b></td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><i><b>d_email</b></i></td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">base_charge</td><td class="print">varchar(6)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">wait_charge</td><td class="print">varchar(6)</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table driver</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><b>d_id</b></td><td class="print">int(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">d_name</td><td class="print">varchar(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">pwd</td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">d_add</td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">d_contact</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><b>car_id</b></td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><i><b>d_email</b></i></td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">base_charge</td><td class="print">varchar(6)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">wait_charge</td><td class="print">varchar(6)</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table payment</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>p_id</b></i></td><td class="print">int(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">userid</td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">p_status</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">car_name</td><td class="print">varchar(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">email_id</td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">car_id</td><td class="print">varchar(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">amount</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">contact</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">book_date</td><td class="print">datetime</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">p_date</td><td class="print">datetime</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table payment</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>p_id</b></i></td><td class="print">int(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">userid</td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">p_status</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">car_name</td><td class="print">varchar(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">email_id</td><td class="print">varchar(30)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">car_id</td><td class="print">varchar(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">amount</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">contact</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">book_date</td><td class="print">datetime</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">p_date</td><td class="print">datetime</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tblbooking</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">userEmail</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">VehicleId</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">contact_no</td><td class="print">tinytext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">s_add</td><td class="print">tinytext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">d_add</td><td class="print">tinytext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">FromDate</td><td class="print">datetime</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ToDate</td><td class="print">datetime</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">message</td><td class="print">varchar(255)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Status</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PostingDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr></table><h2>Table structure for table tblbooking</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">userEmail</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">VehicleId</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">contact_no</td><td class="print">tinytext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">s_add</td><td class="print">tinytext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">d_add</td><td class="print">tinytext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">FromDate</td><td class="print">datetime</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ToDate</td><td class="print">datetime</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">message</td><td class="print">varchar(255)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Status</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PostingDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr></table><h2>Table structure for table tblbrands</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">BrandName</td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">CreationDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">UpdationDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">0000-00-00 00:00:00</td></tr><tr class="print-category"><td class="print">color</td><td class="print">varchar(15)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">seat</td><td class="print">int(3)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">fuel_type</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">no_of_pieces</td><td class="print">int(4)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">available</td><td class="print">varchar(3)</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tblbrands</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">BrandName</td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">CreationDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">UpdationDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">0000-00-00 00:00:00</td></tr><tr class="print-category"><td class="print">color</td><td class="print">varchar(15)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">seat</td><td class="print">int(3)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">fuel_type</td><td class="print">varchar(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">no_of_pieces</td><td class="print">int(4)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">available</td><td class="print">varchar(3)</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tblcontactusinfo</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Address</td><td class="print">tinytext</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print"><b>EmailId</b></td><td class="print">varchar(255)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ContactNo</td><td class="print">char(11)</td><td class="print">Yes</td><td class="print">NULL</td></tr></table><h2>Table structure for table tblcontactusinfo</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Address</td><td class="print">tinytext</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print"><b>EmailId</b></td><td class="print">varchar(255)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ContactNo</td><td class="print">char(11)</td><td class="print">Yes</td><td class="print">NULL</td></tr></table><h2>Table structure for table tblcontactusquery</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">name</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">EmailId</td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ContactNumber</td><td class="print">char(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Message</td><td class="print">varchar(200)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PostingDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">status</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tblcontactusquery</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">name</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">EmailId</td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ContactNumber</td><td class="print">char(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Message</td><td class="print">varchar(200)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PostingDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">status</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tblpages</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PageName</td><td class="print">varchar(255)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">type</td><td class="print">varchar(255)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">detail</td><td class="print">longtext</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tblpages</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PageName</td><td class="print">varchar(255)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">type</td><td class="print">varchar(255)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">detail</td><td class="print">longtext</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tblsubscribers</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><b>SubscriberEmail</b></td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PostingDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr></table><h2>Table structure for table tblsubscribers</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><b>SubscriberEmail</b></td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PostingDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr></table><h2>Table structure for table tbltestimonial</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">UserEmail</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Testimonial</td><td class="print">mediumtext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PostingDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">status</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tbltestimonial</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">UserEmail</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Testimonial</td><td class="print">mediumtext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PostingDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">status</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr></table><h2>Table structure for table tblusers</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print">id</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">FullName</td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><i><b>EmailId</b></i></td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Password</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ContactNo</td><td class="print">varchar(25)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">dob</td><td class="print">date</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Address</td><td class="print">varchar(255)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">City</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Country</td><td class="print">varchar(100)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">RegDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">UpdationDate</td><td class="print">timestamp</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">status</td><td class="print">varchar(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">img</td><td class="print">blob</td><td class="print">Yes</td><td class="print">NULL</td></tr></table><h2>Table structure for table tblusers</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print">id</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">FullName</td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print"><i><b>EmailId</b></i></td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Password</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ContactNo</td><td class="print">varchar(25)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">dob</td><td class="print">date</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Address</td><td class="print">varchar(255)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">City</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Country</td><td class="print">varchar(100)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">RegDate</td><td class="print">timestamp</td><td class="print">No</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">UpdationDate</td><td class="print">timestamp</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">status</td><td class="print">varchar(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">img</td><td class="print">blob</td><td class="print">Yes</td><td class="print">NULL</td></tr></table><h2>Table structure for table tblvehicles</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">VehiclesTitle</td><td class="print">varchar(150)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">VehiclesBrand</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">VehiclesOverview</td><td class="print">longtext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PricePerDay</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">FuelType</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ModelYear</td><td class="print">int(6)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">SeatingCapacity</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Vimage1</td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Vimage2</td><td class="print">varchar(120)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Vimage3</td><td class="print">varchar(120)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Vimage4</td><td class="print">varchar(120)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Vimage5</td><td class="print">varchar(120)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">AirConditioner</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PowerDoorLocks</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">AntiLockBrakingSystem</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">BrakeAssist</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PowerSteering</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">DriverAirbag</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PassengerAirbag</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PowerWindows</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">CDPlayer</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">CentralLocking</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">CrashSensor</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">LeatherSeats</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">RegDate</td><td class="print">timestamp</td><td class="print">Yes</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">UpdationDate</td><td class="print">timestamp</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">color</td><td class="print">varchar(15)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Driver_id</td><td class="print">int(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">base_rate</td><td class="print">int(5)</td><td class="print">Yes</td><td class="print">NULL</td></tr></table><h2>Table structure for table tblvehicles</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><b>Type</b></td><td class="print"><b>Null</b></td><td class="print"><b>Default</b></td></tr><tr class="print-category"><td class="print"><i><b>id</b></i></td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">VehiclesTitle</td><td class="print">varchar(150)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">VehiclesBrand</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">VehiclesOverview</td><td class="print">longtext</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PricePerDay</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">FuelType</td><td class="print">varchar(100)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">ModelYear</td><td class="print">int(6)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">SeatingCapacity</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Vimage1</td><td class="print">varchar(120)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">Vimage2</td><td class="print">varchar(120)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Vimage3</td><td class="print">varchar(120)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Vimage4</td><td class="print">varchar(120)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Vimage5</td><td class="print">varchar(120)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">AirConditioner</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PowerDoorLocks</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">AntiLockBrakingSystem</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">BrakeAssist</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PowerSteering</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">DriverAirbag</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PassengerAirbag</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">PowerWindows</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">CDPlayer</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">CentralLocking</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">CrashSensor</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">LeatherSeats</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">RegDate</td><td class="print">timestamp</td><td class="print">Yes</td><td class="print">CURRENT_TIMESTAMP</td></tr><tr class="print-category"><td class="print">UpdationDate</td><td class="print">timestamp</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">color</td><td class="print">varchar(15)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">Driver_id</td><td class="print">int(20)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">base_rate</td><td class="print">int(5)</td><td class="print">Yes</td><td class="print">NULL</td></tr></table></body></html>