fdfd

Tables (25)

accounts_attendance

  • id — INT — Primary key — NOT NULL
  • user — INT — Foreign key → accounts_user.id
  • attendance_date_list — TEXT

accounts_blockrecord

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • block_user_id — INT — Foreign key → accounts_user.id
  • reason — VARCHAR(255)
  • created_at — DATETIME

accounts_failpaymenthistory

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • productId — VARCHAR(100)
  • phone_type — VARCHAR(10)
  • created_at — DATETIME

accounts_friendrequest

  • id — INT — Primary key — NOT NULL
  • send_user_id — INT — Foreign key → accounts_user.id
  • receive_user_id — INT — Foreign key → accounts_user.id
  • status — VARCHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

accounts_group

  • id — INT — Primary key — NOT NULL
  • school_id — INT — Foreign key → accounts_school.id
  • grade — INT
  • class_num — INT

accounts_nearbyschool

  • id — INT — Primary key — NOT NULL
  • school_id — INT — Foreign key → accounts_school.id
  • nearby_school_id — INT — Foreign key → accounts_school.id
  • distance — FLOAT

accounts_paymenthistory

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • productId — VARCHAR(100)
  • phone_type — VARCHAR(10)
  • created_at — DATETIME

accounts_pointhistory

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • user_question_record_id — INT — Foreign key → accounts_userquestionrecord.id
  • delta_point — INT
  • created_at — DATETIME

accounts_school

  • id — INT — Primary key — NOT NULL
  • address — VARCHAR(255)
  • school_type — VARCHAR(1)
  • student_count — INT

accounts_timelinereport

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • user_question_record_id — INT — Foreign key → accounts_userquestionrecord.id
  • reported_user_id — INT — Foreign key → accounts_user.id
  • reason — VARCHAR(255)
  • created_at — DATETIME

accounts_user

  • id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → accounts_group.id
  • is_superuser — BOOLEAN
  • is_staff — BOOLEAN
  • firebase_uid — VARCHAR(255)
  • gender — VARCHAR(10)
  • point — INT
  • friend_id_list — TEXT
  • is_push_on — BOOLEAN
  • block_user_id_list — TEXT
  • hide_user_id_list — TEXT
  • ban_status — VARCHAR(20)
  • report_count — INT
  • alarm_count — INT
  • pending_chat — INT
  • pending_votes — INT
  • created_at — DATETIME

accounts_user_contacts

  • id — INT — Primary key — NOT NULL
  • count — INT
  • invite_user_id_list — TEXT
  • user_id — INT — Foreign key → accounts_user.id

accounts_userquestionrecord

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • chosen_user_id — INT — Foreign key → accounts_user.id
  • opened_times — INT
  • status — VARCHAR(1)
  • question_id — INT — Foreign key → polls_question.id
  • question_piece_id — INT — Foreign key → polls_questionpiece.id
  • answer_status — VARCHAR(1)
  • answer_updated_at — DATETIME
  • report_count — INT
  • has_read — BOOLEAN
  • created_at — DATETIME

accounts_userwithdraw

  • id — INT — Primary key — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME

device_properties

  • device_id — VARCHAR(64) — Primary key — NOT NULL
  • device_model — VARCHAR(100)
  • device_vendor — VARCHAR(50)

event_receipts

  • id — INT — Primary key — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME

events

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • plus_point — INT
  • event_type — VARCHAR(50)
  • is_expired — BOOLEAN
  • created_at — DATETIME

hackle_events

  • event_id — VARCHAR(64) — Primary key — NOT NULL
  • event_datetime — DATETIME
  • event_key — VARCHAR(100)
  • session_id — VARCHAR(64) — Foreign key → hackle_properties.session_id
  • item_name — VARCHAR(100)
  • page_name — VARCHAR(100)
  • friend_count — INT
  • votes_count — INT
  • heart_balance — INT
  • question_id — INT

hackle_properties

  • session_id — VARCHAR(64) — Primary key — NOT NULL
  • user_id — INT
  • language — VARCHAR(10)
  • osname — VARCHAR(20)
  • osversion — VARCHAR(20)
  • versionname — VARCHAR(20)
  • device_id — VARCHAR(64) — Foreign key → device_properties.device_id

polls_question

  • id — INT — Primary key — NOT NULL
  • question_text — VARCHAR(500)
  • created_at — DATETIME

polls_questionpiece

  • id — INT — Primary key — NOT NULL
  • question_id — INT — Foreign key → polls_question.id
  • is_voted — BOOLEAN
  • is_skipped — BOOLEAN
  • created_at — DATETIME

polls_questionreport

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • question_id — INT — Foreign key → polls_question.id
  • reason — VARCHAR(255)
  • created_at — DATETIME

polls_questionset

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • question_piece_id_list — TEXT
  • opening_time — DATETIME
  • status — VARCHAR(1)
  • created_at — DATETIME

polls_usercandidate

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → accounts_user.id
  • question_piece_id — INT — Foreign key → polls_questionpiece.id
  • created_at — DATETIME

user_properties

  • class — VARCHAR(10)
  • gender — VARCHAR(10)
  • grade — VARCHAR(10)
  • school_id — INT