Database Design for Mobile Valet Parking
Autor: mac123 • November 28, 2016 • Research Paper • 996 Words (4 Pages) • 818 Views
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. | |
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
...