Nuritopia-ERD
Tables (28)
clan_activity_history
- clan_id — varchar(50) — Foreign key → clans.clan_id — NOT NULL
- activity_id — int — Foreign key → clan_activity_list.activity_id — NOT NULL
- progress_count — int — NOT NULL
- complete_count — int — NOT NULL
- is_completed — tinyint(1) — NOT NULL
- update_time — datetime — NOT NULL
clan_activity_list
- activity_id — int — Primary key — NOT NULL
- reward_item_id — int — NOT NULL
- complete_count — int — NOT NULL
clan_activity_reward_history
- clan_id — varchar(50) — Foreign key → clans.clan_id — NOT NULL
- activity_id — int — Foreign key → clan_activity_list.activity_id — NOT NULL
- member_id — varchar(50) — NOT NULL
- create_time — datetime — NOT NULL
clan_member_list
- member_id — varchar(40) — Primary key — NOT NULL
- clan_id — varchar(50) — Foreign key → clans.clan_id — NOT NULL
- member_name — text — NOT NULL
- member_nickname — text — NOT NULL
- member_position — int
- create_time — datetime — NOT NULL
clan_member_waiting_list
- member_id — varchar(40) — Primary key — NOT NULL
- clan_id — varchar(50) — Foreign key → clans.clan_id — NOT NULL
- member_name — text — NOT NULL
- member_nickname — text — NOT NULL
- create_time — datetime — NOT NULL
clans
- clan_id — varchar(50) — Primary key — NOT NULL
- clan_name — varchar(100) — NOT NULL
- clan_introduction — text — NOT NULL
- clan_icon — int — NOT NULL
- public_type — int — NOT NULL
- approval_type — int — NOT NULL
- max_member_count — int
receive_mail
- mail_id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — NOT NULL
- sender_id — varchar(40) — NOT NULL
- sender_name — text — NOT NULL
- mail_type — int — NOT NULL
- subject — text — NOT NULL
- content — text — NOT NULL
- item_id — text
- item_count — int — NOT NULL
- money_amount — int — NOT NULL
- is_read — tinyint(1) — NOT NULL
- is_item_achieved — tinyint(1) — NOT NULL
- is_money_achieved — tinyint(1) — NOT NULL
- is_deleteable — tinyint(1) — NOT NULL
- is_express — tinyint(1) — NOT NULL
- create_time — datetime — NOT NULL
- limit_day — int — NOT NULL
- INDEX — userIndex
send_mail
- mail_id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — NOT NULL
- receiver_id — varchar(40) — NOT NULL
- receiver_name — text — NOT NULL
- mail_type — int — NOT NULL
- subject — text — NOT NULL
- content — text — NOT NULL
- item_id — text
- item_count — int — NOT NULL
- money_amount — int — NOT NULL
- is_express — tinyint(1) — NOT NULL
- create_time — datetime — NOT NULL
uesrs (users...)
- id — varchar(40) — Primary key — NOT NULL
- username — varchar(128) — NOT NULL
- display_name — varchar(255)
- avatar_url — varchar(512)
- lang_tag — varchar(18) — NOT NULL
- location — varchar(255)
- timezone — varchar(255)
- metadata — json
- wallet — json
- email — varchar(255)
- password — varbinary(32000)
- facebook_id — varchar(128)
- google_id — varchar(128)
- gamecenter_id — varchar(128)
- steam_id — varchar(128)
- custom_id — varchar(128)
- edge_count — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- verify_time — datetime — NOT NULL
- disable_time — datetime — NOT NULL
- apple_id — varchar(128)
user_costume
- userid — varchar(40) — Primary key — NOT NULL
- gender — int — NOT NULL
- skin — int — NOT NULL
- face — int — NOT NULL
- eye — int — NOT NULL
- eye_brow — int — NOT NULL
- hair — int — NOT NULL
- chest — int — NOT NULL
- pants — int — NOT NULL
- feet — int — NOT NULL
- beard — int — NOT NULL
- face_deco — int — NOT NULL
- nose — int — NOT NULL
- earring — int — NOT NULL
- hat — int — NOT NULL
- glasses — int — NOT NULL
- chest_deco — int — NOT NULL
- bag — int — NOT NULL
- hands — int — NOT NULL
- handcarry — int — NOT NULL
user_costume_inventory
- user_id — varchar(40) — Primary key — NOT NULL
- item_id — varchar(100) — Primary key — NOT NULL
- item_count — int
user_edge
- source_id — varchar(40) — Primary key — NOT NULL
- state — smallint — Primary key — NOT NULL
- position — bigint — Primary key — NOT NULL
- update_time — datetime — NOT NULL
- destination_id — varchar(40) — NOT NULL
- friend_nickname — varchar(100) — NOT NULL
user_money
- user_id — varchar(40) — Primary key — NOT NULL
- cash_money — int — NOT NULL
- game_money — int — NOT NULL
user_money_record
- user_id — varchar(40) — Foreign key — NOT NULL
- is_cash — tinyint(1) — NOT NULL
- before — int — NOT NULL
- delta — int — NOT NULL
- reason — int — NOT NULL
- param1 — varchar(40) — NOT NULL
- param2 — varchar(40) — NOT NULL
- time — datetime — NOT NULL
users (users..)
- id — varchar(40) — Primary key — NOT NULL
- username — varchar(128) — NOT NULL
- display_name — varchar(255)
- avatar_url — varchar(512)
- lang_tag — varchar(18) — NOT NULL
- location — varchar(255)
- timezone — varchar(255)
- metadata — json
- wallet — json
- email — varchar(255)
- password — varbinary(32000)
- facebook_id — varchar(128)
- google_id — varchar(128)
- gamecenter_id — varchar(128)
- steam_id — varchar(128)
- custom_id — varchar(128)
- edge_count — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- verify_time — datetime — NOT NULL
- disable_time — datetime — NOT NULL
- apple_id — varchar(128)
users (users.)
- id — varchar(40) — Primary key — NOT NULL
- username — varchar(128) — NOT NULL
- display_name — varchar(255)
- avatar_url — varchar(512)
- lang_tag — varchar(18) — NOT NULL
- location — varchar(255)
- timezone — varchar(255)
- metadata — json
- wallet — json
- email — varchar(255)
- password — varbinary(32000)
- facebook_id — varchar(128)
- google_id — varchar(128)
- gamecenter_id — varchar(128)
- steam_id — varchar(128)
- custom_id — varchar(128)
- edge_count — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- verify_time — datetime — NOT NULL
- disable_time — datetime — NOT NULL
- apple_id — varchar(128)
users (CopyOfusers)
- id — varchar(40) — Primary key — NOT NULL
- username — varchar(128) — NOT NULL
- display_name — varchar(255)
- avatar_url — varchar(512)
- lang_tag — varchar(18) — NOT NULL
- location — varchar(255)
- timezone — varchar(255)
- metadata — json
- wallet — json
- email — varchar(255)
- password — varbinary(32000)
- facebook_id — varchar(128)
- google_id — varchar(128)
- gamecenter_id — varchar(128)
- steam_id — varchar(128)
- custom_id — varchar(128)
- edge_count — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- verify_time — datetime — NOT NULL
- disable_time — datetime — NOT NULL
- apple_id — varchar(128)
users
- id — varchar(40) — Primary key — NOT NULL
- username — varchar(128) — NOT NULL
- display_name — varchar(255)
- avatar_url — varchar(512)
- lang_tag — varchar(18) — NOT NULL
- location — varchar(255)
- timezone — varchar(255)
- metadata — json
- wallet — json
- email — varchar(255)
- password — varbinary(32000)
- facebook_id — varchar(128)
- google_id — varchar(128)
- gamecenter_id — varchar(128)
- steam_id — varchar(128)
- custom_id — varchar(128)
- edge_count — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- verify_time — datetime — NOT NULL
- disable_time — datetime — NOT NULL
- apple_id — varchar(128)
users, clan_member_list
- id — varchar(40) — Foreign key → users.id — NOT NULL
- member_id — varchar(40) — Foreign key → clan_member_list.member_id — NOT NULL
users, clan_member_waiting_list
- id — varchar(40) — Foreign key → users.id — NOT NULL
- member_id — varchar(40) — Foreign key → clan_member_waiting_list.member_id — NOT NULL
users, costume (users-user_costume)
- id — varchar(40) — Foreign key → users.id — NOT NULL
- userid — varchar(40) — Foreign key → user_costume.userid — NOT NULL
users, receive_mail
- id — varchar(40) — Foreign key → users.id — NOT NULL
- user_id — varchar(40) — Foreign key → receive_mail.mail_id — NOT NULL
users, send_mail
- id — varchar(40) — Foreign key → users.id — NOT NULL
- user_id — varchar(40) — Foreign key → send_mail.mail_id — NOT NULL
users, user_costume_inventory
- id — varchar(40) — Foreign key → users.id — NOT NULL
- user_id — varchar(40) — Foreign key → user_costume_inventory.user_id — NOT NULL
users, user_edge
- id — varchar(40) — Foreign key → uesrs.id — NOT NULL
- source_id — varchar(40) — Foreign key → user_edge.source_id — NOT NULL
users, user_money
- id — varchar(40) — Foreign key → users.id — NOT NULL
- user_id — varchar(40) — Foreign key → user_money.user_id — NOT NULL
users, user_money_record
- id — varchar(40) — Foreign key → users.id — NOT NULL
userstate
- userid — varchar(60) — Primary key — NOT NULL
- currentstate — int
- updatetime — timestamp