11/26/23, 8:59 PM localhost / [Link] / dbintellectlink | phpMyAdmin 5.2.
dbintellectlink
conferences
Column Type Null Default Comments
conference_id (Primary) int(11) No
title longtext No
location varchar(255) Yes NULL
organizer_id int(11) Yes NULL
start_date date Yes NULL
end_date date Yes NULL
Indexes
Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No conference_id 4 A No
organizer_id BTREE No No organizer_id 4 A Yes
interest_subject
Column Type Null Default Comments
interest_id (Primary) int(11) No
interest_name varchar(255) No
Indexes
Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No interest_id 5 A No
interest_type
Column Type Null Default Comments
type_id (Primary) int(11) No
type_name varchar(255) No
Indexes
Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No type_id 5 A No
journals
Column Type Null Default Comments
journal_id (Primary) int(11) No
title longtext No
editor_id int(11) Yes NULL
details longtext Yes NULL
localhost/phpmyadmin/[Link]?route=/database/data-dictionary&db=dbintellectlink&goto=[Link]%3Froute%3D%2Fdatabase%2Fstructure 1/3
11/26/23, 8:59 PM localhost / [Link] / dbintellectlink | phpMyAdmin 5.2.1
Column Type Null Default Comments
pdf_file longblob Yes NULL
interest_id int(11) Yes NULL
type_id int(11) Yes NULL
publication_date date Yes NULL
Indexes
Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No journal_id 0 A No
interest_id BTREE No No interest_id 0 A Yes
type_id BTREE No No type_id 0 A Yes
editor_id BTREE No No editor_id 0 A Yes
research
Column Type Null Default Comments
research_id (Primary) int(11) No
title longtext No
author_id int(11) Yes NULL
abstract longtext Yes NULL
pdf_file longblob Yes NULL
interest_id int(11) Yes NULL
type_id int(11) Yes NULL
publication_date date Yes NULL
Indexes
Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No research_id 7 A No
interest_id BTREE No No interest_id 7 A Yes
type_id BTREE No No type_id 7 A Yes
author_id BTREE No No author_id 7 A Yes
users
Column Type Null Default Comments
user_id (Primary) int(11) No
username varchar(255) No
password varchar(255) No
firstname varchar(255) Yes NULL
lastname varchar(255) Yes NULL
age int(11) Yes NULL
gender varchar(10) Yes NULL
college_dept varchar(255) Yes NULL
email varchar(255) No
phone varchar(20) Yes NULL
localhost/phpmyadmin/[Link]?route=/database/data-dictionary&db=dbintellectlink&goto=[Link]%3Froute%3D%2Fdatabase%2Fstructure 2/3
11/26/23, 8:59 PM localhost / [Link] / dbintellectlink | phpMyAdmin 5.2.1
Column Type Null Default Comments
address varchar(255) Yes NULL
Indexes
Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No user_id 4 A No
localhost/phpmyadmin/[Link]?route=/database/data-dictionary&db=dbintellectlink&goto=[Link]%3Froute%3D%2Fdatabase%2Fstructure 3/3
