数据库: nns 的表结构

表: admin_users

字段名	类型	是否为空	键	默认值	额外
id	int unsigned	NO	PRI		auto_increment
username	varchar(50)	NO	UNI
password	varchar(255)	NO
real_name	varchar(50)	YES
status	tinyint(1)	NO		1
created_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
updated_at	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

表: analytics_daily

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
metric_date	date	NO	MUL
metric_key	varchar(64)	NO	MUL
dimension_key	varchar(32)	NO
dimension_value	varchar(128)	NO
count_value	bigint unsigned	NO		0

表: arena_challenges

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
session_id	bigint unsigned	NO	MUL
challenger_user_id	bigint unsigned	NO
video_id	bigint unsigned	NO	MUL
status	varchar(20)	NO		active
created_at	int	NO
resolved_at	int	YES

表: arena_events

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
session_id	bigint unsigned	NO	MUL
event_type	varchar(40)	NO
payload_json	text	YES
created_at	int	NO

表: arena_rules

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
name	varchar(120)	NO
status	tinyint	NO	MUL	1
challenge_window_seconds	int unsigned	NO		86400
skateboard_min_score	decimal(6,4)	YES
settlement_mode	varchar(32)	NO		first_cross
is_default	tinyint	NO		0
remark	varchar(500)	NO
created_at	int	NO
updated_at	int	NO

表: arena_session_referees

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
session_id	bigint unsigned	NO	MUL
user_id	bigint unsigned	NO
sort_order	int unsigned	NO		0
created_at	int	NO

表: arena_sessions

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
rule_id	bigint unsigned	NO
season_id	bigint unsigned	YES
tier_code	varchar(64)	NO	MUL
tier_name	varchar(120)	NO
title	varchar(120)	NO
champion_user_id	bigint unsigned	NO
champion_video_id	bigint unsigned	NO	MUL
location_id	bigint unsigned	YES
map_latitude	decimal(10,7)	YES
map_longitude	decimal(11,8)	YES
map_poi_name	varchar(200)	YES
map_address	varchar(500)	YES
status	varchar(20)	NO	MUL	open
window_start	int	NO
window_end	int	NO
created_at	int	NO
closed_at	int	YES

表: club_blacklist

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
club_id	bigint unsigned	NO	MUL
user_id	bigint unsigned	NO	MUL
reason	varchar(255)	YES
created_by	bigint unsigned	NO
created_at	int	NO

表: club_join_requests

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
club_id	bigint unsigned	NO	MUL
user_id	bigint unsigned	NO	MUL
apply_reason	varchar(255)	YES
status	tinyint	NO		0
reviewer_user_id	bigint unsigned	YES
review_remark	varchar(255)	YES
created_at	int	NO
reviewed_at	int	YES

表: club_members

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
club_id	bigint unsigned	NO	MUL
user_id	bigint unsigned	NO	MUL
role	tinyint	NO		3
status	tinyint	NO		1
joined_at	int	NO
left_at	int	YES

表: clubs

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
owner_user_id	bigint unsigned	NO	MUL
name	varchar(64)	NO	UNI
logo_url	varchar(255)	YES
description	varchar(255)	YES
address	varchar(255)	YES
latitude	decimal(10,7)	YES
longitude	decimal(10,7)	YES
min_score	int unsigned	NO		0
join_type	tinyint	NO		0
status	tinyint	NO		1
created_at	int	NO
updated_at	int	NO

表: experience_grants

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
user_id	bigint	NO	MUL
grant_type	varchar(32)	NO
ref_id	varchar(128)	NO
amount	int	NO
created_at	int	NO

表: experience_logs

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
user_id	bigint	NO	MUL
change_amount	int	NO
balance_after	int	NO
reason	varchar(64)	NO	MUL
ref_type	varchar(32)	YES
ref_id	varchar(128)	YES
created_at	int	NO

表: experience_settings

字段名	类型	是否为空	键	默认值
id	int unsigned	NO	PRI
avatar_skateboard	int	NO		10
challenge_upload	int	NO		20
arena_participate	int	NO		15
arena_create	int	NO		15
club_join	int	NO		30
club_leave	int	NO		20
referee_request_cost	int	NO		50
updated_at	int	NO		0

