41 Foreign Key Constraints:

Constraint Name	Child Column	Parent Column	Delete Rule
FK_annotations_itemAttachments_itemID	annotations.itemID	itemAttachments.itemID	Restrict delete
FK_baseFieldMappings_fields_fieldID	baseFieldMappings.fieldID baseFieldMappings.baseFieldID	fields.fieldID fields.fieldID	Restrict delete
FK_baseFieldMappings_itemTypes_itemTypeID	baseFieldMappings.itemTypeID	itemTypes.itemTypeID	Restrict delete
FK_collectionItems_collections_collectionID	collectionItems.collectionID	collections.collectionID	Restrict delete
FK_collectionItems_items_itemID	collectionItems.itemID	items.itemID	Restrict delete
FK_collections_collections_collectionID	collections.parentCollectionID	collections.collectionID	Restrict delete
FK_creators_creatorData_creatorDataID	creators.creatorDataID	creatorData.creatorDataID	Restrict delete
FK_customBaseFieldMappings_customItemTypes_customItemTypeID	customBaseFieldMappings.customItemTypeID	customItemTypes.customItemTypeID	Restrict delete
FK_customBaseFieldMappings_fields_customFieldID	customBaseFieldMappings.customFieldID		Restrict delete
FK_customBaseFieldMappings_fields_fieldID	customBaseFieldMappings.baseFieldID	fields.fieldID	Restrict delete
FK_customItemTypeFields_customFields_customFieldID	customItemTypeFields.customFieldID	customFields.customFieldID	Restrict delete
FK_customItemTypeFields_customItemTypes_customItemTypeID	customItemTypeFields.customItemTypeID	customItemTypes.customItemTypeID	Restrict delete
FK_customItemTypeFields_fields_fieldID	customItemTypeFields.fieldID	fields.fieldID	Restrict delete
FK_fields_fieldFormats_fieldFormatID	fields.fieldFormatID	fieldFormats.fieldFormatID	Restrict delete
FK_fileTypeMimeTypes_fileTypes_fileTypeID	fileTypeMimeTypes.fileTypeID	fileTypes.fileTypeID	Restrict delete
FK_fulltextItems_items_itemID	fulltextItems.itemID	items.itemID	Restrict delete
FK_fulltextItemWords_fulltextWords_wordID	fulltextItemWords.wordID	fulltextWords.wordID	Restrict delete
FK_fulltextItemWords_items_itemID	fulltextItemWords.itemID	items.itemID	Restrict delete
FK_groupItems_users_userID	groupItems.lastModifiedByUserID groupItems.createdByUserID	users.userID users.userID	Restrict delete
FK_groups_libraries_libraryID	groups.libraryID	libraries.libraryID	Restrict delete
FK_highlights_itemAttachments_itemID	highlights.itemID	itemAttachments.itemID	Restrict delete
FK_itemAttachments_items_itemID	itemAttachments.sourceItemID itemAttachments.itemID	items.itemID items.itemID	Restrict delete
FK_itemCreators_creators_creatorID	itemCreators.creatorID	creators.creatorID	Restrict delete
FK_itemCreators_creatorTypes_creatorTypeID	itemCreators.creatorTypeID	creatorTypes.creatorTypeID	Restrict delete
FK_itemCreators_items_itemID	itemCreators.itemID	items.itemID	Restrict delete
FK_itemData_fields_fieldID	itemData.fieldID	fields.fieldID	Restrict delete
FK_itemData_itemDataValues_valueID	itemData.valueID	itemDataValues.valueID	Restrict delete
FK_itemData_items_itemID	itemData.itemID	items.itemID	Restrict delete
FK_itemNotes_items_itemID	itemNotes.sourceItemID itemNotes.itemID	items.itemID items.itemID	Restrict delete
FK_items_libraries_libraryID	items.libraryID	libraries.libraryID	Restrict delete
FK_itemSeeAlso_items_itemID	itemSeeAlso.linkedItemID itemSeeAlso.itemID	items.itemID items.itemID	Restrict delete
FK_itemTags_items_itemID	itemTags.itemID	items.itemID	Restrict delete
FK_itemTags_tags_tagID	itemTags.tagID	tags.tagID	Restrict delete
FK_itemTypeCreatorTypes_creatorTypes_creatorTypeID	itemTypeCreatorTypes.creatorTypeID	creatorTypes.creatorTypeID	Restrict delete
FK_itemTypeCreatorTypes_itemTypes_itemTypeID	itemTypeCreatorTypes.itemTypeID	itemTypes.itemTypeID	Restrict delete
FK_itemTypeFields_fields_fieldID	itemTypeFields.fieldID	fields.fieldID	Restrict delete
FK_itemTypeFields_itemTypes_itemTypeID	itemTypeFields.itemTypeID	itemTypes.itemTypeID	Restrict delete
FK_proxyHosts_proxies_proxyID	proxyHosts.proxyID	proxies.proxyID	Restrict delete
FK_savedSearchConditions_savedSearches_savedSearchID	savedSearchConditions.savedSearchID	savedSearches.savedSearchID	Restrict delete
FK_syncDeleteLog_syncObjectTypes_syncObjectTypeID	syncDeleteLog.syncObjectTypeID	syncObjectTypes.syncObjectTypeID	Restrict delete
FK_transactionLog_transactions_transactionID	transactionLog.transactionID	transactions.transactionID	Restrict delete

Check Constraints:

Table	Constraint Name	Constraint
None detected