Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('addresses_id_seq'::regclass) |
|
|
|||||
| member_id | int4 | 10 | null |
|
|
||||||
| line1 | text | 2147483647 | √ | null |
|
|
|||||
| line2 | text | 2147483647 | √ | null |
|
|
|||||
| town | text | 2147483647 | √ | null |
|
|
|||||
| postcode | text | 2147483647 | √ | null |
|
|
|||||
| country | text | 2147483647 | √ | null |
|
|
|||||
| created_at | timestamp | 29,6 | √ | null |
|
|
|||||
| updated_at | timestamp | 29,6 | √ | null |
|
|
|||||
| canonical_address_id | int4 | 10 | √ | null |
|
|
|||||
| state | varchar | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| addresses_pkey | Primary key | Asc | id |
| addresses_member_id_updated_at_idx | Performance | Asc/Asc | member_id + updated_at |
| addresses_updated_at | Performance | Asc | updated_at |
| index_address_ua | Performance | Asc | updated_at |
| index_addresses_on_canonical_address_id | Performance | Asc | canonical_address_id |
| index_addresses_on_member_id | Performance | Asc | member_id |
Relationships
Close relationships within degrees of separation
