Skip to main content

Address Type

Data Dictionary : Entity Table Address_Type#

This is a lookup table for the Address_type column in the table Address. This table allows us to distinguish different address types (assigned to one person or organization) that can be used for different purposes, e.g. business, home address, mailing address, secondary, address for tax purposes etc.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
IdBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
NameVARCHAR(45)Nullbusiness, homeName of Address Type