Member

Table name: ie_member

Field Name	Business Purpose	Field type (with size)	Data Type	Should Index?	Is Primary Key?	Is Foreign Key?	Is it a required field?	Is it editable?	Is it Unique?	Specific validations for some field type	REFERENCE OF OTHER BUILDING BLOCK

Field Name	Business Purpose	Field type (with size)	Data Type	Should Index?	Is Primary Key?	Is Foreign Key?	Is it a required field?	Is it editable?	Is it Unique?	Specific validations for some field type	REFERENCE OF OTHER BUILDING BLOCK
memberId	Unique identifier for this member	integer	bigInt	Yes	Yes	No	Yes	No	Yes	No	No
userId	id of user	integer	bigInt	Yes	No	Yes	yes	no	Yes	no	Yes (User)
partnerId	id of Partner	integer	bigInt	Yes	No	Yes	yes	no	Yes	no	Yes (Partner)
role	Role of user(app-specific)	enum[owner,admin]	enum[owner,admin]	No	No	No	yes	yes	no	no	owner, admin
status	status of profile	enum[pending,active,inactive]	enum[pending,active,inactive]	No	No	No	Yes	Yes	No	no	pending, active, inactive
invitationFromUserId	id of user who invited	integer	bigInt	No	No	No	Yes	No	No	URL	No
createdAt	created date of Member	string	timestamp	No	No	No	no	no	no	yyyy-mm-dd h:m:s	No
updatedAt	updated date of Member	string	timestamp	No	No	No	no	no	no	yyyy-mm-dd h:m:s	No