URL table - SuperOffice

URL Table (54)

Unified Resource Locators, URL to contacts, persons or projects.

Fields

Name	Description	Type	Nullable
url_id	Primary key	PK	No
contact_id	Relations to possible owners	FK contact	Yes
person_id	Relations to possible owners	FK person	Yes
project_id	Relations to possible owners	FK project	Yes
reserved_id1	Reserved for potential future owners	Id	Yes
reserved_id2	Reserved for potential future owners	Id	Yes
type	Fixed, predefined list of types	UShort	No
description	Visible field	String(254)	No
url_address	URL address	String(1023)	No
rank	Rank order in lists	UShort	No
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

URL table relationship diagram

Indexes

Fields	Types	Description
contact_id	FK	Index
person_id	FK	Index
project_id	FK	Index
reserved_id1	Id	Index
reserved_id2	Id	Index
url_address	String(1023)	Index
rank	UShort	Index

Relationships

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

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

extra_menus table Webhook table config table NSPluginUrlResponse document table TaskMenu table

⌘I