An event database table architecture includes an event table having information such as, for example, date, time, and activity. An event table has a field for identifying one of a plurality of participating tables, and a field for identifying a row within the identified participating table. A participant table has a field for identifying one of a plurality of participating tables, a second field for identifying a row within the identified participating table, a role code, and a row number identifying the event in the event table. Thus, each entry in the participant table relates to a unitary entry in the event table and also relates to a unitary row in one of the participating tables. Each event, participant, and act of participating can be accessed from any other related data item without accessing extraneous or unrelated data items.
展开▼
