Skip to content

Instantly share code, notes, and snippets.

@OMGZui
Last active January 3, 2023 14:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save OMGZui/2f8ed706842ea10bb6148959a642b643 to your computer and use it in GitHub Desktop.
Save OMGZui/2f8ed706842ea10bb6148959a642b643 to your computer and use it in GitHub Desktop.
CREATE TABLE `hospital_statistics_data` (
`pk_id` bigint unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(36) COLLATE utf8mb4_general_ci NOT NULL,
`hospital_code` varchar(36) COLLATE utf8mb4_general_ci NOT NULL,
`biz_type` tinyint NOT NULL,
`item_code` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`item_name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
`item_value` varchar(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
`is_deleted` tinyint DEFAULT NULL,
PRIMARY KEY (`pk_id`)
) DEFAULT CHARSET=utf8mb4;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment