m_address

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
street varchar 100 √ null
address_line_1 varchar 100 √ null
address_line_2 varchar 100 √ null
address_line_3 varchar 100 √ null
town_village varchar 100 √ null
city varchar 100 √ null
county_district varchar 100 √ null
state_province_id int4 10 √ null
m_code_value.id address_fields_codefk1 R
country_id int4 10 √ null
m_code_value.id address_fields_codefk2 R
postal_code varchar 10 √ null
latitude numeric 10,8 √ 0.00000000
longitude numeric 10,8 √ 0.00000000
created_by varchar 100 √ null
created_on date 13 √ null
updated_by varchar 100 √ null
updated_on date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
m_address_pkey Primary key Asc id
address_fields_codefk1 Performance Asc state_province_id
address_fields_codefk2 Performance Asc country_id

Relationships

Close relationships within degrees of separation