Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this path is currently valid |
||
| Path | text | 2147483647 | √ | null |
|
|
File reference - File path or filename for PathLookUp document management |
|
| PathId | Unknown | 0 | null |
|
|
Primary key - PathLookUp unique identifier for each path entry |
||
| PathName | Unknown | 0 | null |
|
|
Path name - Descriptive name for the path |
||
| pkPathLookUpID | int identity | 4 | √ | null |
|
|
Primary key - PathLookUp unique identifier for each record |
|
| PathType | varchar | 50 | √ | null |
|
|
Path type - Type of path (File, Directory, URL, etc.) |
|
| PathValue | Unknown | 0 | null |
|
|
Path value - Actual file path or directory location |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PathLookUp | Primary key | Asc | pkPathLookUpID |