pnp
Tables (11)
Achievement (achievement)
- achievementid — INT(4) — Primary key — NOT NULL
- year — INT(4)
- title — VARCHAR(255)
- comment — VARCHAR(255)
- image — VARCHAR(255)
Action (action)
- actionid — INT(4) — Primary key — NOT NULL
- type — VARCHAR(10)
Audit_log (audit_log)
- logid — INT(4) — Primary key — NOT NULL
- logtime — DECIMAL(32,9)
- userid (userid2) — INT(4) — Foreign key → User.userid — NOT NULL
- actionid (actionid2) — INT(4) — Foreign key → Action.actionid — NOT NULL
- extrainfo — VARCHAR(255)
Blog_category (blog_category)
- categoryid — INT(4) — Primary key — NOT NULL
- name — VARCHAR(10)
- categoryid (parentid) — INT(4) — Foreign key → Blog_category.categoryid — NOT NULL
Blog_post (blog_post)
- postid — INT(4) — Primary key — NOT NULL
- title — VARCHAR(255)
- comment — VARCHAR(255)
- image — VARCHAR(255)
- memberid (authorid) — INT(4) — Foreign key → Member.memberid — NOT NULL
- categoryid — INT(4) — Foreign key → Blog_category.categoryid — NOT NULL
History (history)
- historyid — INT(4) — Primary key — NOT NULL
- year — INT(4)
- title — VARCHAR(255)
- comment — VARCHAR(255)
Member (member)
- memberid — INT(4) — Primary key — NOT NULL
- name — VARCHAR(10)
- studentid — INT(4)
- grade — INT(4)
- github — VARCHAR(255)
- blog — VARCHAR(255)
- email — VARCHAR(255)
- image — VARCHAR(255)
- github_open — TINYINT(1)
- blog_open — TINYINT(1)
- email_open — TINYINT(1)
- image_open — TINYINT(1)
- graduated — TINYINT(1)
Member_team (member_team)
- teamid (teamid2) — INT(4) — Foreign key → Team.teamid — NOT NULL
- memberid (memberid2) — INT(4) — Foreign key → Member.memberid — NOT NULL
President (president)
- presidentid — INT(4) — Primary key — NOT NULL
- year — VARCHAR(10)
- info — VARCHAR(30)
- memberid — INT(4) — Foreign key → Member.memberid — NOT NULL
Team (team)
- teamid — INT(4) — Primary key — NOT NULL
- name — VARCHAR(10)
User (user)
- userid — INT(4) — Primary key — NOT NULL
- loginid — VARCHAR(30)
- password — VARCHAR(30)
- last_login — DECIMAL(32,9)
- create_time (create_date) — DECIMAL(32,9)
- enable — TINYINT(1)
- memberid (memberid2) — INT(4) — Foreign key → Member.memberid — NOT NULL