Design and implementation of a web portal on sustainable development in Cameroon

5.2. Data dictionary

The data dictionary is a document that allows identifying, classifying and sorting all the information (data) collected during interviews or study the documents. The dictionary can be more or less elaborate depending on the desired level of granularity. The dictionary data generally includes the following information:

· The name of the data: the name that will be used to represent the data in the database and the computer program

· Description: This field gives the meaning of the element;

· The type of data: this field represents the data type to use for the backup of each element;

· Nature: This setting will help in the representation of data in the database;

· Size: the representation of the maximum amount of data that will contain every element;

· The observation shows the importance of the given degree.

On our portal for sustainable development, we have the following data dictionary:

Table 1: Data dictionary

N0	Name	Description	Type	Nature	Size	Observation
1	Doc_id	Document id	Int	N	10	Obligatory
2	Doc_name	Document name	Varchar	AN	255	Obligatory
3	Doc_description	Document description	Varchar	AN	255	Facultative
4	Doc_path	Document path	Varchar	AN	255	Obligatory
5	Link_id	Link id	Int	N	10	Obligatory
6	Link_name	Link name	Varchar	AN	255	Obligatory
7	Link_description	Link description	Varchar	AN	255	Facultative
8	Link_url	Link url	Varchar	AN	255	Obligatory
9	Art_id	Article id	Int	N	10	Obligatory
10	Art_title	Artcicle title	Varchar	AN	100	Obligatory
11	Art_content	Article content	Text	AN		Obligatory
12	Art_author	Article author	Varchar	AN	255	Facultative
13	Art_date	Article publication date	Date	y/m/d		Facultative
14	Art_media	Article media file	Varchar	AN	255	Facultative
15	Sug_id	Suggested content id	Int	N	10	Obligatory
16	Sug_type	Suggested content type	Varchar	AN	255	Obligatory
17	Sug_author	Suggested content author	Varchar	AN	255	Obligatory
18	Sug_cont	Suggested content contain	Text	AN		Obligatory
19	Sug_date	Suggested content date	Date	Y/M/D		Facultative
20	Sug_media	Suggested contentmedia file	Varchar	AN	100	Facultative
21	Mess_id	Message id	Int	N	10	Obligatory
22	Mess_send	Message sender	Int	N	10	Obligatory
23	Mess_recei	Message receiver	Int	N	10	Obligatory
25	Mess_cont	Message content	Text	AN		Obligatory
26	Mess_date	Message date	Date	Y/M/D		Facultative
27	User_id	User id	Int	N	10	Obligatory
28	User_name	User name	Varchar	AN	100	Obligatory
29	User_loc	User location	Varchar	AN	50	Facultative
30	User_prof	User proffession	Varchar	AN	50	Facultative
31	Top_id	Topic id	Int	N	10	Obligatory
32	Top_title	Topic title	Varchar	AN	100	Obligatory
33	Top_descr	Topic description	Varchar	AN	255	Obligatory
34	Top_sub_nbr	Number of subjects	Int	N	10	Facultative
35	Sub_id	Subject id	Int	N	10	Obligatory
36	Sub_title	Subject title	Varchar	AN	100	Obligatory
37	Sub_descr	Subject description	Varchar	AN	255	Obligatory
38	Com_id	Comment id	Int	N	10	Obligatory
39	Com_author	Comment author	Varchar	AN	100	Obligatory
40	Com_cont	Coment contain	Text	AN		Obligatory
41	Com_date	Comment date	date	AN		Facultative