MEMBER

Stores member information for a membership

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
ISPRIMARY bit Default = 0 Indicates this is the primary member.
ISDROPPED bit Default = 0 Indicates if the member has been dropped.
DATEADDED datetime Default = getdate() Indicates the date this record was added.
DATECHANGED datetime Default = getdate() Indicates the date this record was last changed.
TS timestamp Timestamp.
TSLONG bigint (Computed) yes CONVERT(bigint, TS) Numeric representation of the timestamp.
ISCAREGIVER bit Default = 0 Indicates if the member is care giver.

Foreign Keys

Foreign Key Field Type Null Notes Description
CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID Foreign key to the constituent record.
MEMBERSHIPID uniqueidentifier MEMBERSHIP.ID The membership for this member record.
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_MEMBER_CONSTITUENTID CONSTITUENTID
IX_MEMBER_DATEADDED DATEADDED yes
IX_MEMBER_DATECHANGED DATECHANGED
IX_MEMBER_MEMBERSHIPID MEMBERSHIPID
PK_MEMBER ID yes yes

Triggers

Trigger Name Description
TR_MEMBER_VALIDMEMBERCHECK
TR_MEMBER_AUDIT_ETLDELETEDID
TR_MEMBER_AUDIT_UPDATE
TR_MEMBER_AUDIT_DELETE
TR_MEMBER_MARKASCONSTITUENT

Referenced by

Referenced by Field
MEMBERSHIPCARD MEMBERID
SALESORDERITEMMEMBER MEMBERID