table groups ( group_id, group_descri ) table access ( rela_group, rela_code)
--- El jue 3-sep-09, karenebs <ka...@echobasesoftware.com> escribió: > De: karenebs <ka...@echobasesoftware.com> > Asunto: [sqlite] Defining user groups in SQLite table > Para: sqlite-users@sqlite.org > Fecha: jueves, 3 de septiembre de 2009, 2:57 pm > > I have a database table that holds about 20,000 > codes. Each code can be used > by several different user groups. I could add a > column to the database > table for each user group to indicate which codes that > particular group has > access to. But, I have over 100 different > groups! Can anyone suggest > another way of doing this? So, group 1 has access to > code1, code2, code3, > code4, code5; group 2 has access to code1, code2, > code3; group 3 has > access to code 2, code3, code4. etc. Thanks in > advance for any suggestions! > -- > View this message in context: > http://www.nabble.com/Defining-user-groups-in-SQLite-table-tp25281126p25281126.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 > Yahoo! Cocina Encontra las mejores recetas con Yahoo! Cocina. http://ar.mujer.yahoo.com/cocina/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users