I have a table were each row needs to be able to store a list of entries from another table as one of its attributes. For instance the table is a collection of search filters. The filters table has attributes: FromDate, ToDate, Users, Devices. The Users attribute is not a single value but a list of Users contained in the Users table. Same with the Devices attribute. The Devices attribute is actually a list of Devices in the Devices table.
How do you go about defining this schema in SQL? The book I am reading "Database Systems" by Connolly and Begg say that you can have such relationships but they don't say how to create them. I am using sqlite as my DBMS. -- View this message in context: http://www.nabble.com/Multi-valued-attributes-tp15471820p15471820.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users