They could potentially try to do this at the same time, so I need record locking too. Several people could create / edit Song records. Only one person can add / edit Recording records. I need to restrict write access to specific users on a per-table basis. I need support for referential integrity in that the Recording ID field in the Song table must be a valid entry in the Recording table. Probably a dozen fields in each table, a few of which would be free-form text of up to several sentences. The second table would have a record for each song, with a link back to the recording. One table would have a record for each recording. The task is for people to listen to recordings of festivals and concerts and annotate them with things like: musicians, instruments, songs, links to lyrics, etc. I'd prefer to do this without writing any code myself. I need to set up a simple (2 table) database for a bunch of not-too-technical users.
0 Comments
Leave a Reply. |