Data Dictionary: quezon city university

Alumni information system

Table 1: Users (tbl_Users)

Field Data type Size Constrain Description
name t
name Varchar 50 - Name of the User
username Varchar 50 - Username
password Varchar 50 - Password
permission tinyint 50 - Permission
Au_id Int - Foreign key Unique Id of Alumni

Table 1: Admin (tbl_Admin)

Field name Data type Size Constrain Description
t
Ad_id int - Primary key Unique Id of Admin
Ad_firstname Varchar 50 - Admin First Name
Ad_lastname Varchar 50 - Admin Last Name
Ad_email Varchar 50 - Admin Email-Id
Ad_contactn Varchar 20 - Admin Contact Number
o
Ad_img Image - - Admin Image
 Table 2: Alumni (tbl_Alumni)
Field name Data type Size Constrain Description
t
Au_id Int - Primary key Unique Id of Alumni
Au_firstname Varchar 50 - Alumni First Name
Au_lastname Varchar 50 - Alumni Last Name
Au_middlenam Varchar 50 - Alumni Middle Name
e
Au_civilstatus Varchar 50 - Alumni Civil Status
Au_gender Varchar 10 - Alumni Gender
Au_birthday Varchar 50 - Alumni Birthday
Au_age Int 100 - Alumni Age
Au_address Varchar 100 - Alumni Address
Au_email Varchar 50 - Alumni Email
Au_contactno Int 20 - Alumni Contact Number
Batch_id Int - Foreign key Alumni Batch Id
Course_id Int - Foreign key Alumni Course Id
Campus_id Int - Foreign key Alumni Campus Id
Au_img Image - - Alumni Image

Table 3: Job (tbl_Job)

 Field Data type Size Constrain Description
name t
Job_id Int - Primary key Unique id
Job_title Varchar 200 - Job Title
Job_info Varchar Max - Job Information
Job_link Varchar Max - Job Link
Au_id Varchar 50 Foreign key Alumni Id
Start_date Date time - - Start Date
End_date Date time - - End Date
Is_display Bit - - Display

Field name Data Size Constrain Description

type t
Au_jobid Int - Primary key Unique Id
Au_id Varchar 50 Foreign key Alumni Id
Company_name Varchar 50 - Company Name
Company_address Varchar Max - Company Address
Company_cont. Int 20 - Company Contact
Employee_type Varchar 50 - Employee Type
Company_joindate Date time - - Company Join Date
Company_leavedate Date time - - Company Leave Date
Job_Info Varchar 100 - Job Information
Table 4: Alumni_job_detail (tbl_AuJobDetail)

Table 5: Batch (tbl_Batch)

Field Data type Size Constrain Description
name t
Batch_id Int - Primary key Unique Id
 Batch_year Date time 04 - Batch Year

Table 6: Campus (tbl_Campus)

Field name Data type Size Constrain Description
t
Campus_id Int - Primary key Unique Id
Campus_nam Varchar 50 - Campus Name
e

Table 6: Courses (tbl_Courses)

Field name Data type Size Constrain Description
t
Course_id Int - Primary key Unique Id
Course_name Varchar 50 - Course Name
Course_description Varchar 100 - Course Description

Table 7: Event (tbl_Event)

Field name Data type Size Constrain Description
t
Event_id Int - Primary key Unique Id
Event_title Varchar 50 - Event Title
Event_content Varchar Max - Event Content
Event_schedul Varchar 50 - Event Schedule
e
Table 8: EventCommits (tbl_EventCommits)
Field name Data type Size Constraint Description
Event_id Int - Foreign key Unique Id
 Au_id Int - Foreign key Unique Id of Alumni

Table 9: ForumTopics (tbl_ForumTopics)

Field name Data type Size Constrain Description
t
Topic_id Int - Primary key Unique Id
Forum_title Varchar 50 - Forum Title
Forum_content Varchar Max - Forum Content
Au_id Int - Foreign key Unique Id of Alumni

Table 10: ForumComments

(tbl_ForumComments)
Field name Data type Size Constrain Description
t
Forum_id Int - Primary key Unique Id
Topic_id Int - Foreign key Unique Id
Forum_comment Varchar Max - Forum Comment
user_id Int - Foreign key Unique Id