wp-database.md

erDiagram POST { int post_id varchar title text content datetime date } COMMENT { int comment_id int post_id varchar author text comment datetime date } POSTMETA { int meta_id int post_id varchar meta_key text meta_value } USER { int user_id varchar username varchar email } USERMETA { int umeta_id int user_id varchar meta_key text meta_value } TERM { int term_id varchar name varchar slug } TERM_TAXONOMY { int term_taxonomy_id int term_id varchar taxonomy } TERM_RELATIONSHIP { int object_id int term_taxonomy_id } POST ||--o| COMMENT : has POST ||--o| POSTMETA : has USER ||--o| USERMETA : has TERM ||--o| TERM_TAXONOMY : has TERM ||--o| TERM_RELATIONSHIP : has