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