Essay About Model Detailsmodel Name And Columnscolumn Nametypepropertiesdescriptionuser

Database Design for Mobile Valet Parking
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        86. SQL Create Table        96.1. Customer Table        96.2. User Account Table        96.3. Login Table        96.4. Permission Table        96.5. Reservation Table        106.6. Permission Table        101. Model detailsModel name: This is a database design for Mobile Valet Parking (MVP)Version: Firebase Android SDK (v9.8)Database engine: Firebase2. Tables2.1. Table: User_accountDescription: This table is used to store information about the users of the system. PK – Represents primary keyFK – Represents Foreign key2.1.1. ColumnsColumn nameTypePropertiesDescriptionuser_idintPKAn artificial key is created for each user.first_namevarchar(100)First name of the userlast_namevarchar(100)Last name of the userPasswordvarchar(100)Passwords are stored in hashed form.Emailvarchar(254)254 is the maximum length that an email address can containcreatedtimestampDate/time of creation of this userCustomer_idintFKThe group the user belongs toLogin_idintFKThe role of the user2.2. Table LoginDescription: The table keeps information on user roles