Fud30 thread

From FUDforum Wiki
(Difference between revisions)
Jump to: navigation, search
Line 8: Line 8:
| id || int(11) || NO || PRI ||  || auto_increment
| id || int(11) || NO || PRI ||  || auto_increment
|-
|-
-
| forum_id || int(11) || NO || MUL || 0 ||  
+
| forum_id || int(11) || NO || MUL || 0 || References [[fud30_forum]].id.
|-
|-
-
| root_msg_id || int(11) || NO || MUL || 0 ||  
+
| root_msg_id || int(11) || NO || MUL || 0 || References [[fud30_msg]].id.
|-
|-
| last_post_date || bigint(20) || NO ||  || 0 ||  
| last_post_date || bigint(20) || NO ||  || 0 ||  
|-
|-
-
| replies || int(11) || NO || MUL || 0 ||  
+
| replies || int(11) || NO || MUL || 0 || Number of replies.
|-
|-
-
| views || int(11) || NO ||  || 0 ||  
+
| views || int(11) || NO ||  || 0 || Number of views.
|-
|-
-
| rating || int(11) || NO ||  || 0 ||  
+
| rating || int(11) || NO ||  || 0 || Topic's rating (average).
|-
|-
-
| n_rating || int(11) || NO ||  || 0 ||  
+
| n_rating || int(11) || NO ||  || 0 || Number of users who rated this topic.
|-
|-
| last_post_id || int(11) || NO ||  || 0 ||  
| last_post_id || int(11) || NO ||  || 0 ||  
|-
|-
-
| moved_to || int(11) || NO ||  || 0 ||  
+
| moved_to || int(11) || NO ||  || 0 || References [[fud30_forum]].id.
|-
|-
| orderexpiry || bigint(20) || NO ||  || 0 ||  
| orderexpiry || bigint(20) || NO ||  || 0 ||  
Line 30: Line 30:
| thread_opt || int(11) || NO || MUL || 0 ||  
| thread_opt || int(11) || NO || MUL || 0 ||  
|-
|-
-
| tdescr || varchar(200) || YES ||  ||  ||  
+
| tdescr || varchar(200) || YES ||  ||  || Topic description.
|}
|}

Revision as of 15:36, 8 January 2010

Description of FUDforum table fud30_thread. This table contains the forum's topics.

Fields

Column Name Datatype Can be Null? Key? Default Description
id int(11) NO PRI auto_increment
forum_id int(11) NO MUL 0 References fud30_forum.id.
root_msg_id int(11) NO MUL 0 References fud30_msg.id.
last_post_date bigint(20) NO 0
replies int(11) NO MUL 0 Number of replies.
views int(11) NO 0 Number of views.
rating int(11) NO 0 Topic's rating (average).
n_rating int(11) NO 0 Number of users who rated this topic.
last_post_id int(11) NO 0
moved_to int(11) NO 0 References fud30_forum.id.
orderexpiry bigint(20) NO 0
thread_opt int(11) NO MUL 0
tdescr varchar(200) YES Topic description.

Keys

Index Name Uniqueness Column Name Seq in index Comments
PRIMARY UNIQUE id 1
fud30_thread_i_flm NOT UNIQUE forum_id 1
fud30_thread_i_flm NOT UNIQUE moved_to 2
fud30_thread_i_t NOT UNIQUE thread_opt 1
fud30_thread_i_rmi NOT UNIQUE root_msg_id 1
fud30_thread_i_r NOT UNIQUE replies 1
Languages
Personal tools