Summary

This table provides information about the authors of measures; its primary key is the author_id. This table keeps track of where the measures originated and provides a reference for our measures table. An example of a measure author would be the Centers for Medicare and Medicaid Services creating the Process of Care measures.

Table Creation

CREATE TABLE IF NOT EXISTS `measure_authors` (
`author_id` int(11) NOT NULL AUTO_INCREMENT,
`author` text DEFAULT NULL,
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`author_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;

Fields

field	type	attributes	notes	example
measure_authors.author_id	int(11)	NOT NULL AUTO_INCREMENT	Provided by Pellucid	01234567890
measure_authors.author	text	DEFAULT NULL	The Name of the organization that created the measure	AHRQ
measure_authors.created	timestamp	NOT NULL DEFAULT '0000-00-00 00:00:00'	The time and date that the row was created	2010-05-18 09:15:36
measure_authors.modified	timestamp	NOT NULL DEFAULT '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP	The time and date that the row was last modified	2010-05-18 09:15:36

Browser not supported