Skip to content

Latest commit

 

History

History
53 lines (40 loc) · 1.42 KB

projtypegrouplink.md

File metadata and controls

53 lines (40 loc) · 1.42 KB
uid title description so.generated keywords so.date so.topic so.envir
table-ProjTypeGroupLink
ProjTypeGroupLink table
User group link table for ProjType, for MDO item hiding
true
database
ProjTypeGroupLink
11.04.2021
reference
onsite
online

ProjTypeGroupLink Table (86)

Fields

Name Description Type Null
projtypegrouplink_id Primary key PK
projtype_id Link to ProjType list table FK ProjType
group_id Link to Group table FK UserGroup
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

ProjTypeGroupLink table relationship diagram

[!includedetails]

Indexes

Fields Types Description
projtypegrouplink_id PK Clustered, Unique
projtype_id FK Index
group_id FK Index

Replication Flags

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

Security Flags

  • No access control via user's Role.