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