Appearance
dbo.primeAttachmentType
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeAttachmentType.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | id | uniqueidentifier | no | Primary key / unique identifier for this record | |
| 2 | type | nvarchar(50) | no | Category/type classification of this record | |
| 3 | label | nvarchar(255) | no | Display label | |
| 4 | version | bigint | no | Optimistic-concurrency row version number |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK__primeAtt__3213E83FCE1179E4 | CLUSTERED | yes | yes | id | ||
| IX_primeAttachmentType_label_id | NONCLUSTERED | label | id |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.primeAttachment.attachmentTypeId | dbo.primeAttachmentType.id | high |
Referenced by
Procedures: dbo.spPrimeGetAttachmentInformation, dbo.spPrimeGetJobAttachments, dbo.spPrimeUpsertAttachmentType