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