Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ComponentDescription | Unknown | 0 | null |
|
|
Component description - Description of the package component |
|||||
| ComponentName | Unknown | 0 | null |
|
|
Component name - Name of the package component |
|||||
| DetailId | Unknown | 0 | null |
|
|
Primary key - PackageDetail unique identifier for each package detail |
|||||
| PDetailID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| fkPackID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to Pack table for data relationships |
||||
| fkSecProcCodeID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to SecProcCode table for data relationships |
||||
| DisplayOrder | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for PackageDetail records |
||||
| IsIncluded | Unknown | 0 | null |
|
|
Included flag - Whether this component is included in the package |
|||||
| PackageName | Unknown | 0 | null |
|
|
Package name - Name of the service package |
|||||
| Quantity | Unknown | 0 | null |
|
|
Quantity - Quantity of the component included |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__PackageDetail__6C98FCFF | Primary key | Asc | PDetailID |