表: leaderboard_users

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
season_id	int unsigned	NO	MUL
user_id	bigint unsigned	NO	MUL
total_score	int unsigned	NO		0
joined_at	int	NO
updated_at	int	NO

表: page_banner_slots

字段名	类型	是否为空	键	默认值	额外
banner_id	bigint unsigned	NO	PRI
slot	varchar(32)	NO	PRI

表: page_banners

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
title	varchar(120)	NO
image_url	varchar(512)	NO
link_type	varchar(16)	NO		none
link_target	varchar(512)	NO
sort_order	int	NO		0
status	tinyint	NO	MUL	1
created_at	int	NO
updated_at	int	NO

表: permission_defs

字段名	类型	是否为空	键	默认值
code	varchar(64)	NO	PRI
name	varchar(64)	NO
category	varchar(16)	NO		page
sort_order	int	NO		0

表: permission_group_grants

字段名	类型	是否为空	键	默认值	额外
group_id	int unsigned	NO	PRI
permission_code	varchar(64)	NO	PRI

表: permission_groups

字段名	类型	是否为空	键	默认值	额外
id	int unsigned	NO	PRI		auto_increment
code	varchar(32)	NO	UNI
name	varchar(64)	NO
description	varchar(255)	NO
is_system	tinyint	NO		0
sort_order	int	NO		0
created_at	int unsigned	NO		0
updated_at	int unsigned	NO		0

表: rank_tier_sets

字段名	类型	是否为空	键	默认值	额外
id	int unsigned	NO	PRI		auto_increment
name	varchar(64)	NO
description	varchar(255)	NO
created_at	int	NO		0

表: rank_tiers

字段名	类型	是否为空	键	默认值	额外
id	int unsigned	NO	PRI		auto_increment
set_id	int unsigned	NO	MUL
code	varchar(32)	NO	UNI
name	varchar(32)	NO
min_score	int unsigned	NO
max_score	int unsigned	YES
display_order	tinyint	NO		0
badge_icon	varchar(255)	NO

表: referee_profiles

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
user_id	bigint unsigned	NO	UNI
submission_id	bigint unsigned	YES	MUL
real_name	varchar(64)	NO
city	varchar(64)	NO
job_title	varchar(128)	NO
honors	text	YES
club_name	varchar(128)	NO
avatar_url	varchar(512)	NO
created_at	int	NO
updated_at	int	NO

表: referee_submissions

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
user_id	bigint unsigned	YES	MUL
openid	varchar(64)	YES	MUL
upload_key	varchar(64)	YES
real_name	varchar(64)	NO
city	varchar(64)	NO
job_title	varchar(128)	NO
honors	text	YES
club_name	varchar(128)	NO
avatar_url	varchar(512)	NO
status	enum('pending','adopted','rejected')	NO	MUL	pending
reject_reason	varchar(255)	YES
reviewed_by	varchar(64)	YES
reviewed_at	int	YES
created_at	int	NO
updated_at	int	NO

表: score_logs

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
season_id	int unsigned	NO	MUL
user_id	bigint unsigned	NO	MUL
change_amount	int	NO
balance_after	int unsigned	NO
reason	varchar(64)	NO
created_at	int	NO

表: seasons

字段名	类型	是否为空	键	默认值	额外
id	int unsigned	NO	PRI		auto_increment
name	varchar(64)	NO
start_at	int	NO	MUL
end_at	int	NO
status	tinyint	NO	MUL	1
rank_tier_set_id	int unsigned	YES
created_at	int	NO

表: site_messages

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
sender_user_id	bigint unsigned	NO	MUL
recipient_user_id	bigint unsigned	NO	MUL
msg_type	varchar(32)	NO
content	varchar(800)	NO
video_id	bigint unsigned	YES
comment_id	bigint unsigned	YES
is_read	tinyint	NO		0
created_at	int	NO

表: sms_verify_sessions

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
scene	varchar(32)	NO
phone	varchar(20)	NO	MUL
openid	varchar(64)	NO	MUL
out_id	varchar(64)	NO
scheme_name	varchar(32)	NO
expires_at	int unsigned	NO
created_at	int unsigned	NO

