Partner Account Data

Database: Mysql

Table name: ie_partner

Field Name	Business Purpose	Field type (with size)	Data type	Should indexable?	is Foreign Key	is primary 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 indexable?	is Foreign Key	is primary key	Is it a required field?	Is it editable?	Is it Unique?	Specific validations for some field type	REFERENCE OF OTHER BUILDING BLOCK
partnerId	unique and incremental id for this table	number	int	Yes	No	Yes	yes	No	Yes	incremental	No
partnerCode	4 char alpha-numeric auto-generated unique code	string	varchar	Yes	No	No	Yes	No	Yes	alpha-numeric 6 digits	No
businessName	Name of the business	string	varchar	No	No	No	Yes	No	No	No	No
goal	The goal of this account	enum	enum	No	No	No	Yes	No	No	No	app , process
addressLine1	Address Line 1	string	text	No	No	No	No	Yes	No	No	No
addressLine2	Address Line 2	string	text	No	No	No	No	Yes	No	No	No
addressCity	City	string	varchar	No	No	No	No	Yes	No	No	No
addressStateCode	State	string	varchar	No	No	No	No	Yes	No	No	No
addressCountryCode	Country	string	varchar	No	No	No	No	Yes	No	No	No
addressPincode	Pin code of the location	string	varchar	No	No	No	No	Yes	No	No	No
contactEmail	Email	string	varchar	No	No	No	No	Yes	No	No	No
contactPhone	Phone number	string	varchar	No	No	No	No	Yes	No	No	No
emergencyContactEmail	Email of a partner	string	varchar	No	No	No	No	Yes	No	No	No
emergencyContactPhone	Phone number of a partner	string	varchar	No	No	No	No	Yes	No	No	No
createdAt	created date of Partner Account	string	timestamp	No	No	No	Yes	no	no	yyyy-mm-dd h:m:s	No
updatedAt	updated date of Partner Account	string	timestamp	No	No	No	Yes	no	no	yyyy-mm-dd h:m:s	No

datatype

Apps and Automations