'Web Study/워드프레스' 카테고리의 글 목록

'Web Study/워드프레스'에 해당되는 글 1건

2012.09.12 [Wordpress]워드프레스 데이터베이스 스키마

[Wordpress]워드프레스 데이터베이스 스키마

Web Study/워드프레스 2012. 9. 12. 15:52 |

참고 URL: http://codex.wordpress.org/Database_Description

워드프레스 3.0 데이터베이스 다이어그램: (출처: http://codex.wordpress.org/images/9/9e/WP3.0-ERD.png

WordPress 3.4 Tables (11)
Table Name	Description	Relevant Area(s) of WordPress User Interface
wp_commentmeta	Each comment features information called the meta data and it is stored in the `wp_commentmeta`. (각 커멘트는 메타 데이타라 불리는 정보를 포함하고 wp_commentmeta 테이블에 저장된다.)	Administration > Comments > Comments
wp_comments	The comments within WordPress are stored in the `wp_comments` table. (워드프레스 내의 커멘트들은 wp_comments 테이블에 저장된다.)	Administration > Comments > Comments
wp_links	The `wp_links` holds information related to the links entered into the Links feature of WordPress. (wp_links는 워드프레스의 Links 기능에 입력되는 링크와 관련된 정보를 저장한다.)	Administration > Links > Add New Administration > Links > Links
wp_options	The Options set under theAdministration > Settings panel are stored in the `wp_options` table. SeeOption Reference for `option_name` and default values. (Administration > Setting 패널에 있는 Options 는 wp_options 테이블에 저장된다. option_name과 기본값에 대해서는 Option Reference를 참고하라.)	Administration > Settings > General Administration > Settings > Writing Administration > Settings > Reading Administration > Settings > Discussion Administration > Settings > Privacy Administration > Settings > Permalinks Administration > Appearance > Widgets
wp_postmeta	Each post features information called the meta data and it is stored in the `wp_postmeta`. Some plugins may add their own information to this table. (각 포스트는 메타 데이터라고 불리는 정보를 포함하고 그 정보는 wp_postmeta 테이블에 저장된다. 어떤 플러그인은 이 테이블에 자기만의 정보를 추가할 수도 있다.)	Administration > Posts > Add New Administration > Pages > Add New
wp_posts	The core of the WordPress data is theposts. It is stored in the `wp_posts` table. Also Pages and navigation menu items are stored in this table. (워드프레스 데이터의 핵심은 바로 포스트이고 그 정보는 wp_posts 테이블에 저장된다. 또한 페이지와 네비게이션 메뉴 아이템에 대한 정보도 이 테이블에 저장된다.)	Administration > Posts > Add New Administration > Posts > Posts Administration > Pages > Add New Administration > Pages > Pages Administration > Media > Add New Administration > Media > Library Administration > Appearance > Menus
wp_terms	The categories for both posts and links and the tags for posts are found within the `wp_terms` table. (포스트와 링크에 대한 카테고리와 포스트에 대한 태그가 wp_terms 테이블에 저장된다.)	Administration > Posts > Post Tags Administration > Posts > Categories Administration > Links > Link Categories Administration > Posts > Add New Administration > Posts > Posts Administration > Pages > Add New Administration > Page > Pages
wp_term_relationships	Posts are associated with categories and tags from the `wp_terms` table and this association is maintained in the`wp_term_relationships` table. The association of links to their respective categories are also kept in this table. (포스트는 wp_terms 테이블에 저장되는 카테고리와 태그와 관계가 있고 이 관계는 wp_term_relationships 테이블에 저장된다. 링크와 링크에 대한 각각의 카테고리와의 관계는 이 테이블에 저장된다. )
wp_term_taxonomy	This table describes the taxonomy (category, link, or tag) for the entries in the `wp_terms` table. (이 테이블은 wp_terms 테이블에 있는 항목들에 대한 분류(카테고리, 링크, 태그) 정보를 저장한다.)
wp_usermeta	Each user features information called the meta data and it is stored in`wp_usermeta`. (모든 유저는 wp_usermeta 테이블에 저장되는 메타 데이터라 불리는 정보를 가진다.)	Administration > Users
wp_users	The list of users is maintained in table`wp_users`. (유저의 목록이 wp_users 테이블에 저장된다.)	Administration > Users

테이블 세부정보

1. Table: wp_commentmeta

Field	Type	Null	Key	Default	Extra
meta_id	bigint(20) unsigned		PRI	NULL	auto_increment
comment_id	bigint(20) unsigned		IND	0	FK->wp_comments.comment_id
meta_key	varchar(255)	YES	IND	NULL
meta_value	longtext	YES		NULL

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	0	meta_ID
comment_id	INDEX	none	comment_id
meta_key	INDEX	none	meta_key

2. Table: wp_comments

Field	Type	Key	Default	Extra
comment_ID	bigint(20) unsigned	PRI	NULL	auto_increment
comment_post_ID	bigint(20) unsigned	IND	0	FK->wp_posts.ID
comment_author	tinytext
comment_author_email	varchar(100)
comment_author_url	varchar(200)
comment_author_IP	varchar(100)
comment_date	datetime		0000-00-00 00:00:00
comment_date_gmt	datetime	IND & IND Pt2	0000-00-00 00:00:00
comment_content	text
comment_karma	int(11)		0
comment_approved	varchar(20)	IND & Ind Pt1	1
comment_agent	varchar(255)
comment_type	varchar(20)
comment_parent	bigint(20) unsigned		0	FK->wp_comments.ID
user_id	bigint(20) unsigned		0	FK->wp_users.ID

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	1	comment_ID
comment_post_ID	INDEX	None	comment_post_ID
comment_approved_date_gmt	INDEX	None	comment_approved comment_date_gmt
comment_date_gmt	INDEX	None	comment_date_gmt
comment_parent	INDEX	None	comment_parent

3. Table: wp_links

Field	Type	Key	Default	Extra
link_id	bigint(20) unsigned	PRI	NULL	auto_increment
link_url	varchar(255)
link_name	varchar(255)
link_image	varchar(255)
link_target	varchar(25)
link_description	varchar(255)
link_visible	varchar(20)	IND	Y
link_owner	bigint(20) unsigned		1
link_rating	int(11)		0
link_updated	datetime		0000-00-00 00:00:00
link_rel	varchar(255)
link_notes	mediumtext
link_rss	varchar(255)

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	7	link_ID
link_category	INDEX	None	link_category
link_visible	INDEX	None	link_visible

4. Table: wp_options

Field	Type	Key	Default	Extra
option_id	bigint(20) unsigned	PRI Pt1	NULL	auto_increment
option_name	varchar(64)	PRI Pt3 & IND
option_value	longtext
autoload	varchar(20)		yes

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	184	option_id blog_id option_name
option_name	UNIQUE	184	option_name

5. Table: wp_postmeta

Field	Type	Null	Key	Default	Extra
meta_id	bigint(20) unsigned		PRI	NULL	auto_increment
post_id	bigint(20) unsigned		IND	0	FK->wp_posts.ID
meta_key	varchar(255)	YES	IND	NULL
meta_value	longtext	YES		NULL

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	13	meta_ID
post_id	INDEX	15	post_id
meta_key	INDEX	7	meta_key

6. Table: wp_posts

Field	Type	Key	Default	Extra
ID	bigint(20) unsigned	PRI & IND Pt4		auto_increment
post_author	bigint(20) unsigned		0	FK->wp_users.ID
post_date	datetime	IND Pt3	0000-00-00 00:00:00
post_date_gmt	datetime		0000-00-00 00:00:00
post_content	longtext
post_title	text
post_excerpt	text
post_status	varchar(20)	IND PT2	publish
comment_status	varchar(20)		open
ping_status	varchar(20)		open
post_password	varchar(20)
post_name	varchar(200)	IND
to_ping	text
pinged	text
post_modified	datetime		0000-00-00 00:00:00
post_modified_gmt	datetime		0000-00-00 00:00:00
post_content_filtered	longtext
post_parent	bigint(20) unsigned		0	FK->wp_posts.ID
guid	varchar(255)
menu_order	int(11)		0
post_type	varchar(20)	IND Pt1	post
post_mime_type	varchar(100)
comment_count	bigint(20)		0

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	2	ID
post_name	INDEX	None	post_name
type_status_date	INDEX	None	post_type post_status post_date ID
post_parent	INDEX	None	post_parent
post_author	INDEX	None	post_author

7. Table: wp_terms

Field	Type	Key	Default	Extra
term_id	bigint(20) unsigned	PRI		auto_increment
name	varchar(200)
slug	varchar(200)	UNI
term_group	bigint(10)		0

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	2	term_ID
slug	UNIQUE	2	slug
name	Index	none	name

8. Table: wp_term_relationships

Field	Type	Key	Extra
object_id	bigint(20) unsigned	PRI Pt1
term_taxonomy_id	bigint(20) unsigned	PRI Pt2 & IND	FK->wp_term_taxonomy.term_taxonomy_id
term_order	int(11)

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	8	object_id term_taxonomy_id
term_taxonomy_id	INDEX	None	term_taxonomy_id

9. Table: wp_term_taxonomy

Field	Type	Key	Default	Extra
term_taxonomy_id	bigint(20) unsigned	PRI		auto_increment
term_id	bigint(20) unsigned	UNI Pt1	0	FK->wp_terms.term_id
taxonomy	varchar(32)	UNI Pt2
description	longtext
parent	bigint(20) unsigned		0
count	bigint(20)		0

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	2	term_taxonomy_id
term_id_taxonomy	UNIQUE	2	term_id taxonomy
taxonomy	INDEX	None	taxonomy

10. Table: wp_usermeta

Field	Type	Null	Key	Default	Extra
umeta_id	bigint(20) unsigned		PRI	NULL	auto_increment
user_id	bigint(20) unsigned			'0'	FK->wp_users.ID
meta_key	varchar(255)	Yes	IND	NULL
meta_value	longtext	Yes	IND	NULL

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	9	umeta_id
user_id	INDEX	None	user_id
meta_key	INDEX	None	meta_key

11. Table: wp_users

Field	Type	Key	Default	Extra
ID	bigint(20) unsigned	PRI	NULL	auto_increment
user_login	varchar(60)	IND
user_pass	varchar(64)
user_nicename	varchar(50)	IND
user_email	varchar(100)
user_url	varchar(100)
user_registered	datetime		0000-00-00 00:00:00
user_activation_key	varchar(60)
user_status	int(11)		0
display_name	varchar(250)

Indexes

Keyname	Type	Cardinality	Field
PRIMARY	PRIMARY	1	ID
user_login_key	INDEX	None	user_login
user_nicename	INDEX	None	user_nicename

저작자표시 비영리 변경금지 (새창열림)

Posted by 파노카페

PREV 1 NEXT

일	월	화	수	목	금	토
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

Notice

Category

Tags

Recent Posts

Recent Comments

Recent Trackbacks

Archives

Links

'Web Study/워드프레스'에 해당되는 글 1건

[Wordpress]워드프레스 데이터베이스 스키마

테이블 세부정보

Indexes

2. Table: wp_comments

Indexes

3. Table: wp_links

Indexes

4. Table: wp_options

Indexes

5. Table: wp_postmeta

Indexes

6. Table: wp_posts

Indexes

7. Table: wp_terms

Indexes

8. Table: wp_term_relationships

Indexes

9. Table: wp_term_taxonomy

Indexes

10. Table: wp_usermeta

Indexes

11. Table: wp_users

Indexes

티스토리툴바