gongchengshi
02-13-2008, 07:10 PM
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.
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.