I'm working on a rather odd implementation that stretches the limits of WP a little - its a healthcare site where patients are a custom post type and procedure requests related to each patient are stored in comments on that post. I started off by storing alot of data in commentmeta, but I want an easier way to access it than having to pull from a meta table. I'd also like to be able to use the built-in functions where available (wp_insert_comment can set most of the fields in wp_comments table through the arguments passed to it).
My question is - where are these other values set and accessed in WordPress? Specifically, I'm curious about:
I have one meta value I want to set, which I'm hoping to use
comment_type for. I also want to set a flag on each request to show whether or not it has been confirmed and responded to. It seems like
comment_karma would work well for this, as it is completely unsused, although I'm not sure if it can be set directly with wp_insert_comment.
Are there any consequences I should be aware of when doing this? Would I be better off just adding additional columns to the table, or does this approach sound like it would work?