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