nuno / schema.php

/** * This is the model class for table "{{%building_type}}". * * @property int $id * @property string|null $guid * @property string $name * @property int|null $public_use * @property int|null $status * @property int|null $record_status * @property int|null $position * @property string|null $language * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by * * @property EquipmentType[] $equipmentTypes * @property PeriodicInspectionSetting[] $periodicInspectionSettings */ /** * Emie model — maps to the `emie` table. * EMIE = Empresa de Manutenção de Instalações de Elevadores. * * @property int $id * @property string $guid * @property string $name * @property string $ref * @property string|null $tax_number * @property string|null $address * @property string|null $postal_code * @property int|null $municipality_id * @property string|null $phone * @property string|null $mobile * @property string|null $email * @property string|null $contact_name * @property string|null $contact_phone * @property string|null $contact_email * @property string|null $observations * @property string|null $rejection_reason_internal * @property string|null $rejection_reason_public * @property int $status * @property int|null $reviewed_at * @property int|null $reviewed_by * @property int $record_status * @property int $created_at * @property int $updated_at * @property int $created_by * @property int $updated_by * * @property EquipmentEmie[] $equipmentEmies * @property Equipment[] $equipment * @property User|null $reviewer * * @mixin TimelineBehaviour */ /** * This is the model class for table "{{%equipment}}". * * @property int $id * @property string|null $guid * @property int $process_number * @property int $type_id * @property string|null $name * @property int|null $owner_id * @property int|null $building_type_id * @property int|null $public_usage Null = inherit from building type; 0 = no; 1 = yes * @property string|null $installation_date * @property string|null $address * @property string|null $postal_code * @property int|null $municipality_id * @property string|null $observations * @property int|null $status * @property int|null $record_status * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by * * @property BuildingType $buildingType * @property Municipality $municipality * @property Owner $owner * @property EquipmentType $type * * @mixin TimelineBehaviour */ /** * EquipmentEmie model — maps to `equipment_emie`. * Junction between Equipment and Emie with history tracking. * * @property int $id * @property int $equipment_id * @property int $emie_id * @property int $is_current * @property string $started_at * @property string|null $ended_at * @property string|null $notes * @property int $status * @property int $record_status * * @property Equipment $equipment * @property Emie $emie */ /** * EquipmentOwner model — maps to `equipment_owner`. * Links owners and responsibles to equipment with a role. * * @property int $id * @property int $equipment_id * @property int $owner_id * @property string $role * @property string|null $started_at * @property string|null $notes * @property int $status * @property int $record_status * * @property Equipment $equipment * @property Owner $owner */ /** * Holds Equipment self-submission requests awaiting admin review. * * Attribute names mirror {@see Equipment} so the existing equipment `_form.php` * partial works unchanged when binding to this model. * * @property int $id * @property string|null $guid * @property int $user_id * @property int $owner_id * @property int $type_id * @property string|null $name * @property int|null $building_type_id * @property int|null $public_usage * @property string|null $installation_date * @property string|null $address * @property string|null $postal_code * @property int|null $municipality_id * @property string|null $observations * @property int $status * @property string|null $rejection_reason_internal * @property string|null $rejection_reason_public * @property int|null $equipment_id * @property int|null $reviewed_at * @property int|null $reviewed_by * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by * * @property User $user * @property Owner $owner * @property EquipmentType $type * @property BuildingType|null $buildingType * @property Municipality|null $municipality * @property Equipment|null $equipment * @property User|null $reviewer */ /** * EquipmentStatusHistory model — maps to `equipment_status_history`. * Immutable record of every status change on an equipment. * * @property int $id * @property int $equipment_id * @property string $status * @property int $changed_at * @property string|null $notes * @property int $record_status * * @property Equipment $equipment */ /** * This is the model class for table "{{%equipment_type}}". * * @property int $id * @property string|null $guid * @property string $name * @property int $periodic_inspection Default Periodic Inspection Time in years * @property int|null $status * @property int|null $record_status * @property int|null $position * @property string|null $language * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by * * @property BuildingType[] $buildingTypes * @property Equipment[] $equipments * @property PeriodicInspectionSetting[] $periodicInspectionSettings */ /** * Inspector model — maps to `inspector`. * Individual inspector person linked to an InspectorEntity. * Optionally linked to a platform User account. * * @property int $id * @property string $guid * @property int $inspector_entity_id * @property int|null $user_id * @property string $name * @property string|null $license_number * @property string|null $phone * @property string|null $email * @property string|null $observations * @property int $status * @property int $record_status * * @property InspectorEntity $inspectorEntity */ /** * InspectorEntity model — maps to `inspector_entity`. * Inspection company controlled by CIMLT. * * @property int $id * @property string $guid * @property string $name * @property string|null $tax_number * @property string|null $license_number * @property string|null $address * @property string|null $postal_code * @property int|null $municipality_id * @property string|null $phone * @property string|null $mobile * @property string|null $email * @property string|null $observations * @property int $status * @property int $record_status * * @property Inspector[] $inspectors * * @mixin TimelineBehaviour */ /** * Invoice model — maps to the `invoice` table. * * @property int $id * @property string $guid * @property string $reference * @property string $invoice_status * @property int $equipment_id * @property int $owner_id * @property string $issued_at * @property string|null $paid_at * @property string $billing_period_start * @property string $billing_period_end * @property float $amount * @property string|null $notes * @property int $status * @property int $record_status * @property int $created_at * @property int $updated_at * @property int $created_by * @property int $updated_by * * @property Equipment $equipment * @property Owner $owner * @property InvoicePaymentReference[] $paymentReferences * @property InvoicePaymentReference|null $activePaymentReference * * @mixin TimelineBehaviour */ /** * InvoicePaymentReference model — maps to `invoice_payment_reference`. * * @property int $id * @property string $guid * @property int $invoice_id * @property string $entity * @property string $reference * @property float $amount * @property int $expires_at * @property string $payment_type * @property int $status * @property int $record_status * @property int $created_at * @property int $updated_at * @property int $created_by * @property int $updated_by * * @property Invoice $invoice */ /** * InvoiceSequence model — maps to the `invoice_sequence` table. * Handles atomic reference number generation per prefix series. * * @property int $id * @property string $guid * @property string $prefix * @property int $last_number * @property int $padding * @property string|null $description * @property int $status * @property int $record_status * @property int $created_at * @property int $updated_at * @property int $created_by * @property int $updated_by */ /** * This is the model class for table "{{%municipality}}". * * @property int $id * @property string|null $guid * @property string $name * @property string $slug * @property int|null $code * @property float|null $lat * @property float|null $lng * @property int|null $status * @property int|null $record_status * @property int|null $position * @property string|null $language * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by */ /** * This is the model class for table "{{%owner}}". * * @property int $id * @property string|null $guid * @property int|null $user_id * @property string $name * @property int $type_id * @property string|null $tax_number * @property string|null $address * @property string|null $postal_code * @property int|null $municipality_id * @property int|null $country_id * @property string|null $phone * @property string|null $landline * @property string|null $email * @property string|null $observations * @property int|null $status * @property int|null $record_status * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by * * @property Equipment[] $equipments * @property Municipality $municipality * @property OwnerType $type * @property User|null $user */ /** * Holds public Owner self-registration submissions awaiting admin review. * * @property int $id * @property string|null $guid * @property int $user_id * @property string $tax_number * @property string $owner_name * @property int|null $municipality_id * @property string|null $phone * @property string|null $address * @property int|null $type_id * @property string|null $postal_code * @property int|null $process_number * @property int|null $emie_id * @property int $status * @property string|null $rejection_reason_internal * @property string|null $rejection_reason_public * @property int|null $owner_id * @property int|null $reviewed_at * @property int|null $reviewed_by * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by * * @property User $user * @property Owner|null $owner * @property Municipality|null $municipality * @property EquipmentType|null $type * @property User|null $reviewer */ /** * This is the model class for table "{{%owner_type}}". * * @property int $id * @property string|null $guid * @property string $name * @property int|null $status * @property int|null $record_status * @property int|null $position * @property string|null $language * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by */ /** * This is the model class for table "{{%periodic_inspection_setting}}". * * @property int $id * @property int $building_type_id * @property int $equipment_type_id * @property int $periodic_inspection Periodic Inspection Time in years * @property int|null $status * @property int|null $record_status * @property int|null $position * @property string|null $language * @property int|null $created_at * @property int|null $updated_at * @property int|null $created_by * @property int|null $updated_by * * @property BuildingType $buildingType * @property EquipmentType $equipmentType */ /** * Visit model — maps to the `visit` table. * Records inspection visits to equipment (1:1 per visit). * * @property int $id * @property string $guid * @property int $equipment_id * @property int|null $inspector_entity_id * @property int|null $inspector_id * @property string $visit_status * @property string $result * @property string|null $scheduled_at * @property string|null $inspected_at * @property string|null $next_inspection_at * @property string|null $notes * @property int $status * @property int $record_status * @property int $created_at * @property int $updated_at * @property int $created_by * @property int $updated_by * * @property Equipment $equipment * @property InspectorEntity|null $inspectorEntity * @property Inspector|null $inspector * * @mixin TimelineBehaviour */ /** * User ActiveRecord model. * * @property bool $isAdmin * @property bool $isBlocked * @property bool $isConfirmed whether user account has been confirmed or not * @property bool $gdpr_deleted whether user requested deletion of his account * @property bool $gdpr_consent whether user has consent personal data processing * * Database fields: * @property int $id * @property string $username * @property string $email * @property ?string $unconfirmed_email * @property string $password_hash * @property string $auth_key * @property ?string $auth_tf_key * @property int $auth_tf_enabled * @property ?string $auth_tf_type * @property ?string $auth_tf_mobile_phone * @property ?string $registration_ip * @property ?int $confirmed_at * @property ?int $blocked_at * @property int $flags * @property int $created_at * @property int $updated_at * @property ?int $last_login_at * @property ?int $gdpr_consent_date date of agreement of data processing * @property ?string $last_login_ip * @property ?int $password_changed_at * @property int $password_age * Defined relations: * @property SocialNetworkAccount[] $socialNetworkAccounts * @property ?Profile $profile */ /** * This is the model class for table "{{%profile}}". * * @property int $user_id * @property string|null $name * @property string|null $public_email * @property string|null $gravatar_email * @property string|null $gravatar_id * @property string|null $location * @property string|null $website * @property string|null $timezone * @property string|null $bio * @property string $guid GUID * @property string|null $slug * @property string|null $preferred_name * @property string|null $initials * @property string|null $job_title * @property string|null $date_of_birth * @property string|null $title * @property int|null $date_of_birth_is_public * @property int|null $created_at * @property int|null $created_by * @property int|null $updated_at * @property int|null $updated_by * * @property User $user */