[1,1]
r
_
condition
id_condition (PK)
id_condition_parent (FK)
id_value_right (FK)
negated
operator
left_name
condition_function
right_name
r
_
database
id_database (PK)
id_database_type (FK)
id_database_contype (FK)
name
host_name
database_name
port
username
password
servername
data_tbs
index_tbs
r
_
database
_
attribute
id_database_attribute (PK)
id_database (FK)
code
value_str
r
_
database
_
cont
yp
e
id_database_contype (PK)
code
description
r
_
database
_
t
yp
e
id_database_type (PK)
code
description
r
_
de
p
endenc
y
id_dependency (PK)
table_name
field_name
id_database (FK)
id_transformation (FK)
r
_
director
y
id_directory (PK)
id_directory_parent (FK)
directory_name
r
_
lo
g
id_log (PK)
id_database_log (FK)
id_loglevel (FK)
name
logtype
filename
fileextention
add_date
add_time
table_name_log
r
_
lo
g
level
id_loglevel (PK)
code
description
r
_
note
id_note (PK)
value_str
gui_location_x
gui_location_y
gui_location_width
gui_location_height
r
_
ste
p
id_step (PK)
id_transformation (FK)
id_step_type (FK)
name
description
distribute
copies
gui_location_x
gui_location_y
gui_draw
r
_
ste
p_
attribute
id_step_attribute (PK)
id_step (FK)
id_transformation (FK)
nr
code
value_num
value_str
r
_
ste
p_
database
id_transformation (PFK)
id_step (PFK)
id_database (PFK)
r
_
ste
p_
t
yp
e
id_step_type (PK)
code
description
helptext
r
_
trans
_
attribute
id_trans_attribute (PK)
id_transformation (FK)
nr
code
value_num
value_str
r
_
trans
_
ho
p
id_trans_hop (PK)
id_transformation (FK)
enabled
id_step_from
id_step_to
r
_
trans
_
note
id_note (PFK)
id_transformation (PFK)
r
_
trans
_
ste
p_
condition
id_transformation (PFK)
id_step (PFK)
id_condition (PFK)
r
_
transformation
id_transformation (PK)
id_directory (FK)
name
id_step_read
id_step_write
id_step_input
id_step_output
id_step_update
id_database_log
table_name_log
use_batchid
use_logfield
id_database_maxdate
table_name_maxdate
field_name_maxdate
offset_maxdate
diff_maxdate
modified_user
modified_date
size_rowset
r
_
value
id_value (PK)
name
value_type
value_str
is_null
