Back to Openemr

addresses

Documentation/EHI_Export/docs/tables/addresses.html

latest1.0 KB
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idINT100

| contact_address.address_id | Defined in XML | R |

|

| | | line1 | VARCHAR | 255 | √ | | NULL |

|

| | | line2 | VARCHAR | 255 | √ | | NULL |

|

| | | city | VARCHAR | 255 | √ | | NULL |

|

| | | state | VARCHAR | 35 | √ | | NULL |

|

| | | zip | VARCHAR | 10 | √ | | NULL |

|

| | | plus_four | VARCHAR | 4 | √ | | NULL |

|

| | | country | VARCHAR | 255 | √ | | NULL |

|

| | | foreign_id | INT | 10 | √ | | NULL |

|

| | | district | VARCHAR | 255 | √ | | NULL |

|

|

The county or district of the address

|

Indexes

Constraint NameTypeSortColumn(s)
PRIMARYPrimary keyAscid
foreign_idPerformanceAscforeign_id

Relationships

Close relationships within degrees of separation