Devlog

Wordpress ERD

Tables (4)

Copy Of wp_comments (categories)

  • Key (category_ID) — bigint(20) — Primary key — NOT NULL
  • comment_author (category_name) — varchar(100) — NOT NULL
  • comment_date (category_level) — int(1) — NOT NULL — 0000-00-00 00:00:00
  • comment_type (category_line) — int(5) — NOT NULL

wp_comments (comments)

  • comment_ID — bigint(20) — Primary key — NOT NULL
  • comment_post_ID — bigint(20) — Foreign key → wp_posts.ID — NOT NULL
  • comment_author — tinytext — NOT NULL
  • comment_author_email — varchar(100) — NOT NULL
  • comment_date — datetime — NOT NULL — 0000-00-00 00:00:00
  • comment_date_gmt — datetime — NOT NULL — 0000-00-00 00:00:00
  • comment_content — text — NOT NULL
  • comment_type — varchar(20) — NOT NULL
  • user_id — bigint(20) — Foreign key → wp_users.ID — NOT NULL

wp_posts (posts)

  • ID — bigint(20) — Primary key — NOT NULL
  • post_author — bigint(20) — Foreign key → wp_users.ID — NOT NULL
  • post_date — datetime — NOT NULL
  • post_content — longtext — NOT NULL
  • post_title — text — NOT NULL
  • post_status — varchar(20) — NOT NULL
  • comment_status — varchar(20) — NOT NULL — open
  • post_password — varchar(255) — NOT NULL
  • post_name — varchar(200) — NOT NULL
  • post_modified — datetime — NOT NULL
  • post_type — varchar(20) — NOT NULL
  • comment_count — bigint(20) — NOT NULL — 0
  • Key (category_ID2) — bigint(20) — Foreign key → Copy Of wp_comments.Key — NOT NULL

wp_users (users)

  • ID — bigint(20) — Primary key — NOT NULL
  • user_login — varchar(60) — NOT NULL
  • user_pass — varchar(255) — NOT NULL
  • user_nicename (user_nickname) — varchar(50) — NOT NULL
  • user_email — varchar(100) — NOT NULL
  • user_registered — datetime — NOT NULL
  • user_status — int(11) — NOT NULL
  • display_name — varchar(250) — NOT NULL