表: user_events

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
user_id	bigint unsigned	YES	MUL
session_id	varchar(64)	NO	MUL
event_name	varchar(64)	NO	MUL
properties	json	YES
platform	varchar(16)	NO	MUL	mp
client_ts	bigint unsigned	NO		0
server_ts	int	NO
ip_hash	char(64)	YES

表: user_follows

字段名	类型	是否为空	键	额外
id	int unsigned	NO	PRI	auto_increment
follower_user_id	int	NO	MUL
followed_user_id	int	NO	MUL
created_at	int	NO

表: users

字段名	类型	是否为空	键	默认值	额外
user_id	bigint unsigned	NO	PRI		auto_increment
user_no	varchar(32)	YES	UNI
openid	varchar(28)	NO	UNI
unionid	varchar(32)	YES
nickname	varchar(64)	NO	MUL
avatar_url	varchar(255)	NO
gender	tinyint	NO		0
location	varchar(100)	YES
phone	varchar(255)	NO
password_hash	varchar(255)	YES
following_count	int unsigned	NO		0
follower_count	int unsigned	NO		0
experience_points	int	NO		0
segment	int unsigned	NO		0
status	tinyint	NO	MUL	0
created_at	varchar(255)	YES
last_active	varchar(255)	YES
can_create_club	tinyint	NO		0
permission_group_id	int unsigned	YES	MUL
is_referee	tinyint	NO		0

表: video_comment_likes

字段名	类型	是否为空	键
comment_id	bigint unsigned	NO	PRI
user_id	bigint unsigned	NO	PRI
created_at	int	NO

表: video_comments

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
video_id	bigint unsigned	NO	MUL
user_id	bigint unsigned	NO	MUL
parent_id	bigint unsigned	YES	MUL
content	varchar(500)	NO
ip_region	varchar(64)	NO
created_at	int	NO

表: video_favorites

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
user_id	bigint unsigned	NO	MUL
video_id	bigint unsigned	NO	MUL
created_at	int	NO

表: video_hot_locations

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
name	varchar(120)	NO
latitude	decimal(10,7)	YES
longitude	decimal(11,8)	YES
sort_order	int	NO		0
status	tinyint	NO	MUL	1
created_at	int	NO
updated_at	int	NO

表: video_referee_requests

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
video_id	bigint unsigned	NO	MUL
requester_user_id	bigint unsigned	NO
referee_user_id	bigint unsigned	NO	MUL
status	tinyint	NO		0
created_at	int	NO
updated_at	int	NO

表: video_tags

字段名	类型	是否为空	键
video_id	bigint unsigned	NO	PRI
tag_id	bigint unsigned	NO	PRI
created_at	int	NO

表: video_tags_dict

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
slug	varchar(64)	NO	UNI
name	varchar(64)	NO
use_count	int unsigned	NO	MUL	0
is_hot	tinyint	NO		0
hot_sort	int	NO		0
created_at	int	NO

表: video_votes

字段名	类型	是否为空	键	额外
id	bigint unsigned	NO	PRI	auto_increment
video_id	bigint unsigned	NO	MUL
user_id	bigint unsigned	NO	MUL
vote_type	tinyint	NO
created_at	int	NO
updated_at	int	NO

表: videos

字段名	类型	是否为空	键	默认值	额外
id	bigint unsigned	NO	PRI		auto_increment
user_id	bigint unsigned	NO	MUL
season_id	int unsigned	YES	MUL
challenge_referee_status	tinyint	NO		0
challenge_referee_user_id	bigint unsigned	YES
challenge_referee_at	int	YES
title	varchar(120)	NO
description	varchar(500)	NO
file_id	varchar(255)	NO
cover_file_id	varchar(255)	YES
location_id	bigint unsigned	YES	MUL
map_latitude	decimal(10,7)	YES
map_longitude	decimal(11,8)	YES
map_poi_name	varchar(200)	YES
map_address	varchar(500)	YES
status	tinyint	NO	MUL	1
arena_only	tinyint	NO		0
play_count	int unsigned	NO		0
created_at	int	NO
updated_at	int	NO
pinned_at	int	NO		0
publisher_ip	varchar(45)	YES