11
Tables (25)
accounts_attendance
- id — BIGINT — Primary key — NOT NULL
- attendance_date_list — LONGTEXT — NOT NULL
- user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
accounts_blockrecord
- id — BIGINT — Primary key — NOT NULL
- reason — VARCHAR(50) — NOT NULL
- created_at — DATETIME
- block_user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
- user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
accounts_failpaymenthistory
- id — BIGINT — Primary key — NOT NULL
- productId — VARCHAR(100)
- phone_type — VARCHAR(1) — NOT NULL
- created_at — DATETIME
- user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
accounts_friendrequest
- id — BIGINT — Primary key — NOT NULL
- status — VARCHAR(1) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- receive_user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
- send_user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
accounts_group
- id — BIGINT — Primary key — NOT NULL
- grade — INT — NOT NULL
- class_num — INT — NOT NULL
- school_id — BIGINT — NOT NULL
accounts_nearbyschool
- id — BIGINT — Primary key — NOT NULL
- distance — DOUBLE — NOT NULL
- nearby_school_id — BIGINT — Foreign key → accounts_school.id — NOT NULL
- school_id — BIGINT — Foreign key → accounts_school.id — NOT NULL
accounts_paymenthistory
- id — BIGINT — Primary key — NOT NULL
- productId — VARCHAR(100) — NOT NULL
- phone_type — VARCHAR(1) — NOT NULL
- created_at — DATETIME
- user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
accounts_pointhistory
- id — BIGINT — Primary key — NOT NULL
- delta_point — INT — NOT NULL
- created_at — DATETIME
- user_id — BIGINT — NOT NULL
- user_question_record_id — BIGINT — Foreign key → accounts_userquestionrecord.id
accounts_school
- id — BIGINT — Primary key — NOT NULL
- address — VARCHAR(100) — NOT NULL
- student_count — INT — NOT NULL
- school_type — VARCHAR(1) — NOT NULL
accounts_timelinereport
- id — BIGINT — Primary key — NOT NULL
- reason — VARCHAR(50) — NOT NULL
- created_at — DATETIME
- reported_user_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- user_question_record_id — BIGINT — Foreign key → accounts_userquestionrecord.id — NOT NULL
accounts_user
- id — BIGINT — Primary key — NOT NULL
- is_superuser — TINYINT(1) — NOT NULL
- is_staff — TINYINT(1) — NOT NULL
- gender — VARCHAR(1)
- point — INT — NOT NULL
- friend_id_list — LONGTEXT
- is_push_on — TINYINT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- block_user_id_list — LONGTEXT
- hide_user_id_list — LONGTEXT
- ban_status — VARCHAR(2) — NOT NULL
- report_count — INT — NOT NULL
- alarm_count — INT
- pending_chat — INT
- pending_votes — INT
- group_id — INT
accounts_user_contacts
- id — BIGINT — Primary key — NOT NULL
- contacts_count — INT
- invite_user_id_list — LONGTEXT
- user_id — BIGINT
accounts_userquestionrecord
- id — BIGINT — Primary key — NOT NULL
- status — VARCHAR(3) — NOT NULL
- created_at — DATETIME
- chosen_user_id — BIGINT — NOT NULL
- question_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- question_piece_id — BIGINT — Foreign key → polls_questionpiece.id — NOT NULL
- has_read — TINYINT(1) — NOT NULL
- answer_status — VARCHAR(1) — NOT NULL
- answer_updated_at — DATETIME
- report_count — INT — NOT NULL
- opened_times — INT — NOT NULL
accounts_userwithdraw
- id — BIGINT — Primary key — NOT NULL
- reason — VARCHAR(50) — NOT NULL
- created_at — DATETIME
device_properties
- id — INT — Primary key — NOT NULL
- device_id — VARCHAR(255)
- device_model — VARCHAR(255)
- device_vendor — VARCHAR(255)
event_receipts
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- event_id — BIGINT — Foreign key → events.id
- user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
- plus_point — INT — NOT NULL
events
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- plus_point — INT — NOT NULL
- event_type — VARCHAR(5) — NOT NULL
- is_expired — TINYINT(1) — NOT NULL
- created_at — DATETIME
hackle_events
- event_id — VARCHAR(255) — Primary key — NOT NULL
- event_datetime — DATETIME
- event_key — VARCHAR(255)
- session_id — VARCHAR(255)
- id — VARCHAR(255)
- item_name — VARCHAR(255)
- page_name — VARCHAR(255)
- friend_count — INT
- votes_count — INT
- heart_balance — INT
- question_id — INT
hackle_properties
- id — INT — Primary key — NOT NULL
- session_id — VARCHAR(255)
- user_id — VARCHAR(255)
- language — VARCHAR(255)
- osname — VARCHAR(255)
- osversion — VARCHAR(255)
- versionname — VARCHAR(255)
- device_id — VARCHAR(255)
polls_question
- id — BIGINT — Primary key — NOT NULL
- question_text — VARCHAR(200) — NOT NULL
- created_at — DATETIME
polls_questionpiece
- id — BIGINT — Primary key — NOT NULL
- is_voted — TINYINT(1) — NOT NULL
- created_at — DATETIME
- question_id — BIGINT — NOT NULL
- is_skipped — TINYINT(1) — NOT NULL
polls_questionreport
- id — BIGINT — Primary key — NOT NULL
- reason — LONGTEXT — NOT NULL
- created_at — DATETIME
- question_id — BIGINT — Foreign key → polls_question.id — NOT NULL
- user_id — BIGINT — Foreign key → accounts_user.id — NOT NULL
polls_questionset
- id — BIGINT — Primary key — NOT NULL
- question_piece_id_list — LONGTEXT — NOT NULL
- opening_time — DATETIME
- status — VARCHAR(1) — NOT NULL
- created_at — DATETIME
- user_id — BIGINT — NOT NULL
polls_usercandidate
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- question_piece_id — BIGINT — Foreign key → polls_questionpiece.id — NOT NULL
- user_id — BIGINT — NOT NULL
user_properties
- user_id — VARCHAR(255) — Primary key — NOT NULL
- class — INT
- gender — VARCHAR(10)
- grade — INT
- school_id — INT