reporter.super_simple_record (view)
|
This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly. |
Columns
| Column | Type | Nullable | Notes |
|---|---|---|---|
id |
|
Yes |
|
fingerprint |
|
Yes |
|
quality |
|
Yes |
|
tcn_source |
|
Yes |
|
tcn_value |
|
Yes |
|
title |
|
Yes |
|
author |
|
Yes |
|
publisher |
|
Yes |
|
pubdate |
|
Yes |
|
isbn |
|
Yes |
|
issn |
|
Yes |
View Definition
SELECT materialized_simple_record.id,
materialized_simple_record.fingerprint,
materialized_simple_record.quality,
materialized_simple_record.tcn_source,
materialized_simple_record.tcn_value,
materialized_simple_record.title,
materialized_simple_record.author,
materialized_simple_record.publisher,
materialized_simple_record.pubdate,
materialized_simple_record.isbn,
materialized_simple_record.issn
FROM reporter.materialized_simple_record;