WHD Old ticket removal and Orion Integration

Dear All

Our WHD Database size is increased more than 200 GB, and we need to delete old ticket.

1. Is there any option for retention on tickets? If we delete ticket from GUI, it marks as deleted in job_ticket table, but records are not deleted from DB.

2. Can we delete old tickets from DB directly? 

3. Can I have DB tables detailed information?

4. Which port is used by WHD and Orion to communicate for Alert - Ticket genration?

Thanks and regard

Balvant