Relational Database Design

[shortland]

Device -> Account link & login (SofteServe Login)

Tables:

• Users: [Primary Unique Key, Auto Increment] User IDN | Device UUID | Email | Password | Hash | Verified | Account Level | Exp | Cash | Gold

• Towers: [Primary Unique Key, Auto Increment] Tower IDN | [Foreign Key] User IDN | Tower Name | Background URL (diff locations)

• Floors: [Primary Unique Key, Auto Increment] Floor IDN | [FireDB Foreign Key *] Floor Type IDN | [Foreign Key] Tower IDN | Floor Upgraded Level | Floor Height Level | Current Employee Count

* Floor Type IDN is a Foreign Key reference to a Floor Type ID in the Firebase Database table. Floor Type information is stored there.

Floor Types: Floor Type IDN, Floor Name, (for each floor level): floor income, floor max employee, floor max customer, floor upgrade cost