Project Data Tables Database > td Schema : td.SMART_REPOSITORY_LOGICAL_FILE Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
SRLF_ID | The record ID. | int | 4 | ||||
SRLF_PARENT_PATH | The logical path to the file. The directory separator is a backslash (\). | varchar | 255 | ||||
SRLF_NAME | The file name. | varchar | 255 | ||||
SRLF_PHYSICAL_ID | The SMART_REPOSITORY_PHYSICAL_FILE.SRPF_ID | int | 4 | ||||
SRLF_IS_DIRECTORY | Y- Item is directory. N- Item is file. | varchar | 1 | ||||
SRLF_LAST_MODIFIED | Time of last file modification. | datetime | 4 | ||||
SRLF_SIZE | File size. | int | 4 |
Index | Description | Primary | Unique |
---|---|---|---|
SRLF_LOGICAL_PATH_IDX | |||
SRLF_PHYSICAL_ID_IDX | |||
SRLF_PK |
Relationship | Description |
---|---|
SRLF_SRPF_ID_FK |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
td.SMART_REPOSITORY_PHYSICAL_FILE | Table | For internal use by HP. Do not change data in this table. | 1 |