워드프레스 4.61 Database 테이블 구조 > 기술자료

• 목록

워드프레스 4.61 테이블 구조

wp_commentmeta
  ├  `meta_id` bigint(20) unsigned NOT NULL auto_increment,
  ├  `comment_id` bigint(20) unsigned NOT NULL default '0',
  ├  `meta_key` varchar(255) default NULL,
  └  `meta_value` longtext,


wp_comments
  ├  `comment_ID` bigint(20) unsigned NOT NULL auto_increment,
  ├  `comment_post_ID` bigint(20) unsigned NOT NULL default '0',
  ├  `comment_author` tinytext NOT NULL,
  ├  `comment_author_email` varchar(100) NOT NULL default '',
  ├  `comment_author_url` varchar(200) NOT NULL default '',
  ├  `comment_author_IP` varchar(100) NOT NULL default '',
  ├  `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  ├  `comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
  ├  `comment_content` text NOT NULL,
  ├  `comment_karma` int(11) NOT NULL default '0',
  ├  `comment_approved` varchar(20) NOT NULL default '1',
  ├  `comment_agent` varchar(255) NOT NULL default '',
  ├  `comment_type` varchar(20) NOT NULL default '',
  ├  `comment_parent` bigint(20) unsigned NOT NULL default '0',
  └  `user_id` bigint(20) unsigned NOT NULL default '0',


wp_links
  ├  `link_id` bigint(20) unsigned NOT NULL auto_increment,
  ├  `link_url` varchar(255) NOT NULL default '',
  ├  `link_name` varchar(255) NOT NULL default '',
  ├  `link_image` varchar(255) NOT NULL default '',
  ├  `link_target` varchar(25) NOT NULL default '',
  ├  `link_description` varchar(255) NOT NULL default '',
  ├  `link_visible` varchar(20) NOT NULL default 'Y',
  ├  `link_owner` bigint(20) unsigned NOT NULL default '1',
  ├  `link_rating` int(11) NOT NULL default '0',
  ├  `link_updated` datetime NOT NULL default '0000-00-00 00:00:00',
  ├  `link_rel` varchar(255) NOT NULL default '',
  ├  `link_notes` mediumtext NOT NULL,
  └  `link_rss` varchar(255) NOT NULL default '',


wp_options
  ├  `option_id` bigint(20) unsigned NOT NULL auto_increment,
  ├  `option_name` varchar(191) NOT NULL default '',
  ├  `option_value` longtext NOT NULL,
  └  `autoload` varchar(20) NOT NULL default 'yes',


wp_postmeta
  ├  `meta_id` bigint(20) unsigned NOT NULL auto_increment,
  ├  `post_id` bigint(20) unsigned NOT NULL default '0',
  ├  `meta_key` varchar(255) default NULL,
  └  `meta_value` longtext,


wp_posts
  ├  `ID` bigint(20) unsigned NOT NULL auto_increment,
  ├  `post_author` bigint(20) unsigned NOT NULL default '0',
  ├  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
  ├  `post_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
  ├  `post_content` longtext NOT NULL,
  ├  `post_title` text NOT NULL,
  ├  `post_excerpt` text NOT NULL,
  ├  `post_status` varchar(20) NOT NULL default 'publish',
  ├  `comment_status` varchar(20) NOT NULL default 'open',
  ├  `ping_status` varchar(20) NOT NULL default 'open',
  ├  `post_password` varchar(20) NOT NULL default '',
  ├  `post_name` varchar(200) NOT NULL default '',
  ├  `to_ping` text NOT NULL,
  ├  `pinged` text NOT NULL,
  ├  `post_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  ├  `post_modified_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
  ├  `post_content_filtered` longtext NOT NULL,
  ├  `post_parent` bigint(20) unsigned NOT NULL default '0',
  ├  `guid` varchar(255) NOT NULL default '',
  ├  `menu_order` int(11) NOT NULL default '0',
  ├  `post_type` varchar(20) NOT NULL default 'post',
  ├  `post_mime_type` varchar(100) NOT NULL default '',
  └  `comment_count` bigint(20) NOT NULL default '0',


wp_termmeta
  ├  `meta_id` bigint(20) unsigned NOT NULL auto_increment,
  ├  `term_id` bigint(20) unsigned NOT NULL default '0',
  ├  `meta_key` varchar(255) default NULL,
  └  `meta_value` longtext


wp_terms
  ├  `term_id` bigint(20) unsigned NOT NULL auto_increment,
  ├  `name` varchar(200) NOT NULL default '',
  ├  `slug` varchar(200) NOT NULL default '',
  └  `term_group` bigint(10) NOT NULL default '0'


wp_term_relationships
  ├  `object_id` bigint(20) unsigned NOT NULL default '0',
  ├  `term_taxonomy_id` bigint(20) unsigned NOT NULL default '0',
  └  `term_order` int(11) NOT NULL default '0'


wp_term_taxonomy
  ├  `term_taxonomy_id` bigint(20) unsigned NOT NULL auto_increment,
  ├  `term_id` bigint(20) unsigned NOT NULL default '0',
  ├  `taxonomy` varchar(32) NOT NULL default '',
  ├  `description` longtext NOT NULL,
  ├  `parent` bigint(20) unsigned NOT NULL default '0',
  └  `count` bigint(20) NOT NULL default '0'


wp_usermeta
  ├  `umeta_id` bigint(20) unsigned NOT NULL auto_increment,
  ├  `user_id` bigint(20) unsigned NOT NULL default '0',
  ├  `meta_key` varchar(255) default NULL,
  └  `meta_value` longtext


wp_users
  ├ `ID` bigint(20) unsigned NOT NULL auto_increment,
  ├  `user_login` varchar(60) NOT NULL default '',
  ├  `user_pass` varchar(255) NOT NULL default '',
  ├  `user_nicename` varchar(50) NOT NULL default '',
  ├  `user_email` varchar(100) NOT NULL default '',
  ├  `user_url` varchar(100) NOT NULL default '',
  ├  `user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
  ├  `user_activation_key` varchar(255) NOT NULL default '',
  ├  `user_status` int(11) NOT NULL default '0',
  └  `display_name` varchar(250) NOT NULL default ''