WordPress Comment. Need some details of wp_comments DB table

Karma is a relic. Unused.

Agent is the browser agent of the person who left the comment. Like saying they use firefox or IE or whatever.

Comment type is either “comment” (or blank for the default case) or “pingback” or “trackback”, basically. You can have custom types, however they generally won’t show up as comments because WP doesn’t know about those types. Adding custom types is possible, but not officially supported yet because the code to support it properly isn’t there.

You’d be much better off storing your type in comment meta for now.

Related Posts:

  1. What for is the table “wp_commentmeta” exactly?
  2. Running a function on comment status change
  3. Is it possible to show custom comment metadata in the admin panel?
  4. Add Comment Custom Field
  5. Upload images with comment
  6. Add a drop down list to comment form?
  7. An action hook where a comment meta is updated
  8. What are the additional fields in wp_comments used for?
  9. Display comment meta data after quick update
  10. How would I count the number of times a comment meta field’s value is in a post’s entire comments?
  11. Get comments from post and sort by commentmeta value
  12. How to sort posts by the average of comment meta values
  13. How to get a value from comment meta
  14. Name of comment field differs on different sites
  15. Make every comment go to the spam folder
  16. How to display comment meta under each comment content
  17. Update comment meta for all comments of specific post
  18. How to get Post title by locale with Qtranslate-X
  19. get_comment_meta not behaving as expected
  20. How to filter comments by comment_meta
  21. Top rated posts Average rating issue
  22. WordPress Commenting System User access and Security
  23. Add comment meta
  24. Comment-Meta doesn’t work with latest wordpress update
  25. add field comment [duplicate]
  26. Use country flag as user avatar based on comments IP address?
  27. Disable comments on all posts/pages
  28. Stop WordPress redirecting comment-page-1 to the post page?
  29. Importing old Disqus comments into WordPress
  30. How to add a class to the comment submit button?
  31. Would switching to InnoDB from MyISAM improve performance of comments table?
  32. Linking to Page Showing Only Comments Without Parent Post
  33. Post Comments using WP REST API v2 in WordPress
  34. Show content only if member left a comment
  35. Using filter to add additional fields to comment_form()
  36. Disable wordpress comments API
  37. List Recent Comments from Across a Multi-site Network
  38. Comments waiting but no comments found
  39. Programmatically block commenting by restricting view of comment form
  40. count number of user comments with a specific comment meta value
  41. Comments screen in backend, how to disable Quick Edit | Edit | History | Spam | for non admins
  42. Plugin from WordPress.com for comment notification…available? [closed]
  43. How to add text to comment form #content textarea?
  44. Get most active users sort by comment count
  45. Passing arguments to wp_list_comments callback function
  46. comments_template not working correcly in custom template files
  47. Why are my comments closed?
  48. Is it possible to make wp insert last comment onto another page
  49. How to allow only Admins or Logged In Users to post links in comments?
  50. wp_insert_comment error. puzzled by date value
  51. Private replies for comments
  52. Show last n comments
  53. edit_comment capability for subscriber
  54. How to add attributes to the comment form tag?
  55. Follow-up Comments Notification Without a Plug-in
  56. oEmbed does not work for comments
  57. Yoast makes comment_reply_link function output plain link to comment instead of reply link
  58. Same email for all comments
  59. Comments system doesn’t like International domains
  60. Get a total count for all comments and display result
  61. List comments received by every posts of an specific author
  62. How do I reply to comments from admin panel on a tablet PC?
  63. Disable comments for a user? [closed]
  64. Polls with respective comments?
  65. Why does akismet prevent jetpack comments from appearing in my moderation queue? [closed]
  66. Ajax submit comments
  67. How do I automatically insert some text in the comment textbox on submit?
  68. I cannot view the comments
  69. In wp_list_comments comment dates won’t work?
  70. Where are comment ratings stored?
  71. how to SELECT for the current post id?
  72. Custom comment link
  73. How to display the user’s comment status on the front end
  74. get_comments_number() vs. get_post_field( ‘comment_count’, ID )
  75. Problem code and show comments
  76. Comments turned off, but ‘Leave a reply’ link still there [duplicate]
  77. How to output number of comments with link to comments
  78. How do I make Twenty Ten display comments on the home page?
  79. Allowing WordPress.org/com accounts on a self-hosted install
  80. How to remove the “comments” bit that appears next to or below the posts
  81. Sort post comments from newest to oldest in pagination
  82. Using Disqus with headless WordPress setup?
  83. Attaching author tag to the comment
  84. Pre- Approved Comment Capability
  85. Delete comments function
  86. Comment form not working
  87. How to show a “Comments Are Closed” message on posts where comments have been closed?
  88. Comments pagination on author page
  89. Comments page id wp_list_comments
  90. Inserting comments via a procedure
  91. Required Field for Comment parent only?
  92. Can I use WP comments for custom tables?
  93. How can I have a full comments.php for an easy editing of all its aspects?
  94. Transfer comments from one domain to another
  95. WordPress is adding above html
  96. Passing user meta through comment form
  97. writing a plugin, how to disable the comment form altogether?
  98. Function to get a list of all comments on 1 post [closed]
  99. Display DISQUS on homepage
  100. Auto delete WordPress comments