Skip to content

Instantly share code, notes, and snippets.

@diggzhang
Last active December 25, 2017 09:36
Show Gist options
  • Save diggzhang/8f37f4a2adb22db5f1238b02b211007b to your computer and use it in GitHub Desktop.
Save diggzhang/8f37f4a2adb22db5f1238b02b211007b to your computer and use it in GitHub Desktop.
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
mail
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
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