Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: phorum_pm_xrefphorum_pm_xref

phorum_pm_xref

Field Type Null Default
pm_xref_id  int(10) No   
user_id  int(10) No 
pm_folder_id  int(10) No 
special_folder  varchar(10) Yes  NULL 
pm_message_id  int(10) No 
read_flag  tinyint(1) No 
reply_flag  tinyint(1) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 pm_xref_id
pm_xref_id_2 UNIQUE 0 pm_xref_id
user_id_2 UNIQUE 0 user_id
pm_folder_id_2 UNIQUE 0 pm_folder_id
pm_message_id_2 UNIQUE 0 pm_message_id
read_flag_3 UNIQUE 0 read_flag
reply_flag_2 UNIQUE 0 reply_flag
reply_flag_3 UNIQUE 0 reply_flag
user_id_4 UNIQUE 0 user_id
pm_folder_id_3 UNIQUE 0 pm_folder_id
pm_message_id_4 UNIQUE 0 pm_message_id
pm_xref_id_4 UNIQUE 0 pm_xref_id
read_flag_5 UNIQUE 0 read_flag
pm_message_id_5 UNIQUE 0 pm_message_id
read_flag_6 UNIQUE 0 read_flag
pm_folder_id_6 UNIQUE 0 pm_folder_id
user_id_6 UNIQUE 0 user_id
reply_flag_6 UNIQUE 0 reply_flag
pm_xref_id_6 UNIQUE 0 pm_xref_id
pm_message_id_7 UNIQUE 0 pm_message_id
user_id_7 UNIQUE 0 user_id
reply_flag_7 UNIQUE 0 reply_flag
pm_folder_id_8 UNIQUE 0 pm_folder_id
read_flag_9 UNIQUE 0 read_flag
pm_xref_id_8 UNIQUE 0 pm_xref_id
user_id_9 UNIQUE 0 user_id
special_folder_2 UNIQUE None special_folder
special_folder_5 UNIQUE None special_folder
special_folder_8 UNIQUE None special_folder
special_folder_10 UNIQUE None special_folder
xref INDEX None user_id
pm_folder_id
pm_message_id
read_flag INDEX None read_flag
pm_xref_id INDEX None pm_xref_id
user_id INDEX None user_id
pm_folder_id INDEX None pm_folder_id
special_folder INDEX None special_folder
pm_message_id INDEX None pm_message_id
read_flag_2 INDEX None read_flag
reply_flag INDEX None reply_flag
pm_xref_id_3 INDEX None pm_xref_id
read_flag_4 INDEX None read_flag
pm_message_id_3 INDEX None pm_message_id
user_id_3 INDEX None user_id
pm_folder_id_4 INDEX None pm_folder_id
special_folder_6 INDEX None special_folder
reply_flag_4 INDEX None reply_flag
pm_xref_id_5 INDEX None pm_xref_id
special_folder_7 INDEX None special_folder
user_id_5 INDEX None user_id
pm_folder_id_5 INDEX None pm_folder_id
reply_flag_5 INDEX None reply_flag
pm_message_id_6 INDEX None pm_message_id
read_flag_7 INDEX None read_flag
pm_folder_id_7 INDEX None pm_folder_id
pm_message_id_8 INDEX None pm_message_id
read_flag_8 INDEX None read_flag
user_id_8 INDEX None user_id
pm_xref_id_7 INDEX None pm_xref_id
special_folder_12 INDEX None special_folder
reply_flag_8 INDEX None reply_flag
special_folder_3 INDEX None special_folder
special_folder_4 INDEX None special_folder
special_folder_9 INDEX None special_folder
special_folder_11 INDEX None special_folder


 Space usage :
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Feb 21, 2018 at 09:45 AM
Last update Mar 12, 2018 at 02:24 AM
Last check Mar 27, 2018 at 12:22 AM