Table

group_members

Description

Groups Members


Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


group_idinteger, foreign keyGroup Record IDgroups:id(tick)
person_idinteger, foreign keyPerson Record IDpeople:id(tick)

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_idinteger, foreign keyIf set, this Membership was created via a Nested Group and cannot be manually editedRegistry Table: group_nestings:id