address table - SuperOffice

address Table (7)

Contact and Person addresses

Fields

Name	Description	Type	Nullable
address_id	Primary key	PK	No
owner_id	Record id of owner: Contact or Person	Id	No
atype_idx	Bit mask, combines address type (EAddressType) and owner type (EOwnerType)	Enum AddressType	No
zipcode	Zip code, alphanumeric	String(11)	No
city	City corresponding to zip code	String(79)	Yes
state	State	String(5)	Yes
county	County (not country)	String(29)	Yes
address1	Address line 1	String(79)	Yes
address2	Address line 2	String(79)	Yes
address3	Address line 3	String(79)	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
validFrom	Valid from date for this record	DateTime	Yes
validTo	Valid to date for this record	DateTime	Yes
wgs84latitude	Latitude (that’s north/south), decimal degrees, relative to WGS 84 ellipsoid. SuperOffice ASA is at 59.91892. This value needs no further grid reference or other qualifying information.	Double	Yes
wgs84longitude	Longitude (that’s East/west), decimal degrees, relative to WGS 84 ellipsoid. SuperOffice ASA is at 10.73159. This value needs no further grid reference or other qualifying information.	Double	Yes

address table relationship diagram

Indexes

Fields	Types	Description
zipcode	String(11)	Index
state	String(5)	Index
owner_id, atype_idx	Id, Enum	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
contact	Companies and Organizations.
person	Persons

Replication Flags

Area Management controlled table. Contents replicated to satellites and traveller databases.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

Sentry controls access to items in this table using user’s Role and data rights matrix on the table’s parent.

Related topics

AddressFormat table Find Address Get Address Contact table Person table

⌘I