BDNA Data Platform 5.4 July 2017 (SQL Server)
CAT_HW_LIC_CHARACTERISTICS - A table containing all relevant characteristic of the hardware model that is specified in the hardware license

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CAT_HW_LIC_CHARACTERISTICS_ID numeric 20  √  null CAT_HW_LIC_CHARACTERISTICS table's unique identifier
CREATE_DATE datetime 16,3  √  null The date when row was first created
LAST_MODIFIED_DATE datetime 16,3  √  null The date the Technopedia Version's entry was last modified
MEMORY_MAX numeric 40,2  √  null Maximum amount of memory supported by the device as mentioned in the hardware license
MEMORY_MAX_UNIT varchar 10  √  null The unit of maximum memory value in the MEMORY_MAX column
MEMORY_SPECIFICATION varchar 200  √  null The specification of memory that comes with the device as mentioned in the hardware license
MEMORY_TECHNOLOGY varchar 200  √  null The technology of memory that comes with the device as mentioned in the hardware license
MEMORY_SPEED numeric 40,2  √  null The speed of memory (in MHz) that comes with the device as mentioned in the hardware license
MEMORY_STORAGE_CAPACITY numeric 40,2  √  null Storage capacity that comes with the device as mentioned in the hardware license
MEMORY_STORAGE_UNIT varchar 10  √  null The unit of storage capacity value in the MEMORY_STORAGE_CAPACITY column
HARDDRIVE_INTERFACE varchar 200  √  null The hard drive interface supported by the device as mentioned in the hadware license
NETWORK_TYPE varchar 200  √  null The network type(s) available on the device as mentioned in the hadware license
DATA_LINK_PROTOCOL varchar 200  √  null The data link protocol(s) supported by the device as mentioned in the hadware license
OPTICAL_DRIVE varchar 200  √  null The optical drive(s) installed in the device as mentioned in the hadware license
GRAPHICS_CARD varchar 200  √  null The graphics card(s) installed in the device as mentioned in the hadware license
INTERFACE_PORTS varchar 200  √  null The interface ports available on the device as mentioned in the hardware license
MONITOR_RESOLUTION_LENGTH numeric 40,2  √  null The length of the monitor (in inch) included in the device, if applicable, as mentioned in the hardware license
MONITOR_RESOLUTION_WIDTH numeric 40,2  √  null The width of the monitor (in inch) included in the device, if applicable, as mentioned in the hardware license
PROCESSOR_TYPE varchar 200  √  null The type of processor(s) installed in the device as mentioned in the hardware license
PROCESSOR_SPEED numeric 40,2  √  null The clock speed (in GHz) of processor(s) installed in the device as mentioned in the hardware license
PROCESSOR_INSTALLED_QTY numeric 40  √  null Quantity of processors installed in the device as mentioned in the hardware license
PROCESSOR_MAX_SUPPORTED numeric 40  √  null Maximum quantity of processors supported by the device as mentioned in the hardware license
INSTALLED_RAM numeric 40,2  √  null The value of RAM installed in the device as mentioned in the hardware license
INSTALLED_RAM_UNIT varchar 10  √  null The unit of RAM value as indicated in INSTALLED_RAM column
TO_BE_DELETED varchar 1  √  null Would this record be deleted? eg: Y
TO_BE_DELETED_ON datetime 16,3  √  null The date when this record would be deleted
DELETE_REASON varchar 500  √  null The reason why the entry is marked to be deleted (Values: Duplicate,Inaccurate)
PRIVATE_FLAG numeric 3  √  null 0 = Not Modified (i.e. original Technopedia entry),1 = Modified Technopedia object, 2 = Proprietary object (those that have negative ids)
IS_PRIVATE varchar 1  √  null y = a private entry, n = original Technopedia entry
PRIVATE_TYPE varchar 500  √  null PRIVATE_TYPE = NULL if PRIVATE_FLAG = 0,PRIVATE_TYPE = Modified Technopedia entry if PRIVATE_FLAG = 1,PRIVATE_TYPE = Proprietary entry if PRIVATE_FLAG = 2
REPLACEMENT_ID numeric 20  √  null Unique identifier of the replacement entry whenever the entry is marked to be deleted for 'Duplicate' reason

