AllFreePapers.com - All Free Papers and Essays for All Students
Search

Database Design for Mobile Valet Parking

Autor:   •  November 28, 2016  •  Research Paper  •  996 Words (4 Pages)  •  826 Views

Page 1 of 4

1. Model details        

2. Tables        

2.1. Table: User_account        

2.2. Table Login        

2.3. Table Reservation        

2.4. Table customer        

2.5. Table role_permission        

2.6. Table Location_map        

3. References        

3.1. Reference user_group        

3.2. Reference user_user_role        

3.3. Reference role_permission_permission        

3.4. Reference role_permission_user_role        

3.5. Reference Reservation_Location_map        

4. Subject areas        

4.1. Subject area users        

5. Database Design Diagram        8

6. SQL Create Table        9

6.1. Customer Table        9

6.2. User Account Table        9

6.3. Login Table        9

6.4. Permission Table        9

6.5. Reservation Table        10

6.6. Permission Table        10


1. Model details

Model name: This is a database design for Mobile Valet Parking (MVP)

Version: Firebase Android SDK (v9.8)

Database engine: Firebase


2. Tables

2.1. Table: User_account

Description: This table is used to store information about the users of the system.

PK – Represents primary key

FK – Represents Foreign key

2.1.1. Columns

Column name

Type

Properties

Description

user_id

int

PK

An artificial key is created for each user.

first_name

varchar(100)

First name of the user

last_name

varchar(100)

Last name of the user

Password

varchar(100)

Passwords are stored in hashed form.

Email

varchar(254)

254 is the maximum length that an email address can contain

created

timestamp

Date/time of creation of this user

Customer_id

int

FK

The group the user belongs to

Login_id

int

FK

The role of the user

2.2. Table Login

Description: The table keeps information on user roles

...

Download as:   txt (6.5 Kb)   pdf (191.1 Kb)   docx (37.3 Kb)  
Continue for 3 more pages »