Free Student Projects

Follow

Advertisement

Vehicle Showroom Database design

Share

The design of Vehicle Showroom database tables are shown below:

Tablename : admin

Sl.no

Attribute

Data Type

Description

Constraints

1.

adminid

int(10)

Administrator id

Primary key

2.

adminname

varchar(25)

Administrator name

3.

username

varchar(25)

User name

4.

password

varchar(25)

Password

5.

contactnumber

varchar(25)

Phone number

6.

createdat

date

Created time

7.

lastlogin

datetime

Last login time

8.

status

varchar(10)

status

Tablename: customer

Sl.no

Attribute

Data Type

Description

Constraints

1.

custid

int(10)

Customerid

Primary key

2.

fname

varchar(25)

First name

3.

lname

varchar(25)

Last name

4.

contactno

varchar(25)

Phone number

5.

emailid

varchar(25)

Email id

6.

password

varchar(25)

Password

7.

address

text

Address

8.

city

varchar(20)

City

9.

state

varchar(20)

Status

10.

country

varchar(50)

Country

11.

pincode

varchar(10)

Pincode

12.

gender

varchar(10)

Gender

13.

createdat

date

Created time

14.

lastlogin

datetime

Last login time

15.

status

varchar(10)

Status

Advertisement

Tablename: dealer

Sl.no

Attribute

Data Type

Description

Constraints

1.

dealerid

int(10)

Dealer id

Primary key

2.

adminid

int(10)

Administrator id

Foreign key

3.

companyname

varchar(25)

Company name

4.

imgid

int(10)

Image id

5.

fname

varchar(25)

Fisrt name

6.

lname

varchar(25)

Last name

7.

username

varchar(25)

User name

8.

password

varchar(25)

Password

9.

contactnumber

varchar(15)

Phone number

10.

address

text

Address

11.

createdat

date

Created time

12.

lastlogin

datetime

Last login time

13.

status

varchar(10)

Status

Tablename: image

Sl.no

Attribute

Data Type

Description

Constraints

1.

imgid

int(10)

Image id

Primary key

2.

imagename

varchar(25)

Imagename

3.

vehid

int(10)

Vehicle id

Foreign key

4.

imagepath

varchar(50)

Image path

5.

defaultimg

int(1)

Default image

Tablename:  sales

Sl.no

Attribute

Data Type

Description

Constraints

1.

salesid

int(10)

Sales id

Primary key

2.

vehid

int(10)

Vehicle id

Foreign key

3.

custid

int(10)

Customer id

Foreign key

4.

showroomid

int(10)

Showroom id

Foreign key

5.

vehcost

float(10,2)

Vehicle cost

6.

taxid

int(10)

Tax id

Foreign key

7.

ord_date

date

Ordered date

8.

del_date

date

Delivery date

9.

description

text

Description of vehicle

10.

status

varchar(10)

Status

Table name:  showroom

Sl.no

Attribute

Data Type

Description

Constraints

1.

showroomid

int(10)

Showroom id

Primary key

2.

dealerid

int(10)

Dealer id

Foreign key

3.

showroomname

varchar(50)

Showroom name

4.

imagepath

varchar(100)

Image path

5.

contactno

varchar(15)

Contact number

6.

address

text

Address

7.

city

varchar(25)

City

8.

state

varchar(25)

Status

9.

pincode

varchar(10)

Pincode

10.

status

varchar(10)

Status

Tablename: tax

Sl.no

Attribute

Data Type

Description

Constraints

1.

taxid

int(10)

Tax id

Primary key

2.

taxdescription

text

Tax description

3.

tax

float(10,2)

Total Tax

4.

status

varchar(10)

Status

TABLENAME: vehicle

Sl.no

Attribute

Data Type

Description

Constraints

1.

vehid

int(10)

Vehicle id

Primary key

2.

dealerid

int(10)

Dealer id

Foreign key

3.

vehname

varchar(50)

Vehicle name

4.

vehmodel

varchar(50)

Vehicle model

5.

vehtype

varchar(15)

Vehicle type

6.

vehdescription

text

Vehicle description

7.

vehcost

decimal(10,2)

Vehicle cost

8.

createdat

date

Create time

9.

status

varchar(10)

status

Vehicle Showroom ER diagram:

Online Vehicle Showroom er diagram

Download Vehicle Showroom Database design:

facebook

Click here to download all reports from Vehicle showroom

Advertisement

Share

Related

Advertisement

Latest

Advertisement