Analyzed at Thu Jul 20 12:14 PDT 2017

View Definition:
CREATE VIEW CAT_HW_LIC_CHARACTERISTICS AS SELECT f_tcat.CAT_HW_LIC_CHARACTERISTICS_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.MEMORY_MAX,f_tcat.MEMORY_MAX_UNIT,f_tcat.MEMORY_SPECIFICATION,f_tcat.MEMORY_TECHNOLOGY,f_tcat.MEMORY_SPEED,f_tcat.MEMORY_STORAGE_CAPACITY,f_tcat.MEMORY_STORAGE_UNIT,f_tcat.HARDDRIVE_INTERFACE,f_tcat.NETWORK_TYPE,f_tcat.DATA_LINK_PROTOCOL,f_tcat.OPTICAL_DRIVE,f_tcat.GRAPHICS_CARD,f_tcat.INTERFACE_PORTS,f_tcat.MONITOR_RESOLUTION_LENGTH,f_tcat.MONITOR_RESOLUTION_WIDTH,f_tcat.PROCESSOR_TYPE,f_tcat.PROCESSOR_SPEED,f_tcat.PROCESSOR_INSTALLED_QTY,f_tcat.PROCESSOR_MAX_SUPPORTED,f_tcat.INSTALLED_RAM,f_tcat.INSTALLED_RAM_UNIT,f_tcat.TO_BE_DELETED,f_tcat.TO_BE_DELETED_ON,f_tcat.DELETE_REASON,f_tcat.PRIVATE_FLAG,f_tcat.IS_PRIVATE,f_tcat.PRIVATE_TYPE,f_tcat.REPLACEMENT_ID from TCAT_HW_LIC_CHARACTERISTICS f_tcat where not exists (select 1 from TPC_HW_LIC_CHARACTERISTICS tpc_tab where tpc_tab.CAT_HW_LIC_CHARACTERISTICS_ID=f_tcat.CAT_HW_LIC_CHARACTERISTICS_ID ) union all SELECT * FROM ( SELECT COALESCE(tpc.CAT_HW_LIC_CHARACTERISTICS_ID,tcat.CAT_HW_LIC_CHARACTERISTICS_ID) CAT_HW_LIC_CHARACTERISTICS_ID,COALESCE(tpc.CREATE_DATE,tcat.CREATE_DATE) CREATE_DATE,CASE WHEN ISNULL(tpc.LAST_MODIFIED_DATE,'31-DEC-1900') > tcat.LAST_MODIFIED_DATE THEN tpc.LAST_MODIFIED_DATE WHEN ISNULL(tpc.LAST_MODIFIED_DATE,'31-DEC-1900') < tcat.LAST_MODIFIED_DATE THEN tcat.LAST_MODIFIED_DATE ELSE tcat.LAST_MODIFIED_DATE END LAST_MODIFIED_DATE, COALESCE(tpc.MEMORY_MAX,tcat.MEMORY_MAX) MEMORY_MAX,COALESCE(tpc.MEMORY_MAX_UNIT,tcat.MEMORY_MAX_UNIT) MEMORY_MAX_UNIT,COALESCE(tpc.MEMORY_SPECIFICATION,tcat.MEMORY_SPECIFICATION) MEMORY_SPECIFICATION,COALESCE(tpc.MEMORY_TECHNOLOGY,tcat.MEMORY_TECHNOLOGY) MEMORY_TECHNOLOGY,COALESCE(tpc.MEMORY_SPEED,tcat.MEMORY_SPEED) MEMORY_SPEED,COALESCE(tpc.MEMORY_STORAGE_CAPACITY,tcat.MEMORY_STORAGE_CAPACITY) MEMORY_STORAGE_CAPACITY,COALESCE(tpc.MEMORY_STORAGE_UNIT,tcat.MEMORY_STORAGE_UNIT) MEMORY_STORAGE_UNIT,COALESCE(tpc.HARDDRIVE_INTERFACE,tcat.HARDDRIVE_INTERFACE) HARDDRIVE_INTERFACE,COALESCE(tpc.NETWORK_TYPE,tcat.NETWORK_TYPE) NETWORK_TYPE,COALESCE(tpc.DATA_LINK_PROTOCOL,tcat.DATA_LINK_PROTOCOL) DATA_LINK_PROTOCOL,COALESCE(tpc.OPTICAL_DRIVE,tcat.OPTICAL_DRIVE) OPTICAL_DRIVE,COALESCE(tpc.GRAPHICS_CARD,tcat.GRAPHICS_CARD) GRAPHICS_CARD,COALESCE(tpc.INTERFACE_PORTS,tcat.INTERFACE_PORTS) INTERFACE_PORTS,COALESCE(tpc.MONITOR_RESOLUTION_LENGTH,tcat.MONITOR_RESOLUTION_LENGTH) MONITOR_RESOLUTION_LENGTH,COALESCE(tpc.MONITOR_RESOLUTION_WIDTH,tcat.MONITOR_RESOLUTION_WIDTH) MONITOR_RESOLUTION_WIDTH,COALESCE(tpc.PROCESSOR_TYPE,tcat.PROCESSOR_TYPE) PROCESSOR_TYPE,COALESCE(tpc.PROCESSOR_SPEED,tcat.PROCESSOR_SPEED) PROCESSOR_SPEED,COALESCE(tpc.PROCESSOR_INSTALLED_QTY,tcat.PROCESSOR_INSTALLED_QTY) PROCESSOR_INSTALLED_QTY,COALESCE(tpc.PROCESSOR_MAX_SUPPORTED,tcat.PROCESSOR_MAX_SUPPORTED) PROCESSOR_MAX_SUPPORTED,COALESCE(tpc.INSTALLED_RAM,tcat.INSTALLED_RAM) INSTALLED_RAM,COALESCE(tpc.INSTALLED_RAM_UNIT,tcat.INSTALLED_RAM_UNIT) INSTALLED_RAM_UNIT,COALESCE(tpc.TO_BE_DELETED,tcat.TO_BE_DELETED) TO_BE_DELETED,COALESCE(tpc.TO_BE_DELETED_ON,tcat.TO_BE_DELETED_ON) TO_BE_DELETED_ON,COALESCE(tpc.DELETE_REASON,tcat.DELETE_REASON) DELETE_REASON,COALESCE(uuid.PRIVATE_FLAG,tcat.PRIVATE_FLAG) PRIVATE_FLAG, COALESCE(uuid.IS_PRIVATE,tcat.IS_PRIVATE) IS_PRIVATE, COALESCE(uuid.PRIVATE_TYPE,tcat.PRIVATE_TYPE) PRIVATE_TYPE, COALESCE(tpc.REPLACEMENT_ID,tcat.REPLACEMENT_ID) REPLACEMENT_ID FROM TPC_HW_LIC_CHARACTERISTICS tpc LEFT JOIN TCAT_HW_LIC_CHARACTERISTICS tcat ON tcat.CAT_HW_LIC_CHARACTERISTICS_ID = tpc.CAT_HW_LIC_CHARACTERISTICS_ID INNER JOIN TPC_UUID uuid ON tpc.CAT_HW_LIC_CHARACTERISTICS_ID = uuid.CAT_UUID_ID AND SIGN(tpc.CAT_HW_LIC_CHARACTERISTICS_ID )!= -1 ) cat_tab UNION ALL SELECT tpc.CAT_HW_LIC_CHARACTERISTICS_ID,tpc.CREATE_DATE,tpc.LAST_MODIFIED_DATE,tpc.MEMORY_MAX,tpc.MEMORY_MAX_UNIT,tpc.MEMORY_SPECIFICATION,tpc.MEMORY_TECHNOLOGY,tpc.MEMORY_SPEED,tpc.MEMORY_STORAGE_CAPACITY,tpc.MEMORY_STOR
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA