31 lines
1.4 KiB
Plaintext
31 lines
1.4 KiB
Plaintext
Variables:
|
|
id - idex of the table: int, auto-increment, not null, primary key
|
|
uid - user id: int, auto-increment, not null, primary key
|
|
name - name of the item: varchar(255), not null
|
|
passwd - user password: varchar(255), not null
|
|
avatar - user avatar: longblob, null
|
|
email - user email: varchar(100), null
|
|
contact - user contact, can be physical or url: varchar(255), null
|
|
status - educational status, including degree or job information of the user: varchar(50), null
|
|
interest - user interests: varchar(255), null
|
|
descrip - user description: text, null
|
|
owner - id of the owner: int, not null
|
|
issue_date - issue date of the item: date, not null
|
|
start_date - start date of the item: date, not null
|
|
end_date - end date of the item: date, not null
|
|
founder - award/honor issue organization or project founder: varchar(255), not null
|
|
info - more information: text, null
|
|
visible - visibility of the item: int, 1, not null
|
|
location - university location: varchar(255), not null
|
|
major - user major: varchar(100), not null
|
|
cgpa - user cgpa: float(5,2), not null
|
|
gpa_scale - user gpa scale: float(5,2), not null
|
|
gpa_info - more information about user gpa: varchar(50), null
|
|
coursework - user coursework: text, null
|
|
role - user role in this item: varchar(100), not null
|
|
author - authors of the publication: varchar(255), not null
|
|
url - url of the item: varchar(255), null
|
|
|
|
Functions:
|
|
block(table_name, user_id)
|