# DataBase model decided by Ignition

**URL:** <https://forum.inductiveautomation.com/t/database-model-decided-by-ignition/4592>\
**Category:** Ignition\
**Created:** [June 7, 2012, 4:12pm UTC](https://forum.inductiveautomation.com/t/database-model-decided-by-ignition/4592 "2012-06-07T16:12:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aortiz](https://avatars.discourse-cdn.com/v4/letter/a/67e7ee/32.png) [@aortiz](https://forum.inductiveautomation.com/u/aortiz)\
**Post date:** [June 7, 2012, 4:12pm UTC](https://forum.inductiveautomation.com/t/database-model-decided-by-ignition/4592/1 "2012-06-07T16:12:13Z")

</div>

Hi.  
As I am going forward with the know-how of Ignition (great really) now it seems I do not have the control of the tables in my database to customize my historical data. I mean, first time I tried Ignition I just created a simulated OPC-Ua device and got it had its own historical table. But right now, in all my tests, the only tables I see are

` sqlt_data_1_2012_06 
 sqlth_drv           
 sqlth_partitions    
 sqlth_sce           
 sqlth_scinfo        
 sqlth_te `

Is that the only way it works now or otherway, how can I control my DB model to have whatever I want, one table by OPC-Ua device, foreign keys between such tables …whatever

---

<div class="post-metadata">

**Author:** ![Michael.Stofan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.stofan/32/3342_2.png) [@Michael.Stofan](https://forum.inductiveautomation.com/u/Michael.Stofan)\
**Post date:** [June 7, 2012, 4:23pm UTC](https://forum.inductiveautomation.com/t/database-model-decided-by-ignition/4592/2 "2012-06-07T16:23:12Z")

</div>

You’ll want to look into transaction groups for historical logging. That will allow you to choose the table name and column names. You also get triggering ability, so you can log information only when a certain condition is met (time of day, plc value, etc…)

For getting started with transaction groups, check out the [user manual entry](http://www.inductiveautomation.com/support/usermanuals/ignition/transactiongroupintroduction.htm).

---

<div class="post-metadata">

**Author:** ![aortiz](https://avatars.discourse-cdn.com/v4/letter/a/67e7ee/32.png) [@aortiz](https://forum.inductiveautomation.com/u/aortiz)\
**Post date:** [June 8, 2012, 7:30am UTC](https://forum.inductiveautomation.com/t/database-model-decided-by-ignition/4592/3 "2012-06-08T07:30:45Z")

</div>

Tnx a lot! I’ll go for it.