locationtable.php

См. документацию.

<?php
namespace Bitrix\Location\Model;
 
use Bitrix\Location\Entity\Location\Type;
use Bitrix\Main;
use Bitrix\Main\ORM\Fields;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\ORM\Fields\Relations;

 
class LocationTable extends Main\ORM\Data\DataManager
{
    public static function getTableName()
    {
        return 'b_location';
    }

    public static function getMap()
    {
        return [
            (new Fields\IntegerField('ID'))
                ->configurePrimary(true)
                ->configureAutocomplete(true),
 
            (new Fields\StringField('CODE'))
                ->addValidator(new Main\ORM\Fields\Validators\LengthValidator(1, 100))
                ->configureUnique(true)
                ->configureRequired(true),
 
            (new Fields\StringField('EXTERNAL_ID'))
                ->addValidator(new Main\ORM\Fields\Validators\LengthValidator(null, 255)),
 
            (new Fields\StringField('SOURCE_CODE'))
                ->addValidator(new Main\ORM\Fields\Validators\LengthValidator(null, 15)),
 
            new Fields\FloatField('LATITUDE', ['scale' => 6]),
            new Fields\FloatField('LONGITUDE', ['scale' => 6]),
            new Fields\DatetimeField('TIMESTAMP_X', [
                'default_value' => static fn() => new Main\Type\DateTime(),
            ]),
 
            (new Fields\IntegerField('TYPE'))
                ->configureRequired(true),
 
            // References
 
            (new Relations\OneToMany('NAME', LocationNameTable::class, 'LOCATION'))
                ->configureJoinType('left'),
 
            (new Relations\OneToMany('ANCESTORS', HierarchyTable::class, 'ANCESTOR'))
                ->configureJoinType('left'),
 
            (new Relations\OneToMany('DESCENDANTS', HierarchyTable::class, 'DESCENDANT'))
                ->configureJoinType('left'),
 
            (new Relations\OneToMany('ADDRESSES', AddressTable::class, 'LOCATION'))
                ->configureJoinType('left'),
 
            (new Fields\Relations\OneToMany('FIELDS', LocationFieldTable::class, 'LOCATION'))
                ->configureJoinType('left')
        ];
    }
}