🪪 Memberships

Membership Entity

The following properties for idt_members table:

Name	Type	Description	Unique	Required
idt_member_id	INT	Primary key, unique member ID	✅	✅
idt_member_name	String	Name of the member	❌	✅
idt_member_phone	String	Phone of the member (WhatsApp notification)	❌	✅
idt_member_email	String	Email of the member (Email notification)	❌	❌
idt_member_description	String	Description of the member	❌	❌
idt_member_icon	String	Icon of the member	❌	❌
idt_member_status	String	Status of the member	❌	✅
idt_member_type_id	INT	Foreign key from member Type table	❌	✅
idt_member_referral_id	INT	Foreign key from Member table (Invitor)	❌	❌
user_id	INT	Foreign key from User table (Invitee)	❌	❌

Membership:

• User Created: Member is not required at the beginning each User created (unless configured).
• Create Membership: User can create thir own Membership by theirself (if doesn't existed).
• Invite Membership: Member (Invitor) can create another member for another person (Invitee).
• Referral Membership: Each Invited member, must have idt_member_referral_id from Invitor.

Invitation:

• Invited Member (Invitee), will received a notification trough WhatsApp/Email with pre-filled link.
• Pre-filled link will direct Invited Member (Invitee) to Registration Page using their data.
• After data submitted, User will be created and user can login using their own credential.

Membership Type Entity

The following properties for idt_member_types table:

Name	Type	Description	Unique	Required
idt_member_type_id	INT	Primary key, unique membership ID	✅	✅
idt_member_type_code	String(6)	Code of the membership type	❌	✅
idt_member_type_name	String	Name of the membership type	❌	✅
idt_member_type_description	String	Description of the member type	❌	❌
idt_member_is_deleted	boolean	Is trx type deleted (Default: False)	❌	✅

NOTE - Unique: Ensures the uniqueness of the values entered into a property of a database table. - Required: Ensures that the values entered a property of a database table can NOT be NULL.