{
	"name": "table/external/clickup/common/person-employee.json",
	"table_name": "user",
	"table_prefix": "per",
	"record_type": ["employee"],
	"local_table": "person",
	"local_record_type": "employee",
	"field": [
		{
			"field_name": "color",
			"local_field": "json_data.keyword1",
			"field_type": "text"
		},
		{
			"field_name": "date_invited",
			"local_field": "json_data.keyword2",
			"field_type": "text"
		},
		{
			"field_name": "date_joined",
			"local_field": "create_time",
			"field_type": "text"
		},
		{
			"field_name": "db_id",
			"local_field": "db_id",
			"field_type": "bigint"
		},
		{
			"field_name": "db_modify_id",
			"local_field": "db_modify_id",
			"field_type": "bigint"
		},
		{
			"field_name": "email",
			"local_field": "email",
			"field_type": "text"
		},
		{
			"field_name": "id",
			"local_field": "person_id",
			"field_type": "bigint"
		},
		{
			"field_name": "initials",
			"local_field": "first_name",
			"field_type": "text"
		},
		{
			"field_name": "last_active",
			"local_field": "json_data.keyword3",
			"field_type": "text"
		},
		{
			"field_name": "profilepicture",
			"field_type": "text"
		},
		{
			"field_name": "role",
			"local_field": "title",
			"field_type": "integer"
		},
		{
			"field_name": "username",
			"local_field": "full_name",
			"field_type": "text"
		}
	],
	"example_data": {
		"user_task": {
			"id": 60386774,
			"color": "null",
			"email": "paavo.komppa@capacic.com",
			"initials": "PK",
			"profilePicture": "null",
			"username": "Paavo Komppa"
		},
		"user_team": {
			"id": 60386774,
			"color": "null",
			"custom_role": "null",
			"date_invited": "1692191478189",
			"date_joined": "1692192350785",
			"email": "paavo.komppa@capacic.com",
			"initials": "PK",
			"last_active": "1695144543061",
			"profilePicture": "null",
			"role": 2,
			"username": "Paavo Komppa"
		}
	}
}
