Collaborator (Profile/App mapping)

Field Name	Business Purpose	Field type (with size) Rich text Text (short text, long text) Number (integer, decimal) Date and Time Location Media Boolean enum [value1, value 2] Array[of what] JSON object Reference	Is it a required field?	Is it editable?	Is it Unique?	Specific validations for some field type Text (short-text, long text)- Character count, a specific pattern (URL, email, slug, custom) prohibit pattern Media (file type, image dimensions, file size)	REFERENCE OF OTHER BUILDING BLOCK Accept only specified values. If Yes, mention what values. In case values are to be filled by reference to records in other datastore - mention the reference to records In case there is the condition, mention the condition In case of enum and Boolean, explain meaning of each enum value or boolean value

Field Name	Business Purpose	Field type (with size) Rich text Text (short text, long text) Number (integer, decimal) Date and Time Location Media Boolean enum [value1, value 2] Array[of what] JSON object Reference	Is it a required field?	Is it editable?	Is it Unique?	Specific validations for some field type Text (short-text, long text)- Character count, a specific pattern (URL, email, slug, custom) prohibit pattern Media (file type, image dimensions, file size)	REFERENCE OF OTHER BUILDING BLOCK Accept only specified values. If Yes, mention what values. In case values are to be filled by reference to records in other datastore - mention the reference to records In case there is the condition, mention the condition In case of enum and Boolean, explain meaning of each enum value or boolean value
id	Unique identifier for this collaborator	integer	Yes	No	Yes	No	No
firstName	First name from profile	short-text	Yes	Yes	No	no	profile
lastName	Last name from profile	short-text	No	Yes	No	No	profile
email	email from profile	text	Yes	Yes	No	fulfill email pattern	profile
profileId	id of profile	int	yes	no	Yes	no	no
appId	id of app	int	yes	no	Yes	no	no
Role	Role of profile(app specific)	enum[collaborator,user]	yes	yes	no	no	no
status	status of profile	enum[pending,accepted]	Yes	Yes	No	no	no
createdAt	created date of Collaborator	timestamp	no	no	no	yyyy-mm-dd h:m:s
updatedAt	updated date of Collaborator	timestamp	no	no	no	yyyy-mm-dd h:m:s

Apps and Automations