Table IWA_LibrarySpecification

Library Sepcifications

Columns

Primary Key	Name	Type	Length	Precision	Can Be Null	Default	References	Action	Hints	Comment
true	LibrarySpecificationId	BIGINT			false					Identifies the the library specification.
false	LibraryId	BIGINT			false		IWA_Library(LibraryId)	ON DELETE CASCADE		References the library this library specification belongs to.
false	Id	VARCHAR	200		false					The identifier of the required library that this library requires
false	ResolvedLibraryId	BIGINT			true		IWA_Library(LibraryId)	ON DELETE SET NULL	MsSqlServer , MySql	The resolved runtime library which matches the specification
false	Position	INTEGER			false					The position of this library specification within all other library specification of a library.

Constraints

Constraint	Name	Columns	Hints	Comment
UNIQUE	LibrarySpecification_LibraryIdIdIndex	LibraryId , Id

Indexes

Name	Columns	Hints	Comment
IWA_LibrarySpecification_LibraryIdIndex	LibraryId
LibrarySpecification_ResolvedLibraryId	ResolvedLibraryId	Oracle

Referenced By

Foreign Table	Column	Comment
IWA_LibraryVersionSpec	LibrarySpecificationId	References the library specification this library version specification belongs to.

Cache

Object	Strategy
IWA_LibrarySpecification	ALL

MySql

Object	NoReferenceUseTrigger
ResolvedLibraryId	true

MsSqlServer

Object	NoReferenceUseTrigger
ResolvedLibraryId	true

Oracle

Object	IndexName
LibrarySpecification_ResolvedLibraryId	LibSpec_ResLibraryId