satellite table - SuperOffice

satellite Table (42)

Definition of Satellites

Fields

Name	Description	Type	Nullable
satellite_id	Primary key	PK	No
area_id	Area this satellite is based on (mandatory != 0)	FK area	No
contact_id	Contact card that owns this satellite	FK contact	No
encryptedComm	Use encryption for this Satellite?	UShort	Yes
DSN	Data source name last used for this satellite	String(254)	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

satellite table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
area	Definition of an Area (database subset for satellite and travel)
associate	Employees, resources and other users - except for External persons
contact	Companies and Organizations.
LicenseSatlLink	Link between License and Satellite, for per-database licenses

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Copy to satellite and travel prototypes.

Security Flags

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

Related topics

satellites Satellite Get Satellite Licenses sale table project table

⌘I