Custom Columns for Custom Fields

Hello,

I am looking for a solution in which I can create custom columns in wp_posts table to store custom fields and also have a way to access them for using or displaying these fields through out the site. These fields should also be accessible to other plugins also.

Further, I also want that duplicate values cannot be stored in specific custom fields.

Any help will be highly appreciated.

Thanks,

Alok