{
	"name": "table/manager/resource/person.json",
	"table_name": "person",
	"table_prefix": "per",
	"record_type": ["customer", "supplier", "employee", "user"],
	"default_order": [
		{
			"field": "person_id",
			"order": ">"
		}
	],
	"save_script": [],
	"calculated_field": [],
	"field": [
		{
			"field_length": 80,
			"field_name": "address"
		},
		{
			"field_length": 80,
			"field_name": "email"
		},
		{
			"field_length": 80,
			"field_name": "first_name"
		},
		{
			"field_type": "text",
			"field_name": "hash"
		},
		{
			"field_type": "text",
			"field_name": "info"
		},
		{
			"field_length": 80,
			"field_name": "last_name"
		},
		{
			"constraint": ["unique"],
			"field_length": 40,
			"field_name": "login_id",
			"not_allowed_value": [""]
		},
		{
			"field_length": 80,
			"field_name": "name"
		},
		{
			"constraint": ["primary key"],
			"field_length": 80,
			"field_name": "person_id",
			"not_allowed_value": [""]
		},
		{
			"field_name": "person_state",
			"field_type": "varchar",
			"field_length": 40
		},
		{
			"field_length": 80,
			"field_name": "phone_number"
		},
		{
			"field_length": 40,
			"field_name": "post_code"
		},
		{
			"field_length": 80,
			"field_name": "post_office"
		},
		{
			"field_length": 40,
			"field_type": "varchar",
			"field_name": "account_status"
		}
	],
	"extra_field": [
		{
			"field_name": "json_data.work_time_bank_date",
			"field_type": "date"
		},
		{
			"field_name": "json_data.title",
			"field_type": "varchar",
			"length": 50
		},
		{
			"field_name": "json_data.transfer_id",
			"field_type": "varchar",
			"length": 120
		},
		{
			"field_name": "json_data.work_time_bank",
			"field_type": "double"
		},
		{
			"field_name": "json_data.mobile_phone_number",
			"field_type": "varchar",
			"length": 40
		},
		{
			"field_name": "json_data.work_calendar",
			"field_type": "varchar",
			"length": 80
		},
		{
			"field_name": "json_data.customer_project",
			"field_type": "varchar",
			"length": 80
		},
		{
			"field_name": "json_data.second_name",
			"field_type": "varchar",
			"length": 30
		},
		{
			"field_name": "json_data.social_security_number",
			"field_type": "varchar",
			"length": 26
		},
		{
			"field_name": "json_data.transfer_state",
			"field_type": "integer"
		},
		{
			"field_name": "json_data.modifier_id",
			"field_type": "varchar",
			"length": 40
		},
		{
			"field_name": "json_data.position",
			"field_type": "varchar",
			"length": 50
		},
		{
			"field_name": "json_data.order_number",
			"field_type": "integer"
		},
		{
			"field_name": "json_data.work_phone_number",
			"field_type": "varchar",
			"length": 40
		},
		{
			"field_name": "json_data.work_hourly_salary",
			"field_type": "double"
		},
		{
			"field_name": "json_data.firm_id",
			"field_type": "integer"
		},
		{
			"field_name": "json_data.type",
			"field_type": "integer"
		},
		{
			"field_name": "json_data.in_calendar",
			"field_type": "boolean"
		},
		{
			"field_name": "json_data.third_name",
			"field_type": "varchar",
			"length": 30
		},
		{
			"field_name": "json_data.telephone_number",
			"field_type": "varchar",
			"length": 40
		},
		{
			"field_name": "json_data.picture_path",
			"field_type": "text"
		},
		{
			"field_name": "json_data.telephone_area_code",
			"field_type": "varchar",
			"length": 10
		},
		{
			"field_name": "json_data.bank",
			"field_type": "varchar",
			"length": 80
		},
		{
			"field_name": "json_data.employee_number",
			"field_type": "varchar",
			"length": 24
		},
		{
			"field_name": "json_data.employment_date",
			"field_type": "date"
		},
		{
			"field_name": "json_data.project_id",
			"field_type": "varchar",
			"length": 80
		},
		{
			"field_name": "json_data.setup_hourly_salary",
			"field_type": "double"
		},
		{
			"field_name": "json_data.storage_place",
			"field_type": "varchar",
			"length": 60
		},
		{
			"field_name": "json_data.average_hourly_salary",
			"field_type": "double"
		},
		{
			"field_name": "json_data.bank_account",
			"field_type": "varchar",
			"length": 30
		},
		{
			"field_name": "json_data.employee_group",
			"field_type": "varchar",
			"length": 30
		},
		{
			"field_name": "json_data.contract_multiplier",
			"field_type": "double"
		}
	],
	"default_field": "table/default_field.json"
}
