Table | group_members |
---|---|
Description | Groups Members |
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 |