Table: `ndb.publicationeditors`#

Description#

This table stores the editors of publications for which chapters or sections are the primary bibliographic entries. Chapter authors are stored in the PublicatonAuthors table, where they are linked to the Contacts table. However, publication editors are not cross-referenced in the Contacts table, because chapter authors are the principal citation.

TODO: Expand this description with: - What data does this table store? - What is the business/research purpose? - How is this data collected or generated? - Are there any important caveats or data quality issues?

Table Structure#

Schema: ndb | Table Comment: This table stores the editors of publications for which chapters or sections are the primary bibliographic entries. Chapter authors are stored in the PublicatonAuthors table, where they are linked to the Contacts table. However, publication editors are not cross-referenced in the Contacts table, because chapter authors are the principal citation.

Statistics#

Metric	Value
Row Count	1,603
Total Size	456 kB
Table Size	120 kB
Indexes Size	336 kB

Relationships#

Primary Key: editorid

Foreign Keys:

publicationid → publications.publicationid

Referenced By:

TODO: Document which tables reference this table (will be auto-detected in validation).

Data Dictionary#

Column	Type	Nullable	Default	Constraints	Description
`editorid`	integer	✗	`nextval('ndb.seq_publicatio...`	PRIMARY KEY	An arbitrary Editor identification number.
`publicationid`	integer	✗	`-`	FOREIGN KEY	Publication identification number. Field links to the Publications table.
`editororder`	integer	✓	`-`	-	Ordinal number for the position in which the editor’s name appears in the publication’s author list.
`familyname`	character varying(64)	✓	`-`	-	Family name of editor
`initials`	character varying(8)	✓	`-`	-	Initials of editor’s given names
`suffix`	character varying(8)	✓	`-`	-	Authors suffix (e.g. «Jr.»)
`recdatecreated`	timestamp without time zone	✗	`timezone('UTC'::text, now())`	-
`recdatemodified`	timestamp without time zone	✗	`-`	-

TODO: Review column descriptions and add comments where missing.

Usage Examples#

Example 1: Basic Selection#

-- Get recent records from publicationeditors
SELECT *
FROM publicationeditors
ORDER BY editorid DESC
LIMIT 10;

Purpose: Retrieve the 10 most recent records from publicationeditors

Example 2: Count Records#

-- Count total records
SELECT COUNT(*) as total_records
FROM publicationeditors;

Purpose: Get the total number of records in publicationeditors

Example 3: Filter by Date Range#

-- Get records within a date range
SELECT *
FROM publicationeditors
WHERE recdatecreated >= '2024-01-01'
  AND recdatecreated < '2025-01-01'
ORDER BY recdatecreated DESC;

Purpose: Retrieve records from publicationeditors within a specific date range

Example 4: Join with publications#

-- Join with related table
SELECT 
    t1.*,
    t2.*
FROM publicationeditors t1
INNER JOIN publications t2 
    ON t1.publicationid = t2.publicationid
LIMIT 100;

Purpose: Retrieve publicationeditors records with related data from publications

Example 5: Aggregate Data#

-- Aggregate records by publicationid
SELECT 
    publicationid,
    COUNT(*) as count
FROM publicationeditors
GROUP BY publicationid
ORDER BY count DESC
LIMIT 10;

Purpose: Count records grouped by publicationid

TODO: Add more specific examples relevant to common research questions or operational tasks.

Data Quality Notes#

TODO: Document: - Known data quality issues - Validation rules - Expected data ranges - Update frequency and mechanisms - Any ETL processes that populate this table

Maintenance#

Data Owner: TODO: Assign owner
Update Frequency: TODO: Document frequency
Last Major Schema Change: TODO: Document when schema last changed

Table: ndb.publicationeditors#