measure_authors

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