{
	"field": [
		{
			"type": "varchar",
			"length": 80,
			"name": "person_id",
			"constraint": [
				"primary key",
				"unique"
			]
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "first_name"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "last_name"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "name"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "address"
		},
		{
			"type": "varchar",
			"length": 40,
			"name": "post_code"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "post_office"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "email"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "phone_number"
		},
		{
			"type": "varchar",
			"length": 40,
			"name": "login_id"
		},
		{
			"name": "person_state",
			"type": "integer"
		},
		{
			"type": "varchar",
			"length": 255,
			"name": "hash"
		},
		{
			"type": "varchar",
			"length": 40,
			"name": "status"
		},
		{
			"name": "info",
			"type": "text"
		},
		{
			"name": "json_data",
			"type": "jsonb"
		}
	],
	"table_prefix": "per",
	"save_script": [],
	"extra_field": [
		{
			"type": "double",
			"name": "json_data.average_hourly_salary"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "json_data.bank"
		},
		{
			"type": "varchar",
			"length": 30,
			"name": "json_data.bank_account"
		},
		{
			"type": "double",
			"name": "json_data.contract_multiplier"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "json_data.customer_project"
		},
		{
			"type": "varchar",
			"length": 30,
			"name": "json_data.employee_group"
		},
		{
			"type": "varchar",
			"length": 24,
			"name": "json_data.employee_number"
		},
		{
			"type": "date",
			"name": "json_data.employment_date"
		},
		{
			"type": "integer",
			"name": "json_data.firm_id"
		},
		{
			"type": "boolean",
			"name": "json_data.in_calendar"
		},
		{
			"type": "varchar",
			"length": 40,
			"name": "json_data.mobile_phone_number"
		},
		{
			"type": "varchar",
			"length": 40,
			"name": "json_data.modifier_id"
		},
		{
			"type": "integer",
			"name": "json_data.order_number"
		},
		{
			"type": "text",
			"name": "json_data.picture_path"
		},
		{
			"type": "varchar",
			"length": 50,
			"name": "json_data.position"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "json_data.project_id"
		},
		{
			"type": "double",
			"name": "json_data.work_hourly_salary"
		},
		{
			"type": "varchar",
			"length": 30,
			"name": "json_data.second_name"
		},
		{
			"type": "double",
			"name": "json_data.setup_hourly_salary"
		},
		{
			"type": "varchar",
			"length": 26,
			"name": "json_data.social_security_number"
		},
		{
			"type": "varchar",
			"length": 60,
			"name": "json_data.storage_place"
		},
		{
			"type": "varchar",
			"length": 10,
			"name": "json_data.telephone_area_code"
		},
		{
			"type": "varchar",
			"length": 40,
			"name": "json_data.telephone_number"
		},
		{
			"type": "varchar",
			"length": 30,
			"name": "json_data.third_name"
		},
		{
			"type": "varchar",
			"length": 50,
			"name": "json_data.title"
		},
		{
			"type": "varchar",
			"length": 120,
			"name": "json_data.transfer_id"
		},
		{
			"type": "integer",
			"name": "json_data.transfer_state"
		},
		{
			"type": "integer",
			"name": "json_data.type"
		},
		{
			"type": "varchar",
			"length": 80,
			"name": "json_data.work_calendar"
		},
		{
			"type": "varchar",
			"length": 40,
			"name": "json_data.work_phone_number"
		},
		{
			"type": "double",
			"name": "json_data.work_time_bank"
		},
		{
			"type": "date",
			"name": "json_data.work_time_bank_date"
		}
	],
	"calculated_field": [],
	"constraint": {
		"save": {
			"allow": [
				{
					"field": "per_person_id",
					"message": "Field '%s' may not be empty",
					"code": [
						[
							"per_person_id",
							"<>",
							""
						]
					]
				}
			]
		}
	},
	"name": "table/manager/resource/person.json",
	"table_name": "person"
}