tbl_users
tbl_profiles
userId INT(11)
profileId INT(11)
username VARCHAR(50)
userId INT(11)
password VARCHAR(100)
accountTypeId INT(3)
email VARCHAR(255)
socialNetworkUrls TEXT
Indexes
geoLocation TEXT timeZone VARCHAR(4) languages VARCHAR(30) websiteName VARCHAR(255) websiteUrl VARCHAR(255) address TEXT
tbl_creditinformations
phones VARCHAR(15)
creditId INT(11)
interests TEXT
userId INT(11)
newsLetters ENUM('ON','OFF')
type VARCHAR(20)
watchedMagazines TEXT
name VARCHAR(255)
signUpIp VARCHAR(15)
number INT(11)
dateOfBirth DATE
expiryDate DATE cvvNumber VARCHAR(5) Indexes
gender ENUM('ON','OFF') Indexes
tbl_accounttypes accountId INT(3) name VARCHAR(100) Indexes