SELECT * FROM `TABLES`
过滤行: |
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | gym | gym_answer_supplement | BASE TABLE | InnoDB | 10 | Compact | 51 | 321 | 16384 | 0 | 32768 | 0 | 54 | 2018-01-02 14:14:57 | NULL | NULL | utf8mb4_general_ci | NULL | 问卷补充表 | ||
def | gym | gym_auth_group | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 1 | 2018-01-02 14:14:57 | 2018-01-02 14:14:57 | NULL | utf8mb4_general_ci | NULL | 用户组表以此来区分用户是什么身份 | ||
def | gym | gym_auth_group_relation | BASE TABLE | MyISAM | 10 | Fixed | 114 | 265 | 30210 | 74590868828323839 | 13312 | 0 | 116 | 2018-01-02 14:14:57 | 2020-11-02 15:23:17 | 2018-01-02 14:14:57 | utf8mb4_general_ci | NULL | 用户组明细表 | ||
def | gym | gym_auth_rule | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 1 | 2024-02-03 04:40:21 | 2024-02-03 04:40:21 | 2024-02-03 04:40:21 | utf8mb4_general_ci | NULL | 用户的规则表 | ||
def | gym | gym_boss_point_rule | BASE TABLE | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 0 | 13 | 2018-01-04 10:11:16 | NULL | NULL | utf8_general_ci | NULL | boss积分规则表 | ||
def | gym | gym_captcha_code | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | NULL | 2018-01-02 14:14:57 | 2018-01-02 14:14:57 | 2018-01-02 14:14:57 | utf8mb4_general_ci | NULL | 验证码表 | ||
def | gym | gym_certificate_of_merit | BASE TABLE | MyISAM | 10 | Dynamic | 2 | 280 | 560 | 281474976710655 | 9216 | 0 | 3 | 2018-01-02 14:14:57 | 2018-08-04 10:57:27 | 2018-01-02 14:14:57 | utf8mb4_general_ci | NULL | 奖励表 | ||
def | gym | gym_circle | BASE TABLE | MyISAM | 10 | Fixed | 5 | 790 | 37130 | 222365231601418239 | 11264 | 33180 | 396 | 2018-03-02 11:46:59 | 2024-02-03 14:19:39 | NULL | utf8mb4_general_ci | NULL | 朋友圈的功能 | ||
def | gym | gym_circle_comment | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | 54 | 2024-02-07 13:53:38 | 2024-02-07 13:53:38 | 2024-02-07 13:53:38 | utf8mb4_general_ci | NULL | 评论表 | ||
def | gym | gym_coach_card | BASE TABLE | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 0 | 0 | 13 | 2018-03-15 12:47:20 | NULL | NULL | utf8_general_ci | NULL | 教练名片表 | ||
def | gym | gym_coach_course | BASE TABLE | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 32768 | 0 | 230 | 2024-03-15 15:36:46 | NULL | NULL | utf8_general_ci | NULL | 约课表 | ||
def | gym | gym_coach_course_list | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2018-01-11 14:34:58 | 2018-01-11 14:34:58 | NULL | utf8_general_ci | NULL | |||
def | gym | gym_contribution_record | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2018-01-02 14:14:57 | NULL | NULL | utf8mb4_general_ci | NULL | 健身房的缴费记录 | ||
def | gym | gym_course | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | 5 | 2024-01-24 03:20:17 | 2024-01-24 03:20:17 | 2024-01-24 03:20:17 | utf8mb4_general_ci | NULL | 教练的约课信息 | ||
def | gym | gym_course_comments | BASE TABLE | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 0 | 98 | 2018-02-06 11:08:51 | NULL | NULL | utf8_general_ci | NULL | 课程评论表 | ||
def | gym | gym_course_content | BASE TABLE | MyISAM | 10 | Fixed | 0 | 0 | 0 | 7036874417766399 | 1024 | 0 | 20 | 2024-02-03 22:19:31 | 2024-02-03 22:19:31 | 2024-02-03 22:19:31 | utf8mb4_general_ci | NULL | 上课内容表 | ||
def | gym | gym_course_dynamic | BASE TABLE | MyISAM | 10 | Dynamic | 3 | 230 | 7380 | 281474976710655 | 17408 | 6688 | 47 | 2018-03-21 10:06:10 | 2018-08-04 16:51:46 | NULL | utf8mb4_general_ci | NULL | 课程动态表 | ||
def | gym | gym_course_dynamic_img | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 1 | 2024-02-24 07:32:58 | 2024-02-24 07:32:58 | NULL | utf8mb4_general_ci | NULL | 课程动态图片 | ||
def | gym | gym_course_killer_package | BASE TABLE | InnoDB | 10 | Compact | 78 | 210 | 16384 | 0 | 0 | 0 | 80 | 2018-09-06 23:18:58 | NULL | NULL | utf8_general_ci | NULL | 消课拼团套餐 | ||
def | gym | gym_course_killer_race | BASE TABLE | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 0 | 14 | 2024-03-01 15:33:52 | NULL | NULL | utf8_general_ci | NULL | 他律挑战赛列表 | ||
def | gym | gym_course_killer_race_player | BASE TABLE | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 0 | 0 | 9 | 2018-09-09 23:13:21 | NULL | NULL | utf8_general_ci | NULL | 他律挑战赛参与选手 | ||
def | gym | gym_course_share | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2018-03-29 12:50:04 | NULL | NULL | utf8_general_ci | NULL | 潜在用户表 | ||
def | gym | gym_course_type | BASE TABLE | InnoDB | 10 | Compact | 1093 | 1454 | 1589248 | 0 | 0 | 0 | 526 | 2024-02-23 23:09:02 | NULL | NULL | utf8_general_ci | NULL | 课程类型表 | ||
def | gym | gym_couser_praise | BASE TABLE | InnoDB | 10 | Compact | 58 | 282 | 16384 | 0 | 32768 | 0 | 88 | 2024-02-24 04:25:56 | NULL | NULL | utf8_general_ci | NULL | 点赞表 | ||
def | gym | gym_disable | BASE TABLE | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | 1 | 2018-01-02 14:14:57 | 2018-01-02 14:14:57 | NULL | utf8mb4_general_ci | NULL | 是否禁用 |
过滤行: |