# Database organization

**URL:** <https://forum.kirupa.com/t/database-organization/271582>\
**Category:** programming\
**Created:** [September 25, 2008, 1:36am UTC](https://forum.kirupa.com/t/database-organization/271582 "2008-09-25T01:36:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Icy\_Penguin](https://avatars.discourse-cdn.com/v4/letter/i/f6c823/32.png) [@Icy\_Penguin](https://forum.kirupa.com/u/Icy_Penguin)\
**Post date:** [September 25, 2008, 1:36am UTC](https://forum.kirupa.com/t/database-organization/271582/1 "2008-09-25T01:36:18Z")

</div>

Another question regarding how to organize my database -

I have a comments system where each comment can be rated, so I want to store which comments a user rates (so I can limit how many times they rate the comment).

But putting an array of this size into a column seems kinda awkard - it’d be something like this (a column called ‘ratings’ or something in the users table):

2498869\_0, 3452352\_1, 343525\_2…

Where the first set of numbers is the comment id and the 0, 1, or 2 is the rating they gave (0 meaning a downwards rating, 1 neutral, and 2 positive).

Is there any other way that would be better - 'cause that ratings column could be getting extremely long pretty fast…
