Project Data Tables Database > td Schema : td.LIBRARY_PARTS_DEFS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
LIBPRT_ID | The record ID. | int | 4 | ||||
LIBPRT_LIB_ID | The LIBRARIES.LIB_ID of the library that contains this part. | int | 4 | ||||
LIBPRT_NAME | The name of the library part. | varchar | 255 | ||||
LIBPRT_VER_STAMP | The version number of this record. | int | 4 | ||||
LIBPRT_DESCRIPTION | A free text description of this item. | varchar | 16 | ||||
LIBPRT_ROOT_ENTITY | The type of this entity. If a TEST folder, this value is ALL_LISTS. | varchar | 30 | ||||
LIBPRT_ROOT_KEY | The ID of this entity. | varchar | 40 | ||||
LIBPRT_ROOT_FILTER | For future use. | varchar | 16 | ||||
LIBPRT_ASSIGNED_ROOT_KEY | The ID of the containing entity in the exported library. | varchar | 40 |
Index | Description | Primary | Unique |
---|---|---|---|
LIBPRT_PRIMARYKEY | |||
LIBPRT_ROOT_IDX | |||
LIBPRT_UNIQUE_NAME_IDX |