USERINFO
The USERINFO table contains the user information. The fields of this table
are shown in Table 2.
Table 2. The USERINFO database table
Field name
Data type
Length
Nullable
first_name
varchar
50
no
last_name
varchar
50
no
email_address
varchar
50
no
date_joined
date
no
birth_date
date
no
address
varchar
200
no
username
varchar
20
no
The username field will be the search key in this table; hence, we will also
allocate it to be the primary key in the table.
None of these fields are allowed to be empty.
USERPROFILE
This contains the list of platform categories that a user would be interested in.
Each registered user will have an entry in this table. All fields are set to be
nullable except for the username. If a registered user has indicated an
interest in a platform, the field is set to a single character, typically a letter
y
.
The fields for the USERPROFILE table are shown in Table 3.
Table 3. The USERPROFILE database table
Field name
Data type
Length
Nullable
as400
char
1
yes
netfinity
char
1
yes
ncf
char
1
yes
nw
char
1
yes
s390
char
1
yes
rs6000
char
1
yes
scalable
char
1
yes
vm
char
1
yes
Chapter 3. Building the Web server
65




  

Home

About Services Network Support FAQ Order Contact
 

Linux Web Hosting

Our partners:Jsp Web Hosting Unlimited Web Hosting Cheapest Web Hosting  Java Web Hosting Web Templates Best Web Templates PHP Mysql Web Hosting Interland Web Hosting Cheap Web Hosting PHP Web Hosting Tomcat Web Hosting Quality Web Hosting Best Web Hosting  Mac Web Hosting 

Lunarwebhost.net  Business web hosting division of Vision Web Hosting Inc. All rights reserved