5.1.- Web Site's Database

5.1.1.- User Relational Model

User Table Specification: user

Key	Foreign	Field Name	SQL Type	Null	Unique
Yes	-	user_id	Numeric	Not	Yes
-	-	user_name	varchar(25)	Not	Yes
-	-	user_passw	varchar(10)	Not	Not
-	-	user_email	varchar(100)	Not	Yes
-	-	secret_question	varchar(150)	Not	Not
-	-	secret_answer	varchar(150)	Not	Not

User Data Table Specification: user_data

Key	Foreign	Field Name	SQL Type	Null	Unique
Yes	Yes	user_id	Numeric	Not	Yes
-	-	first_name	varchar(25)	Not	Not
-	-	second_name	varchar(25)	Not	Not
-	-	street_address	varchar(255)	Not	Not
-	-	postal_code	varchar(5)	Not	Not
-	Yes	country_id	Numeric	Not	Not
-	Yes	state_id	Numeric	Not	Not
-	-	city	varchar(25)	Not	Not
-	-	company_name	varchar(25)	Yes	Not
-	-	company_position	varchar(25)	Yes	Not
-	-	company_size	varchar(25)	Yes	Not
-	Yes	language_id	Numeric	Not	Not
-	Yes	user_kind_id	Numeric	Not	Not
-	-	interest_contribute	boolean	Not	Not
-	-	interest_comercial	boolean	Not	Not
-	-	interest_home	boolean	Not	Not
-	-	jlabase_newsletter	boolean	Not	Not

Contry Table Specification: country

Key	Foreign	Field Name	SQL Type	Null	Unique
Yes	-	contry_id	Numeric	Not	Yes
-	-	country_name	varchar(25)	Not	Yes

The values stored in this table must be the ones in this List of Countries

State Table Specification: state

Key	Foreign	Field Name	SQL Type	Null	Unique
Yes	-	state_id	Numeric	Not	Yes
-	Yes	country_id	Numeric	Not	Not
-	-	state_name	varchar(25)	Not	Not

The values stored in this table must be the ones in this List of States. This list must grow to cover more available states.

Language Table Specification: language

Key	Foreign	Field Name	SQL Type	Null	Unique
Yes	-	lang_id	Numeric	Not	Yes
-	-	lang_name	varchar(25)	Not	Yes
-	-	lang_locale	varchar(2)	Not	Yes

Values

lang_id	lang_name	lang_locale
1	English (*)	(**)
2	Español	es

(*): Default value
(**): Empty string

User Kind Table Specification: user_kind

Key	Foreign	Field Name	SQL Type	Null	Unique
Yes	-	ukind_id	Numeric	Not	Yes
-	-	ukind_name	varchar(25)	Not	Yes

Values

ukind_id	ukind_name
1	End User
2	Developer
3	System Administrator
4	Project Administrator
5	Other

5.1.2.- News Relational Model

5.1.3.- Internal Search Engine