--
-- Host: localhost    Database: surveillance_db
-- ------------------------------------------------------


--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` varchar(20) NOT NULL,
  `status` enum('active','inactive','terminated') DEFAULT 'active',
  `sync_node` int(11) DEFAULT NULL,
  `last_sync` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

