nuno bu gisti düzenledi 1 month ago. Düzenlemeye git
1 file changed, 521 insertions
schema.php(dosya oluşturuldu)
| @@ -0,0 +1,521 @@ | |||
| 1 | + | /** | |
| 2 | + | * This is the model class for table "{{%building_type}}". | |
| 3 | + | * | |
| 4 | + | * @property int $id | |
| 5 | + | * @property string|null $guid | |
| 6 | + | * @property string $name | |
| 7 | + | * @property int|null $public_use | |
| 8 | + | * @property int|null $status | |
| 9 | + | * @property int|null $record_status | |
| 10 | + | * @property int|null $position | |
| 11 | + | * @property string|null $language | |
| 12 | + | * @property int|null $created_at | |
| 13 | + | * @property int|null $updated_at | |
| 14 | + | * @property int|null $created_by | |
| 15 | + | * @property int|null $updated_by | |
| 16 | + | * | |
| 17 | + | * @property EquipmentType[] $equipmentTypes | |
| 18 | + | * @property PeriodicInspectionSetting[] $periodicInspectionSettings | |
| 19 | + | */ | |
| 20 | + | ||
| 21 | + | /** | |
| 22 | + | * Emie model — maps to the `emie` table. | |
| 23 | + | * EMIE = Empresa de Manutenção de Instalações de Elevadores. | |
| 24 | + | * | |
| 25 | + | * @property int $id | |
| 26 | + | * @property string $guid | |
| 27 | + | * @property string $name | |
| 28 | + | * @property string $ref | |
| 29 | + | * @property string|null $tax_number | |
| 30 | + | * @property string|null $address | |
| 31 | + | * @property string|null $postal_code | |
| 32 | + | * @property int|null $municipality_id | |
| 33 | + | * @property string|null $phone | |
| 34 | + | * @property string|null $mobile | |
| 35 | + | * @property string|null $email | |
| 36 | + | * @property string|null $contact_name | |
| 37 | + | * @property string|null $contact_phone | |
| 38 | + | * @property string|null $contact_email | |
| 39 | + | * @property string|null $observations | |
| 40 | + | * @property string|null $rejection_reason_internal | |
| 41 | + | * @property string|null $rejection_reason_public | |
| 42 | + | * @property int $status | |
| 43 | + | * @property int|null $reviewed_at | |
| 44 | + | * @property int|null $reviewed_by | |
| 45 | + | * @property int $record_status | |
| 46 | + | * @property int $created_at | |
| 47 | + | * @property int $updated_at | |
| 48 | + | * @property int $created_by | |
| 49 | + | * @property int $updated_by | |
| 50 | + | * | |
| 51 | + | * @property EquipmentEmie[] $equipmentEmies | |
| 52 | + | * @property Equipment[] $equipment | |
| 53 | + | * @property User|null $reviewer | |
| 54 | + | * | |
| 55 | + | * @mixin TimelineBehaviour | |
| 56 | + | */ | |
| 57 | + | ||
| 58 | + | /** | |
| 59 | + | * This is the model class for table "{{%equipment}}". | |
| 60 | + | * | |
| 61 | + | * @property int $id | |
| 62 | + | * @property string|null $guid | |
| 63 | + | * @property int $process_number | |
| 64 | + | * @property int $type_id | |
| 65 | + | * @property string|null $name | |
| 66 | + | * @property int|null $owner_id | |
| 67 | + | * @property int|null $building_type_id | |
| 68 | + | * @property int|null $public_usage Null = inherit from building type; 0 = no; 1 = yes | |
| 69 | + | * @property string|null $installation_date | |
| 70 | + | * @property string|null $address | |
| 71 | + | * @property string|null $postal_code | |
| 72 | + | * @property int|null $municipality_id | |
| 73 | + | * @property string|null $observations | |
| 74 | + | * @property int|null $status | |
| 75 | + | * @property int|null $record_status | |
| 76 | + | * @property int|null $created_at | |
| 77 | + | * @property int|null $updated_at | |
| 78 | + | * @property int|null $created_by | |
| 79 | + | * @property int|null $updated_by | |
| 80 | + | * | |
| 81 | + | * @property BuildingType $buildingType | |
| 82 | + | * @property Municipality $municipality | |
| 83 | + | * @property Owner $owner | |
| 84 | + | * @property EquipmentType $type | |
| 85 | + | * | |
| 86 | + | * @mixin TimelineBehaviour | |
| 87 | + | */ | |
| 88 | + | ||
| 89 | + | /** | |
| 90 | + | * EquipmentEmie model — maps to `equipment_emie`. | |
| 91 | + | * Junction between Equipment and Emie with history tracking. | |
| 92 | + | * | |
| 93 | + | * @property int $id | |
| 94 | + | * @property int $equipment_id | |
| 95 | + | * @property int $emie_id | |
| 96 | + | * @property int $is_current | |
| 97 | + | * @property string $started_at | |
| 98 | + | * @property string|null $ended_at | |
| 99 | + | * @property string|null $notes | |
| 100 | + | * @property int $status | |
| 101 | + | * @property int $record_status | |
| 102 | + | * | |
| 103 | + | * @property Equipment $equipment | |
| 104 | + | * @property Emie $emie | |
| 105 | + | */ | |
| 106 | + | ||
| 107 | + | /** | |
| 108 | + | * EquipmentOwner model — maps to `equipment_owner`. | |
| 109 | + | * Links owners and responsibles to equipment with a role. | |
| 110 | + | * | |
| 111 | + | * @property int $id | |
| 112 | + | * @property int $equipment_id | |
| 113 | + | * @property int $owner_id | |
| 114 | + | * @property string $role | |
| 115 | + | * @property string|null $started_at | |
| 116 | + | * @property string|null $notes | |
| 117 | + | * @property int $status | |
| 118 | + | * @property int $record_status | |
| 119 | + | * | |
| 120 | + | * @property Equipment $equipment | |
| 121 | + | * @property Owner $owner | |
| 122 | + | */ | |
| 123 | + | ||
| 124 | + | /** | |
| 125 | + | * Holds Equipment self-submission requests awaiting admin review. | |
| 126 | + | * | |
| 127 | + | * Attribute names mirror {@see Equipment} so the existing equipment `_form.php` | |
| 128 | + | * partial works unchanged when binding to this model. | |
| 129 | + | * | |
| 130 | + | * @property int $id | |
| 131 | + | * @property string|null $guid | |
| 132 | + | * @property int $user_id | |
| 133 | + | * @property int $owner_id | |
| 134 | + | * @property int $type_id | |
| 135 | + | * @property string|null $name | |
| 136 | + | * @property int|null $building_type_id | |
| 137 | + | * @property int|null $public_usage | |
| 138 | + | * @property string|null $installation_date | |
| 139 | + | * @property string|null $address | |
| 140 | + | * @property string|null $postal_code | |
| 141 | + | * @property int|null $municipality_id | |
| 142 | + | * @property string|null $observations | |
| 143 | + | * @property int $status | |
| 144 | + | * @property string|null $rejection_reason_internal | |
| 145 | + | * @property string|null $rejection_reason_public | |
| 146 | + | * @property int|null $equipment_id | |
| 147 | + | * @property int|null $reviewed_at | |
| 148 | + | * @property int|null $reviewed_by | |
| 149 | + | * @property int|null $created_at | |
| 150 | + | * @property int|null $updated_at | |
| 151 | + | * @property int|null $created_by | |
| 152 | + | * @property int|null $updated_by | |
| 153 | + | * | |
| 154 | + | * @property User $user | |
| 155 | + | * @property Owner $owner | |
| 156 | + | * @property EquipmentType $type | |
| 157 | + | * @property BuildingType|null $buildingType | |
| 158 | + | * @property Municipality|null $municipality | |
| 159 | + | * @property Equipment|null $equipment | |
| 160 | + | * @property User|null $reviewer | |
| 161 | + | */ | |
| 162 | + | ||
| 163 | + | /** | |
| 164 | + | * EquipmentStatusHistory model — maps to `equipment_status_history`. | |
| 165 | + | * Immutable record of every status change on an equipment. | |
| 166 | + | * | |
| 167 | + | * @property int $id | |
| 168 | + | * @property int $equipment_id | |
| 169 | + | * @property string $status | |
| 170 | + | * @property int $changed_at | |
| 171 | + | * @property string|null $notes | |
| 172 | + | * @property int $record_status | |
| 173 | + | * | |
| 174 | + | * @property Equipment $equipment | |
| 175 | + | */ | |
| 176 | + | ||
| 177 | + | /** | |
| 178 | + | * This is the model class for table "{{%equipment_type}}". | |
| 179 | + | * | |
| 180 | + | * @property int $id | |
| 181 | + | * @property string|null $guid | |
| 182 | + | * @property string $name | |
| 183 | + | * @property int $periodic_inspection Default Periodic Inspection Time in years | |
| 184 | + | * @property int|null $status | |
| 185 | + | * @property int|null $record_status | |
| 186 | + | * @property int|null $position | |
| 187 | + | * @property string|null $language | |
| 188 | + | * @property int|null $created_at | |
| 189 | + | * @property int|null $updated_at | |
| 190 | + | * @property int|null $created_by | |
| 191 | + | * @property int|null $updated_by | |
| 192 | + | * | |
| 193 | + | * @property BuildingType[] $buildingTypes | |
| 194 | + | * @property Equipment[] $equipments | |
| 195 | + | * @property PeriodicInspectionSetting[] $periodicInspectionSettings | |
| 196 | + | */ | |
| 197 | + | ||
| 198 | + | /** | |
| 199 | + | * Inspector model — maps to `inspector`. | |
| 200 | + | * Individual inspector person linked to an InspectorEntity. | |
| 201 | + | * Optionally linked to a platform User account. | |
| 202 | + | * | |
| 203 | + | * @property int $id | |
| 204 | + | * @property string $guid | |
| 205 | + | * @property int $inspector_entity_id | |
| 206 | + | * @property int|null $user_id | |
| 207 | + | * @property string $name | |
| 208 | + | * @property string|null $license_number | |
| 209 | + | * @property string|null $phone | |
| 210 | + | * @property string|null $email | |
| 211 | + | * @property string|null $observations | |
| 212 | + | * @property int $status | |
| 213 | + | * @property int $record_status | |
| 214 | + | * | |
| 215 | + | * @property InspectorEntity $inspectorEntity | |
| 216 | + | */ | |
| 217 | + | ||
| 218 | + | /** | |
| 219 | + | * InspectorEntity model — maps to `inspector_entity`. | |
| 220 | + | * Inspection company controlled by CIMLT. | |
| 221 | + | * | |
| 222 | + | * @property int $id | |
| 223 | + | * @property string $guid | |
| 224 | + | * @property string $name | |
| 225 | + | * @property string|null $tax_number | |
| 226 | + | * @property string|null $license_number | |
| 227 | + | * @property string|null $address | |
| 228 | + | * @property string|null $postal_code | |
| 229 | + | * @property int|null $municipality_id | |
| 230 | + | * @property string|null $phone | |
| 231 | + | * @property string|null $mobile | |
| 232 | + | * @property string|null $email | |
| 233 | + | * @property string|null $observations | |
| 234 | + | * @property int $status | |
| 235 | + | * @property int $record_status | |
| 236 | + | * | |
| 237 | + | * @property Inspector[] $inspectors | |
| 238 | + | * | |
| 239 | + | * @mixin TimelineBehaviour | |
| 240 | + | */ | |
| 241 | + | ||
| 242 | + | /** | |
| 243 | + | * Invoice model — maps to the `invoice` table. | |
| 244 | + | * | |
| 245 | + | * @property int $id | |
| 246 | + | * @property string $guid | |
| 247 | + | * @property string $reference | |
| 248 | + | * @property string $invoice_status | |
| 249 | + | * @property int $equipment_id | |
| 250 | + | * @property int $owner_id | |
| 251 | + | * @property string $issued_at | |
| 252 | + | * @property string|null $paid_at | |
| 253 | + | * @property string $billing_period_start | |
| 254 | + | * @property string $billing_period_end | |
| 255 | + | * @property float $amount | |
| 256 | + | * @property string|null $notes | |
| 257 | + | * @property int $status | |
| 258 | + | * @property int $record_status | |
| 259 | + | * @property int $created_at | |
| 260 | + | * @property int $updated_at | |
| 261 | + | * @property int $created_by | |
| 262 | + | * @property int $updated_by | |
| 263 | + | * | |
| 264 | + | * @property Equipment $equipment | |
| 265 | + | * @property Owner $owner | |
| 266 | + | * @property InvoicePaymentReference[] $paymentReferences | |
| 267 | + | * @property InvoicePaymentReference|null $activePaymentReference | |
| 268 | + | * | |
| 269 | + | * @mixin TimelineBehaviour | |
| 270 | + | */ | |
| 271 | + | ||
| 272 | + | /** | |
| 273 | + | * InvoicePaymentReference model — maps to `invoice_payment_reference`. | |
| 274 | + | * | |
| 275 | + | * @property int $id | |
| 276 | + | * @property string $guid | |
| 277 | + | * @property int $invoice_id | |
| 278 | + | * @property string $entity | |
| 279 | + | * @property string $reference | |
| 280 | + | * @property float $amount | |
| 281 | + | * @property int $expires_at | |
| 282 | + | * @property string $payment_type | |
| 283 | + | * @property int $status | |
| 284 | + | * @property int $record_status | |
| 285 | + | * @property int $created_at | |
| 286 | + | * @property int $updated_at | |
| 287 | + | * @property int $created_by | |
| 288 | + | * @property int $updated_by | |
| 289 | + | * | |
| 290 | + | * @property Invoice $invoice | |
| 291 | + | */ | |
| 292 | + | ||
| 293 | + | /** | |
| 294 | + | * InvoiceSequence model — maps to the `invoice_sequence` table. | |
| 295 | + | * Handles atomic reference number generation per prefix series. | |
| 296 | + | * | |
| 297 | + | * @property int $id | |
| 298 | + | * @property string $guid | |
| 299 | + | * @property string $prefix | |
| 300 | + | * @property int $last_number | |
| 301 | + | * @property int $padding | |
| 302 | + | * @property string|null $description | |
| 303 | + | * @property int $status | |
| 304 | + | * @property int $record_status | |
| 305 | + | * @property int $created_at | |
| 306 | + | * @property int $updated_at | |
| 307 | + | * @property int $created_by | |
| 308 | + | * @property int $updated_by | |
| 309 | + | */ | |
| 310 | + | ||
| 311 | + | /** | |
| 312 | + | * This is the model class for table "{{%municipality}}". | |
| 313 | + | * | |
| 314 | + | * @property int $id | |
| 315 | + | * @property string|null $guid | |
| 316 | + | * @property string $name | |
| 317 | + | * @property string $slug | |
| 318 | + | * @property int|null $code | |
| 319 | + | * @property float|null $lat | |
| 320 | + | * @property float|null $lng | |
| 321 | + | * @property int|null $status | |
| 322 | + | * @property int|null $record_status | |
| 323 | + | * @property int|null $position | |
| 324 | + | * @property string|null $language | |
| 325 | + | * @property int|null $created_at | |
| 326 | + | * @property int|null $updated_at | |
| 327 | + | * @property int|null $created_by | |
| 328 | + | * @property int|null $updated_by | |
| 329 | + | */ | |
| 330 | + | ||
| 331 | + | /** | |
| 332 | + | * This is the model class for table "{{%owner}}". | |
| 333 | + | * | |
| 334 | + | * @property int $id | |
| 335 | + | * @property string|null $guid | |
| 336 | + | * @property int|null $user_id | |
| 337 | + | * @property string $name | |
| 338 | + | * @property int $type_id | |
| 339 | + | * @property string|null $tax_number | |
| 340 | + | * @property string|null $address | |
| 341 | + | * @property string|null $postal_code | |
| 342 | + | * @property int|null $municipality_id | |
| 343 | + | * @property int|null $country_id | |
| 344 | + | * @property string|null $phone | |
| 345 | + | * @property string|null $landline | |
| 346 | + | * @property string|null $email | |
| 347 | + | * @property string|null $observations | |
| 348 | + | * @property int|null $status | |
| 349 | + | * @property int|null $record_status | |
| 350 | + | * @property int|null $created_at | |
| 351 | + | * @property int|null $updated_at | |
| 352 | + | * @property int|null $created_by | |
| 353 | + | * @property int|null $updated_by | |
| 354 | + | * | |
| 355 | + | * @property Equipment[] $equipments | |
| 356 | + | * @property Municipality $municipality | |
| 357 | + | * @property OwnerType $type | |
| 358 | + | * @property User|null $user | |
| 359 | + | */ | |
| 360 | + | ||
| 361 | + | /** | |
| 362 | + | * Holds public Owner self-registration submissions awaiting admin review. | |
| 363 | + | * | |
| 364 | + | * @property int $id | |
| 365 | + | * @property string|null $guid | |
| 366 | + | * @property int $user_id | |
| 367 | + | * @property string $tax_number | |
| 368 | + | * @property string $owner_name | |
| 369 | + | * @property int|null $municipality_id | |
| 370 | + | * @property string|null $phone | |
| 371 | + | * @property string|null $address | |
| 372 | + | * @property int|null $type_id | |
| 373 | + | * @property string|null $postal_code | |
| 374 | + | * @property int|null $process_number | |
| 375 | + | * @property int|null $emie_id | |
| 376 | + | * @property int $status | |
| 377 | + | * @property string|null $rejection_reason_internal | |
| 378 | + | * @property string|null $rejection_reason_public | |
| 379 | + | * @property int|null $owner_id | |
| 380 | + | * @property int|null $reviewed_at | |
| 381 | + | * @property int|null $reviewed_by | |
| 382 | + | * @property int|null $created_at | |
| 383 | + | * @property int|null $updated_at | |
| 384 | + | * @property int|null $created_by | |
| 385 | + | * @property int|null $updated_by | |
| 386 | + | * | |
| 387 | + | * @property User $user | |
| 388 | + | * @property Owner|null $owner | |
| 389 | + | * @property Municipality|null $municipality | |
| 390 | + | * @property EquipmentType|null $type | |
| 391 | + | * @property User|null $reviewer | |
| 392 | + | */ | |
| 393 | + | ||
| 394 | + | /** | |
| 395 | + | * This is the model class for table "{{%owner_type}}". | |
| 396 | + | * | |
| 397 | + | * @property int $id | |
| 398 | + | * @property string|null $guid | |
| 399 | + | * @property string $name | |
| 400 | + | * @property int|null $status | |
| 401 | + | * @property int|null $record_status | |
| 402 | + | * @property int|null $position | |
| 403 | + | * @property string|null $language | |
| 404 | + | * @property int|null $created_at | |
| 405 | + | * @property int|null $updated_at | |
| 406 | + | * @property int|null $created_by | |
| 407 | + | * @property int|null $updated_by | |
| 408 | + | */ | |
| 409 | + | ||
| 410 | + | /** | |
| 411 | + | * This is the model class for table "{{%periodic_inspection_setting}}". | |
| 412 | + | * | |
| 413 | + | * @property int $id | |
| 414 | + | * @property int $building_type_id | |
| 415 | + | * @property int $equipment_type_id | |
| 416 | + | * @property int $periodic_inspection Periodic Inspection Time in years | |
| 417 | + | * @property int|null $status | |
| 418 | + | * @property int|null $record_status | |
| 419 | + | * @property int|null $position | |
| 420 | + | * @property string|null $language | |
| 421 | + | * @property int|null $created_at | |
| 422 | + | * @property int|null $updated_at | |
| 423 | + | * @property int|null $created_by | |
| 424 | + | * @property int|null $updated_by | |
| 425 | + | * | |
| 426 | + | * @property BuildingType $buildingType | |
| 427 | + | * @property EquipmentType $equipmentType | |
| 428 | + | */ | |
| 429 | + | ||
| 430 | + | /** | |
| 431 | + | * Visit model — maps to the `visit` table. | |
| 432 | + | * Records inspection visits to equipment (1:1 per visit). | |
| 433 | + | * | |
| 434 | + | * @property int $id | |
| 435 | + | * @property string $guid | |
| 436 | + | * @property int $equipment_id | |
| 437 | + | * @property int|null $inspector_entity_id | |
| 438 | + | * @property int|null $inspector_id | |
| 439 | + | * @property string $visit_status | |
| 440 | + | * @property string $result | |
| 441 | + | * @property string|null $scheduled_at | |
| 442 | + | * @property string|null $inspected_at | |
| 443 | + | * @property string|null $next_inspection_at | |
| 444 | + | * @property string|null $notes | |
| 445 | + | * @property int $status | |
| 446 | + | * @property int $record_status | |
| 447 | + | * @property int $created_at | |
| 448 | + | * @property int $updated_at | |
| 449 | + | * @property int $created_by | |
| 450 | + | * @property int $updated_by | |
| 451 | + | * | |
| 452 | + | * @property Equipment $equipment | |
| 453 | + | * @property InspectorEntity|null $inspectorEntity | |
| 454 | + | * @property Inspector|null $inspector | |
| 455 | + | * | |
| 456 | + | * @mixin TimelineBehaviour | |
| 457 | + | */ | |
| 458 | + | ||
| 459 | + | /** | |
| 460 | + | * User ActiveRecord model. | |
| 461 | + | * | |
| 462 | + | * @property bool $isAdmin | |
| 463 | + | * @property bool $isBlocked | |
| 464 | + | * @property bool $isConfirmed whether user account has been confirmed or not | |
| 465 | + | * @property bool $gdpr_deleted whether user requested deletion of his account | |
| 466 | + | * @property bool $gdpr_consent whether user has consent personal data processing | |
| 467 | + | * | |
| 468 | + | * Database fields: | |
| 469 | + | * @property int $id | |
| 470 | + | * @property string $username | |
| 471 | + | * @property string $email | |
| 472 | + | * @property ?string $unconfirmed_email | |
| 473 | + | * @property string $password_hash | |
| 474 | + | * @property string $auth_key | |
| 475 | + | * @property ?string $auth_tf_key | |
| 476 | + | * @property int $auth_tf_enabled | |
| 477 | + | * @property ?string $auth_tf_type | |
| 478 | + | * @property ?string $auth_tf_mobile_phone | |
| 479 | + | * @property ?string $registration_ip | |
| 480 | + | * @property ?int $confirmed_at | |
| 481 | + | * @property ?int $blocked_at | |
| 482 | + | * @property int $flags | |
| 483 | + | * @property int $created_at | |
| 484 | + | * @property int $updated_at | |
| 485 | + | * @property ?int $last_login_at | |
| 486 | + | * @property ?int $gdpr_consent_date date of agreement of data processing | |
| 487 | + | * @property ?string $last_login_ip | |
| 488 | + | * @property ?int $password_changed_at | |
| 489 | + | * @property int $password_age | |
| 490 | + | * Defined relations: | |
| 491 | + | * @property SocialNetworkAccount[] $socialNetworkAccounts | |
| 492 | + | * @property ?Profile $profile | |
| 493 | + | */ | |
| 494 | + | ||
| 495 | + | /** | |
| 496 | + | * This is the model class for table "{{%profile}}". | |
| 497 | + | * | |
| 498 | + | * @property int $user_id | |
| 499 | + | * @property string|null $name | |
| 500 | + | * @property string|null $public_email | |
| 501 | + | * @property string|null $gravatar_email | |
| 502 | + | * @property string|null $gravatar_id | |
| 503 | + | * @property string|null $location | |
| 504 | + | * @property string|null $website | |
| 505 | + | * @property string|null $timezone | |
| 506 | + | * @property string|null $bio | |
| 507 | + | * @property string $guid GUID | |
| 508 | + | * @property string|null $slug | |
| 509 | + | * @property string|null $preferred_name | |
| 510 | + | * @property string|null $initials | |
| 511 | + | * @property string|null $job_title | |
| 512 | + | * @property string|null $date_of_birth | |
| 513 | + | * @property string|null $title | |
| 514 | + | * @property int|null $date_of_birth_is_public | |
| 515 | + | * @property int|null $created_at | |
| 516 | + | * @property int|null $created_by | |
| 517 | + | * @property int|null $updated_at | |
| 518 | + | * @property int|null $updated_by | |
| 519 | + | * | |
| 520 | + | * @property User $user | |
| 521 | + | */ | |
Daha yeni
Daha eski