details_table.html

{% extends "details_base.html" %}
{% load markdown %}
{% load waffle_tags %}

{% block extra_details %}
  <div class="govuk-grid-row">
    <div class="govuk-grid-column-full">
      {% if entity.column_details %}
        <div class="govuk-heading-m">Table schema</div>
        {% include "partial/download_button.html" with entity_type='database' title="table descriptions" %}

        <table class="govuk-table app-table-responsive">
          <thead class="govuk-table__head">
            <tr class="govuk-table__row">
              <th scope="col" class="govuk-table__header">Column name</th>
              <th scope="col" class="govuk-table__header">Description</th>
              <th scope="col" class="govuk-table__header">Type</th>
              {% switch 'show_is_nullable_in_table_details_column' %}
                <th scope="col" class="govuk-table__header">Is nullable</th>
              {% endswitch %}
            </tr>
          </thead>
          <tbody class="govuk-table__body app-table-responsive__body">
            {% for column in entity.column_details %}
              <tr class="govuk-table__row app-table-responsive__row">
                <td class="govuk-table__cell"><span class="app-table-responsive__heading">Column name:</span>{{column.display_name}}</td>
                <td class="govuk-table__cell column-description"><span class="app-table-responsive__heading">Description:</span>
                {% if column.description %}
                <div>
                  {{column.description|default:''|markdown:3}}
                </div>
                {% else %}
                <p class="govuk-visually-hidden">A description for {{column.display_name}} does not exist</p>
                {% endif %}
                </td>
                <td class="govuk-table__cell"><span class="app-table-responsive__heading">Type:</span>{{column.type|title}}</td>
                {% switch 'show_is_nullable_in_table_details_column' %}
                  <td class="govuk-table__cell"><span class="app-table-responsive__heading">Is nullable:</span>{{column.nullable|yesno:"Yes,No,"}}</td>
                {% endswitch %}
              </tr>
            {% endfor %}
          </tbody>
        </table>

      {% else %}
        <h2 class="govuk-heading-m">Table schema</h2>
        <p class="govuk-body">The schema for this table is not available.</p>
      {% endif %}
      {% if has_lineage %}
        <h2 class="govuk-heading-m">Lineage</h2>
        <div class="govuk-body-m" >
          See where this data came from and how it is used in other tables.
        </div class="govuk-body-m">
        <div class="govuk-body">
          <a href="{{lineage_url}}" class="govuk-link" rel="noreferrer noopener" target="_blank">
            View lineage in DataHub (opens in new tab)
          </a>
        </div>
      {% endif %}
    </div>
{% endblock extra_details %}