zxczx

Page 1

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


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.