Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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