MEMBERSHIP (4.0)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores membership records.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
MEMBERSHIPPROGRAMID	uniqueidentifier	false	MEMBERSHIPPROGRAM.ID	The membership program of this record.
MEMBERSHIPLEVELID	uniqueidentifier	false	MEMBERSHIPLEVEL.ID	FK to MEMBERSHIPLEVEL
MEMBERSHIPLEVELTERMID	uniqueidentifier	false	MEMBERSHIPLEVELTERM.ID	FK to MEMBERSHIPLEVELTERM
MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	true	MEMBERSHIPLEVELTYPECODE.ID	The type of membership.
GIVENBYID	uniqueidentifier	true	CONSTITUENT.ID	The constituent that is responsible for giving the membership as a gift.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CANCELLATIONREASONCODEID	uniqueidentifier	true	MEMBERSHIPCANCELLATIONCODE.ID

Fields
Field	Field Type	Null	Notes	Description
NUMBEROFCHILDREN	smallint	false	((0))	The number of children allowed on this membership.
COMMENTS	nvarchar(1000)	false	''	Remarks about this membership.
ISGIFT	bit	false	0	Denotes that this membership is a gift.
SENDRENEWALCODE	tinyint	false	1	Specifies who to send renewals if this membership is a gift.
JOINDATE	datetime	true		The join date of this membership.
EXPIRATIONDATE	datetime	true		The expiration date of this membership.
LASTRENEWEDON	datetime	true		The date this membership was last renewed.
STATUSCODE	tinyint	false	0	The status of the membership: 0 - Active, 1 - Dropped, 2 - Pending
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
LASTCARDNUMBER	smallint	false	((0))	The last number appended to the end of a computed card number for the membership.
CUSTOMIDENTIFIER	nvarchar(100)	false	''	User-definable custom identifier.
SEQUENCEID	int	false		Identity column used to increment the default lookupid.
SENDRENEWAL	nvarchar(24) (Computed)	true		Provides a translation for the 'SENDRENEWALCODE' field.
LOOKUPID	nvarchar(100) (Computed)	true		Unique identifer that supports user defined values as well as system generated values.
NUMBEROFADDONADULTS	smallint	false	((0))	The number of additional members on this membership.
NUMBEROFADDONGUESTS	smallint	false	((0))	The number of guests allowed on this membership.
STATUS	nvarchar(9) (Computed)	true
AUTOMATICALLYRENEWMEMBERSHIP	bit	false	0

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_MEMBERSHIP_DATEADDED	DATEADDED	False	False	False
IX_MEMBERSHIP_DATECHANGED	DATECHANGED	False	False	False
IX_MEMBERSHIP_GIVENBYID	GIVENBYID	False	False	False
IX_MEMBERSHIP_ID	ID	False	False	False
IX_MEMBERSHIP_MEMBERSHIPLEVELID	MEMBERSHIPLEVELID	False	False	False
IX_MEMBERSHIP_MEMBERSHIPLEVELTERMID	MEMBERSHIPLEVELTERMID	False	False	False
IX_MEMBERSHIP_MEMBERSHIPPROGRAMID	MEMBERSHIPPROGRAMID	False	False	False
IX_MEMBERSHIP_SEQUENCEID	SEQUENCEID	False	False	True
PK_MEMBERSHIP	ID	True	True	False
UC_MEMBERSHIP_LOOKUPID	LOOKUPID	True	False	False

Triggers
Trigger Name	Description
TR_MEMBERSHIP_AUDIT_ETLDELETEDID
TR_MEMBERSHIP_AUDIT_UPDATE
TR_MEMBERSHIP_AUDIT_DELETE
TR_MEMBERSHIP_UPDATE_CANCELLATIONREASONCODEID

Referenced by
Referenced by	Field
BATCHBBNCMEMBERSHIP	MEMBERSHIPID
BATCHMEMBERSHIPDUES	EXISTINGMEMBERSHIPID
CREDITITEMMEMBERSHIP	MEMBERSHIPID
MEMBER	MEMBERSHIPID
MEMBERATTACHMENT	MEMBERSHIPID
MEMBERMEDIALINK	MEMBERSHIPID
MEMBERNOTE	MEMBERSHIPID
MEMBERSHIPADDON	MEMBERSHIPID
MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE	MEMBERSHIPID
MEMBERSHIPTRANSACTION	MEMBERSHIPID
SALESORDERITEMMEMBERSHIP	MEMBERSHIPID
SALESORDERITEMMEMBERSHIPADDON	MEMBERSHIPID