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 CreationCREATE 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 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
`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 ;
| 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 |