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