Hi Sonika,
If you want to see the opens/clicks for a particular delivery, you can directly go to the delivery reports and export the report.
But as you asked about the schemas, explained below:
nms:trackingLogRcp - Can track the opens and clicks, links (foreign keys) are available for Recipient and Delivery.
nms:delivery: Delivery details with campaign link (schema name - nms:operation) link to get the campaign details.
nms:recipient: These is a field 'No longer contact by Email', you can check if users marked themselves unsubscribed from email channel or not.
Thanks,
Rahul