select 'claim      ' as table, 'first_notification_of_loss' as column,  to_char(min(first_notification_of_loss), 'YYYY-MM-DD'), to_char(max(first_notification_of_loss) , 'YYYY-MM-DD') from claim        union all
select 'claim      ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from claim        union all
select 'claim      ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from claim        union all
select 'claim_head ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from claim_head   union all
select 'claim_head ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from claim_head   union all
select 'claimant   ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from claimant     union all
select 'claimant   ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from claimant     union all
select 'damage     ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from damage       union all
select 'damage     ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from damage       union all
select 'driver     ' as table, 'from_date_time            ' as column,  to_char(min(from_date_time),             'YYYY-MM-DD'), to_char(max(from_date_time)             , 'YYYY-MM-DD') from driver       union all
select 'driver     ' as table, 'to_date_time              ' as column,  to_char(min(to_date_time),               'YYYY-MM-DD'), to_char(max(to_date_time)               , 'YYYY-MM-DD') from driver       union all
select 'driver     ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from driver       union all
select 'driver     ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from driver       union all
select 'incident   ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from incident     union all
select 'incident   ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from incident     union all
select 'passenger  ' as table, 'from_date_time            ' as column,  to_char(min(from_date_time),             'YYYY-MM-DD'), to_char(max(from_date_time)             , 'YYYY-MM-DD') from passenger    union all
select 'passenger  ' as table, 'to_date_time              ' as column,  to_char(min(to_date_time),               'YYYY-MM-DD'), to_char(max(to_date_time)               , 'YYYY-MM-DD') from passenger    union all
select 'passenger  ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from passenger    union all
select 'passenger  ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from passenger    union all
select 'person     ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from person       union all
select 'person     ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from person       union all
select 'policy     ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from policy       union all
select 'policy     ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from policy       union all
select 'transaction' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from transaction  union all
select 'transaction' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from transaction  union all
select 'vehicle    ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from vehicle      union all
select 'vehicle    ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from vehicle      union all
select 'witness    ' as table, 'created_at                ' as column,  to_char(min(created_at),                 'YYYY-MM-DD'), to_char(max(created_at)                 , 'YYYY-MM-DD') from witness      union all
select 'witness    ' as table, 'updated_at                ' as column,  to_char(min(updated_at),                 'YYYY-MM-DD'), to_char(max(updated_at)                 , 'YYYY-MM-DD') from witness      union all
select 'vehicle    ' as table, 'year_first_licensed       ' as column,  trim(to_char(min(year_first_licensed), '0000')),        trim(to_char(max(year_first_licensed), '0000'))         from vehicle;
