{
	"name": "table/common/person.json",
	"table_name": "person",
	"table_prefix": "per",
	"record_type": ["", "user", "employee", "customer", "supplier"],
	"table_name_language": {
		"": "Person",
		"user": "User",
		"employee": "Employee",
		"customer": "Customer person",
		"supplier": "Supplier person"
	},
	"default_field": "table/prf/default_field.json",
	"default_order": [
		{
			"field": "full_name",
			"order": ">"
		}
	],
	"calculated_field": [],
	"script_field": ["first_name"],
	"field": [
		{
			"field_name": "person_id",
			"field_type": "varchar",
			"field_length": 80,
			"constraint-": ["primary key"],
			"not_allowed_value-": [""]
		},
		{
			"field_name": "login_id",
			"field_type": "varchar",
			"field_length": 40,
			"constraint": ["index"],
			"not_allowed_value": [""]
		},
		{
			"field_name": "person_state",
			"field_type": "varchar",
			"field_length": 40
		},
		{
			"field_name": "first_name",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "last_name",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "full_name",
			"field_type": "varchar",
			"field_length": 120
		},
		{
			"field_name": "title",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "position",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "phone",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "post_code",
			"field_type": "varchar",
			"field_length": 40
		},
		{
			"field_name": "post_office",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "address",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "email",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "account_status",
			"field_type": "varchar",
			"field_length": 40
		},
		{
			"field_name": "password_hash",
			"field_type": "text"
		},
		{
			"field_name": "info",
			"field_type": "text"
		}
	],
	"extra_field": [
		{
			"field_name": "json_data.employee_number",
			"field_type": "text"
		},
		{
			"field_name": "json_data.activation_code",
			"field_type": "text"
		},
		{
			"field_name": "json_data.department",
			"field_type": "text"
		},
		{
			"field_name": "json_data.note",
			"field_type": "text"
		},
		{
			"field_name": "json_data.company_id",
			"field_type": "varchar",
			"field_length": 40,
			"foreign_key-": [
				{
					"link_type": "prevent delete",
					"linked_field": "company_id",
					"linked_table": "company"
				}
			],
			"not_allowed_value-": [""]
		},
		{
			"field_name": "json_data.keyword1",
			"field_type": "text"
		},
		{
			"field_name": "json_data.keyword2",
			"field_type": "text"
		},
		{
			"field_name": "json_data.keyword3",
			"field_type": "text"
		},
		{
			"field_name": "json_data.keyword4",
			"field_type": "text"
		},
		{
			"field_name": "json_data.keyword5",
			"field_type": "text"
		},
		{
			"field_name": "json_data.keyword6",
			"field_type": "text"
		},
		{
			"field_name": "json_data.phone2",
			"field_type": "varchar",
			"field_length": 80
		},
		{
			"field_name": "json_data.employee_group",
			"field_type": "text"
		}
	]
}
