advanced_project

Tables (24)

accounts_attendance (출석 테이블)

  • id (Field) — bigint — Primary key — NOT NULL
  • attendance_date_list (Field2) — longtext — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL

accounts_blockrecord (차단 기록 테이블)

  • id (Field) — bigint — Primary key — NOT NULL
  • reason (Field2) — varchar(50) — NOT NULL
  • created)at (Field3) — datetime
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
  • block_user_id (유저 id2) — bigint — Foreign key → accounts_user.id — NOT NULL

accounts_failpaymenthistory (상품 구매 실패 기록 테이블)

  • id (Field) — bigint — Primary key — NOT NULL
  • productId (Field2) — varchar(100)
  • phone_type (Field3) — varchar(1) — NOT NULL
  • created_at (Field4) — datetime
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL

accounts_friendrequest (친구 요청 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • status (Field) — varchar(1) — NOT NULL
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime
  • receive_user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
  • send_user_id (유저 id2) — bigint — Foreign key → accounts_user.id — NOT NULL

accounts_group (학급 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • grade (Field) — int — NOT NULL
  • class_num (Field2) — int — NOT NULL
  • school_id (Key2) — bigint — Foreign key → accounts_school.id — NOT NULL

accounts_nearbyschool (가까운 학교를 기록해두기 위한 관계형 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • distance (Field) — double — NOT NULL
  • nearby_school_id (Key2) — bigint — Foreign key → accounts_school.id — NOT NULL
  • school_id (Key3) — bigint — Foreign key → accounts_school.id — NOT NULL

accounts_paymenthistory (구매 기록 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • productId (Field) — carchar(100) — NOT NULL
  • phone_type (Field2) — varchar(1) — NOT NULL
  • created_at (Field3) — datetime
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL

accounts_pointhistory (포인트 기록 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • delta_point (Field) — int — NOT NULL
  • created_at (Field2) — datetime
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL

accounts_school (학교 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • address (Field) — varchar(100) — NOT NULL
  • student_count (Field2) — int — NOT NULL
  • school_type (Field3) — varchar(1) — NOT NULL

accounts_user (유저 테이블)

  • id (유저 id) — bigint — Primary key — NOT NULL
  • is_superuser (Field) — tinyint(1) — NOT NULL
  • is_staff (Field2) — tinyint(1) — NOT NULL
  • gender (Field3) — varchar(1)
  • point (Field4) — int — NOT NULL
  • friend_id_list (Field5) — longtext
  • is_push_on (Field6) — tinyint(1) — NOT NULL
  • created_at (Field7) — datetime(6) — NOT NULL
  • block_user_id_list (Field8) — longtext
  • hide_user_id_list (Field9) — longtext
  • ban_status (Field10) — varchar(2) — NOT NULL
  • report_count (Field11) — int — NOT NULL
  • alarm_count (i) — int
  • panding_chat (Field12) — int
  • pending_votes (Field13) — int
  • group_id (Key2) — int — Foreign key → accounts_group.id

accounts_user_contacts (유저 컨택 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • contacts_count (Field) — int
  • invite_user_id_list (유저 id) — longtext — Foreign key → accounts_user.id — NOT NULL
  • user_id (유저 id2) — bigint — Foreign key → accounts_user.id — NOT NULL

accounts_user_questionrecord (투표 기록 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • status (Field) — varchar(3) — NOT NULL
  • created_at (Field2) — datetime
  • chosen_user_id (Field3) — bigint — NOT NULL
  • question_id (Field4) — bigint — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
  • question_piece_id (Key2) — bigint — Foreign key → polls_questionpiece.id — NOT NULL
  • has_read (Field6) — tinyint(1) — NOT NULL
  • answer_status (Field7) — varchar(1) — NOT NULL
  • answer_updated_at (Field8) — datetime
  • report_count (Field9) — int — NOT NULL
  • opened_times (Field10) — int — NOT NULL

accounts_userwithdraw (탈퇴 기록 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • reason (Field) — varchar(50) — NOT NULL
  • created_at (Field2) — datetime

device_properties (CopyOfCopyOfUntitled2)

  • id (Key) — int — Primary key — NOT NULL
  • device_id (Field) — varchar(255)
  • device_model (Field2) — varchar(255)
  • device_vendor (Field3) — varchar(255)

event_receipts (포인트 이벤트 참여 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • created_at (Field) — datetime
  • event_id (Key2) — bigint — Foreign key → events.id — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
  • plus_point (Field3) — int — NOT NULL

events (포인트 이벤트 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar(200) — NOT NULL
  • plus_point (Field2) — int — NOT NULL
  • event_type (Field3) — varchar(5) — NOT NULL
  • is_expired (Field4) — tinyint(1) — NOT NULL
  • created_at (Field5) — datetime

hackle.hackle_events (CopyOfUntitled2)

  • event_id (Key) — varchar(255) — Primary key — NOT NULL
  • event_datetime (Field) — datetime
  • event_key (Field2) — varchar(255)
  • session_id (Field3) — varchar(255)
  • id (Field4) — varchar(255)
  • item_name (Field5) — varchar(255)
  • page_name (Field6) — varchar(255)
  • friend_count (Field7) — int
  • votes_count (Field8) — int
  • heart_balance (Field9) — int
  • question_id (Field10) — int

hackle.hackle_properties (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • session_id (Field) — varchar(255)
  • user_id (Field2) — varchar(255)
  • language (Field3) — varchar(255)
  • osname (Field4) — varchar(255)
  • osversion (Field5) — varchar(255)
  • versionname (Field6) — varchar(255)
  • device_id (Field7) — varchar(255)

hackle.user_properties (Untitled)

  • user_id (Key) — varchar(255) — Primary key — NOT NULL
  • class (Field) — int
  • gender (Field2) — varchar(10)
  • grade (Field3) — int
  • school_id (Field4) — int

polls_question (질문 데이터 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • question_text (varchar) — varchar(200) — NOT NULL
  • created_at (Field) — datetime

polls_questionpiece (질문 조각)

  • id (Key) — bigint — Primary key — NOT NULL
  • is_voted (Field) — tinyint(1) — NOT NULL
  • created_at (Field2) — datetime
  • question_id (Key2) — bigint — Foreign key → polls_question.id — NOT NULL
  • is_skipped (Field3) — tinyint(1) — NOT NULL

polls_questionreport (질문에 대한 신고기록 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • reason (Field) — longtext — NOT NULL
  • created_at (Field2) — datetime
  • question_id (Key2) — bigint — Foreign key → polls_question.id — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL

polls_questionset (질문 세트 데이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • question_piece_id_list (Key2) — longtext — Foreign key → polls_questionpiece.id — NOT NULL
  • opening_time (Field2) — datetime
  • status (Field) — varchar(1) — NOT NULL
  • created_at (Field3) — datetime
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL

polls_usercadidate (질문 조각에 등장하는 유저들 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • created_at (Field) — datetime
  • question_piece_id (Key2) — bigint — Foreign key → polls_questionpiece.id — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL