i2bill_sys_attachment.sql 699 B

123456789101112
  1. CREATE TABLE i2bill_sys_attachment (
  2. `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  3. `name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  4. `size` int(0) NOT NULL,
  5. `ext` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  6. `hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  7. `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  8. `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  9. `create_time` datetime(0) NOT NULL,
  10. `del_flag` int(0) NOT NULL,
  11. PRIMARY KEY (`id`) USING BTREE
  12. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;