{% for i in 0..table_names|length - 1 %} {% set t_n = table_names[i] %} {% set t_n_url = table_names_url[i] %}
| {% endif %} | {{ tab_pos[t_n] is not defined or tab_pos[t_n]['V'] is not empty ? 'v' : '>' }} |
|
{{ owner_out[i]|raw }} {{ table_names_small_out[i]|raw }} | {% if has_query %}{% endif %} |
| {% endif %} |
{% if tables_pk_or_unique_keys[t_n ~ '.' ~ tab_column[t_n]['COLUMN_NAME'][j]] is defined %}
{% else %}
{% set type = 'designer/Field_small' %}
{% if strstr(tab_column[t_n]['TYPE'][j], 'char')
or strstr(tab_column[t_n]['TYPE'][j], 'text') %}
{% set type = type ~ '_char' %}
{% elseif strstr(tab_column[t_n]['TYPE'][j], 'int')
or strstr(tab_column[t_n]['TYPE'][j], 'float')
or strstr(tab_column[t_n]['TYPE'][j], 'double')
or strstr(tab_column[t_n]['TYPE'][j], 'decimal') %}
{% set type = type ~ '_int' %}
{% elseif strstr(tab_column[t_n]['TYPE'][j], 'date')
or strstr(tab_column[t_n]['TYPE'][j], 'time')
or strstr(tab_column[t_n]['TYPE'][j], 'year') %}
{% set type = type ~ '_date' %}
{% endif %}
{% endif %}
{{ tab_column[t_n]['COLUMN_NAME'][j] }} : {{ tab_column[t_n]['TYPE'][j] }}
|
{% if has_query %}
|
{% endif %}
||