You can setup an Automated Action that is triggered when the status on sale.order changes from draft or sent (Quotation) to confirmed (Sales Order) and which creates a record in another Model (database table)

You need to be in ‘developer’ mode and navigate to Settings / Technical / (Automation) / Automated Actions and click ‘Create’. 

In the "Data to Write" tab, you need to specify the fields (which can come from the Sales Order) 

The above example will always create a task in the same project, but you can do something different.  The task name is the sales order number. You can add more fields (e.g. customer).

Here's one example of creating a record in another Model (database table): Use Automated actions to create reordering rules