12345678910111213141516171819202122 |
- CREATE TABLE `base_organ` (
- `id` int(0) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `parent` int(0) NULL DEFAULT NULL,
- `inheritance` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_time` datetime(0) NULL DEFAULT NULL,
- `last_update_time` datetime(0) NULL DEFAULT NULL,
- `organ_pinyin` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `organ_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `last_update_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `if_buy_online` int(0) NULL DEFAULT NULL,
- `organ_tell` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `del_flag` int(0) NOT NULL DEFAULT 0,
- `sheng_id` int(0) NULL DEFAULT NULL,
- `organ_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `parent_id` int(0) NULL DEFAULT NULL,
- `organ_type` int(0) NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `IDX_base_organ_parent`(`parent`) USING BTREE,
- INDEX `IDX_base_organ_sheng_id`(`sheng_id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 20058 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|