Last active
December 25, 2017 09:36
-
-
Save diggzhang/8f37f4a2adb22db5f1238b02b211007b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ability | |
ability_belonged | |
ability_scale | |
account | |
added_coins | |
answer | |
api | |
apk_sign | |
apk_url | |
app_duration | |
app_list | |
app_sign | |
auth_state | |
avatar_id | |
avatar_price | |
batch_id | |
bind_success | |
bourn | |
box_index | |
box_status | |
buffer | |
button | |
button_label | |
button_number | |
button_type | |
by_user | |
c_end | |
c_from | |
c_on | |
c_start | |
cache | |
cancel_login | |
category | |
channel | |
chapter_id | |
chapter_name | |
chapter_progress | |
cheats_test_id | |
circle_code | |
circles | |
city | |
click_avatar_id | |
coins | |
comment_id | |
correct | |
county | |
coupon | |
coupon_remain | |
course_state | |
cur_resolution | |
current_avatar_id | |
current_group_id | |
current_group_type | |
current_page | |
d_app_version | |
d_idfv | |
d_is_jail_break | |
d_model | |
d_model_brand | |
d_model_name | |
d_os | |
d_os_name | |
d_os_version | |
dealine | |
deleted_videos | |
device | |
device_attr | |
difficulty | |
download_version | |
downloaded_videos | |
downloading_videos | |
duration | |
error | |
error_code | |
error_domain | |
error_message | |
error_msg | |
error_url | |
event_key | |
event_time | |
events_id | |
events_name | |
exam_id | |
exam_type | |
exception | |
existed_user | |
experience_enabled | |
fail_practice_id | |
failed_index | |
finish_state | |
finished | |
finished_count | |
folds | |
from_theme_id | |
from_theme_name | |
from_topic_id | |
from_topic_name | |
frontoption | |
gender | |
get_notice_prompted | |
gift | |
good_id | |
good_name | |
guide_banner_switch | |
help_topic_id | |
home_buffer_icon | |
icon | |
id | |
in_app | |
includeladder | |
index | |
info | |
init4 | |
init_enter | |
installation_id | |
interaction_id | |
invitation_code | |
ip | |
is_ad | |
is_change | |
is_events_prompted | |
is_first | |
is_first_notice | |
is_force | |
is_get_coins | |
is_gift | |
is_guide | |
is_notice_prompted | |
is_possessed | |
is_practice | |
is_predict | |
is_roles_change | |
is_room_change | |
is_setting_prompted | |
is_success | |
is_task | |
is_task_success | |
is_teacher_change | |
is_vip | |
is_vip_content | |
is_waggling | |
ladder_level | |
last_chapter_id | |
last_chapter_name | |
layer_index | |
leadbar_finished | |
leadbar_text | |
leadbar_topic_id | |
leadbar_topic_name | |
leadbar_topic_type | |
learn_time | |
learned | |
left_coins | |
left_coupon | |
left_coupon_charge | |
level | |
level_count | |
level_id | |
level_index | |
location | |
login_success | |
maintain_time | |
master | |
max_power | |
max_skill_power | |
message | |
method | |
miss_time | |
mobile_net_enabled | |
name | |
name_filled | |
name_got | |
net | |
net_config | |
net_speed | |
new_avatar_id | |
new_chapter_id | |
new_chapter_name | |
new_circle_name | |
new_city | |
new_county | |
new_gender | |
new_group_id | |
new_group_name | |
new_group_type | |
new_mail | |
new_name | |
new_on_tab | |
new_presents | |
new_presents_count | |
new_province | |
new_publisher | |
new_roles | |
new_room_name | |
new_route | |
new_school | |
new_semester | |
new_subject | |
new_subject_id | |
new_teacher | |
new_theam_id | |
new_theam_name | |
new_theme_id | |
new_topic_id | |
next_resolution | |
notice_id | |
notice_name | |
notice_type | |
notification | |
ntime | |
number | |
online_time | |
open_uuid | |
option | |
option_price | |
order_id | |
ori_chapter_id | |
ori_chapter_name | |
ori_city | |
ori_county | |
ori_gender | |
ori_group_id | |
ori_group_name | |
ori_mail | |
ori_name | |
ori_province | |
ori_publisher | |
ori_qq_bound | |
ori_roles | |
ori_room_name | |
ori_route | |
ori_school | |
ori_semester | |
ori_subject | |
ori_subject_id | |
ori_teacher | |
ori_theam_id | |
ori_theam_name | |
os | |
package_id | |
page_index | |
page_info | |
page_name | |
page_rate | |
page_source | |
page_type | |
parent_topic_id | |
parent_topic_name | |
pattern | |
pay_from | |
payable | |
payment_method | |
payment_platform | |
payment_tab | |
phone | |
phone_bound | |
phone_got | |
platform | |
pos | |
position | |
power | |
practice_id | |
practice_time | |
present_index | |
presents_activated | |
presents_used | |
price | |
problem | |
problem_finished | |
problem_id | |
product_id | |
province | |
publisher | |
publisher_id | |
q2code_id | |
qq_bound | |
querstion_index | |
question_count | |
question_index | |
questionnaires_url | |
quit_circle_id | |
quit_circle_name | |
quit_type | |
reading_events | |
reading_events_count | |
reading_notices | |
reading_notices_count | |
reason | |
reasons | |
receipt | |
recommend | |
redirect_count | |
redirect_url | |
related_theme_id | |
related_theme_name | |
report_enabled | |
resolution | |
role | |
roles | |
room_name | |
room_ref | |
route | |
school | |
score | |
select_chapter_id | |
select_chapter_name | |
semester | |
semester_id | |
server_time | |
sever_and_real_date | |
share_platform | |
signup_success | |
skill_id | |
skill_level | |
skill_name | |
skill_power | |
skill_updated | |
stage | |
state | |
statistics_begin_time | |
statistics_count | |
statistics_end_time | |
step | |
student_id | |
subject | |
subject_id | |
subsection_id | |
switch | |
t_patch_url | |
task_chapter_id | |
task_first | |
task_fourth | |
task_index | |
task_last | |
task_second | |
task_state | |
task_third | |
teacher | |
teacher_message | |
test_count | |
test_index | |
theme_cursor | |
theme_id | |
theme_name | |
throwable | |
tip | |
title | |
to_theme_id | |
to_theme_name | |
tongdian | |
topic_count | |
topic_id | |
topic_learned | |
topic_name | |
topic_payable | |
topic_state | |
topic_tongdian | |
topic_type | |
total | |
total_problems | |
total_time | |
transaction_id | |
type | |
u_ability | |
u_activate_date | |
u_channel | |
u_city | |
u_from | |
u_gender | |
u_has_room | |
u_high_math | |
u_index | |
u_is_big_switch | |
u_is_small_switch | |
u_is_vip | |
u_junior_math | |
u_junior_physics | |
u_ladder_junior_math | |
u_last_publisher | |
u_leadbar_state | |
u_level | |
u_name | |
u_nickname | |
u_pattern | |
u_phone | |
u_power | |
u_province | |
u_publisher | |
u_role | |
u_route | |
u_school | |
u_section_junior_math | |
u_semester | |
u_tenant | |
u_timestamp | |
u_type | |
u_user | |
u_vip | |
ua | |
ui | |
unwind_count | |
unwind_time | |
url | |
use_state | |
user_ability | |
user_id | |
user_level | |
username | |
uuid | |
value | |
verify | |
video_duration | |
video_id | |
video_index | |
video_name | |
video_time | |
video_title | |
video_type | |
video_url | |
view_type | |
voucher | |
waggling_cause | |
wifi_connected | |
will_amway |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT DISTINCT json_extract_path(rawjsonschema::json->0, 'propName')::TEXT as public_fildes | |
FROM pointpool | |
WHERE status = 1 | |
ORDER BY public_fildes; | |
//output | |
account | |
answer | |
appDuration | |
bindSuccess | |
button | |
chapterId | |
circleCode | |
circles | |
commentId | |
deletedVideos | |
downloadedVideos | |
duration | |
error | |
errorMsg | |
eventsId | |
finalplanId | |
from | |
goodId | |
homeworkId | |
icon | |
includeladder | |
index | |
interactionId | |
invitationCode | |
isSuccess | |
ladderLevel | |
learnTime | |
leftCoupon | |
level | |
loginSuccess | |
newChapterId | |
newCircleName | |
newGroupId | |
newMail | |
newName | |
newSubject | |
newTopicId | |
noticeId | |
noticeName | |
noticeType | |
option | |
packageId | |
pageIndex | |
pattern | |
paymentPlatform | |
paymentTab | |
position | |
problemId | |
publisher | |
q2codeId | |
quitCircleId | |
readingEventsCount | |
readingNoticesCount | |
sectionId | |
semester | |
semesterId | |
sharePlatform | |
signupSuccess | |
skillName | |
stage | |
start | |
state | |
statisticsBeginTime | |
subject | |
subsectionId | |
taskId | |
themeId | |
timestamp | |
tip | |
title | |
topicId | |
type | |
u_ladderJuniorMath | |
userId | |
videoId | |
VideoId |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment