 CREATE TABLE `prices` (
   `id` binary(36) NOT NULL,
   `license_id` binary(36) NOT NULL,
-  `nhi_id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `nhi_dosage` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `nhi_unit` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `date_begin` date NOT NULL,
-  `date_end` date NOT NULL,
-  `nhi_price` decimal(10,2) NOT NULL,
+  `nhi_id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '健保代碼',
+  `nhi_dosage` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用量',
+  `nhi_unit` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用量單位',
+  `date_begin` date NOT NULL COMMENT '開始日期',
+  `date_end` date NOT NULL COMMENT '結束日期',
+  `nhi_price` decimal(10,2) NOT NULL COMMENT '健保價格',
   PRIMARY KEY (`id`),
   KEY `drug_id` (`license_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
  `id` binary(36) NOT NULL,
  `license_id` binary(36) NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` tinyint(3) NOT NULL,
  `sort` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

  `usage` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '用法用量',
  `package_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '包裝',
  `barcode` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '國際條碼',
  PRIMARY KEY (`id`),
  KEY `license_uuid` (`license_uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

