--
-- Host: localhost    Database: hospital
-- ------------------------------------------------------


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hos_id` varchar(255) DEFAULT NULL,
  `hos_pw` varchar(255) DEFAULT NULL,
  `registry_datetime` datetime DEFAULT NULL,
  `flug` varchar(45) DEFAULT NULL,
  `hos_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,'ikegami@cmpj.co.jp','ikegami@cmpj.co.jp',NULL,'2',NULL),(2,'h221107001','Akiko',NULL,'2','桂台内科クリニック');


