title: Sqlite database table: can an array become one column of a record?
body: <p>I'm designing an iPhone app, which needs to store data into Sqlite database.</p>
  
  <p>One record of the table looks like -</p>
  
  <pre><code>@interface Record:NSObject {
      NSInteger primaryKey;
      NSString *name;
      NSInteger priority;
      NSMutableArray *items;
  };
  </code></pre>
  
  <p>Please be noted one column in the record is an array and the size of the array is not fixed. The size can be zero or any positive integer.</p>
  
  <p>My question is: when I design the Sqlite table, can I specify an array as one column of a record? If NO, How should I design this table?</p>
  
  <p>UPDATE: Thank you for the answer. It seems the answer to my question is NO. If so, can I use other archive methods, say, Property List or NSKeyedArchiver to implement that? </p>