Database structure IWS additional data

Additional data are using two tables with identical table structure – twaz_addata, twaz_addata_hist.

Table Twaz_addata stores additional data for actual, modified, inserted tws app records.

Twaz_addata_hist stores additional data for history, interim tws app records.

Structure of both tables

column name	data type	Description
id	Int	id of app record, equal to id in table adcom
addsegment	Varchar	segment to which addata links, values:adcom,adop
addkey	Varchar	key identifier for segment, adcom:empty string, adop:adopno
addname	Varchar	field name
addvalue	Varchar	field value