-
Multi-valued attributes
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|