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,
`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 |
|---|---|---|---|---|
| author_id | int(11) | NOT NULL AUTO_INCREMENT | Provided by Pellucid | 01234567890 |
| author | text | DEFAULT NULL | The Name of the organization that created the measure | AHRQ |
| 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 |
| 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 |