Model Address
namespace HubletoApp\Customers\Models\Address
List of addresses belonging to a Person.
Constants
This model does not define constants.
Properties
| Property | Value |
|---|---|
| eloquentClass | Eloquent\Address::class |
| table | addresses |
| lookupSqlValue | concat([TABLE].street_line_1, ', ', [TABLE].street_line_2, ', ', [TABLE].city) |
Data Scructure
| Column | Title | ADIOS Type | Length | Required |
|---|---|---|---|---|
| id | ID | int | TRUE | |
| street_line_1 | Street Line 1 | varchar | TRUE | |
| street_line_2 | Street Line 2 | varchar | FALSE | |
| postal_code | Postal code | varchar | TRUE | |
| region | Region | varchar | TRUE | |
| city | City | varchar | TRUE | |
| id_person | Person | lookup | TRUE | |
| id_country | Country | lookup | TRUE |
Foreign Keys
| Column | Model | Relation | OnUpdate | OnDelete |
|---|---|---|---|---|
| id_person | Modules\Core\Customers\Models\Person | 1:1 | Cascade | Restrict |
| id_country | Modules\Core\Settings\Models\Country | 1:1 | Cascade | Restrict |
Indexes
Only default indexes are used.
Relations
| Relation | Type | Other parameters |
|---|---|---|
| PERSON | BELONGS_TO | Person::class, 'id_person', 'id' |
| COUNTRY | BELONGS_TO | Country::class, 'id', 'id_country' |