...
Column | Format | Description | Definition | Required | Comments | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | ||||||||||||||
group_id | integer, foreign key | Group Record ID | groups:id | ||||||||||||||
person_id | integer, foreign key | Person Record ID | people:id | valid_from | datetime | Group Membership is considered valid from this time | If null, valid any time through valid_through | valid_through | datetime | Group Membership is considered valid through (but not past) this time | If null, valid any time from valid_from | group_nesting_id | integer, foreign key | If set, this Membership was created via a Nested Group and cannot be manually edited | Registry Table: group_nestings:id |