Dev_Lovble

테이블 (26)

User (Untitled)

  • username (Field)
  • phone (Field2) — str
  • latest_step (Field3)
  • date_of_birth (Field4)
  • agree_required (Field5)
  • fcm_token (Field6)
  • is_active (Field7)
  • is_admin (Field8)
  • device_type (Field9)

결제 내역 (Purchase_History)

  • id (Field) — 기본 키
  • profile (Field2)
  • plan (Field3)
  • requested_at (Field4)
  • pay_result (Field5)
  • start_date (Field6)
  • expired_date (Field7)

결제 상품 (Product)

  • id (Field) — 기본 키
  • name (Field2)
  • price (Field3)
  • product_type (Field4)

구독 (Subscribe)

  • profile (Field)
  • plan (Field2)
  • expired_date (Field3)
  • next_payment (Field4)
  • is_cancel (Field5)
  • free_superlike (Field6)
  • free_boost (Field7)

데이트_필터 (Date_Filter)

  • profile_id (Field7) — 기본 키
  • gender (Field23)
  • age (Field6)
  • active_location_id (Field)
  • resident_location_id (Field4)
  • distance (Field8)
  • pet_category (Field5)
  • pet_sub_category (Field12)
  • pet_about (Field24)
  • height (Field9)
  • mbti (Field10)
  • job (Field11)
  • graduation (Field13)
  • relationship (Field14)
  • contact (Field15)
  • drinking (Field16)
  • smoking (Field17)
  • workout (Field18)
  • family (Field19)
  • constellation (Field20)
  • politic (Field21)
  • religion (Field22)
  • diet (Field2)
  • sleeping (Field3)
  • language (Field25)

매칭기록 (Matching_History)

  • profile (Field)
  • matched_profile (Field2)
  • distance (Field3)
  • is_selected (Field4)
  • matched_date (Field5)
  • mode (Field6)
  • match_type (Field7)

반려동물_미디어 (Pet_Media)

  • profile_id (Field27) — 외래 키 → 반려동물_프로필.profile_id
  • pet_id (Field)
  • media_url (Field2)
  • thumb_url (Field4)
  • order (Field3)
  • media_type (Field5)

반려동물_프로필 (Pet_Profile)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • pet_name (Field2)
  • pet_category (Field)
  • pet_subcategory (Field4)
  • pet_etc (Field5)
  • pet_birth (Field6)
  • pet_gender (Field10)
  • pet_content (Field8)

부스트 사용내역 (Used_Boost)

  • profile (Field)
  • mode (Field2)
  • start (Field3)
  • end (Field4)

부스트&수퍼라이크 (Boost)

  • profile (Field)
  • plan (Field2)
  • count (Field3)
  • is_active (Field4)

상품 (Products)

  • profile (Field)
  • category (Field2)
  • expired_date (Field3)
  • next_payment (Field4)
  • is_cancel (Field5)
  • free_superlike (Field6)
  • free_boost (Field7)

좋아요 (User_Like)

  • liker (Field)
  • receiver (Field2)
  • super_like (Field3)
  • mode (Field4)

질문 (Question)

  • content (Field)
  • is_active (Field2)

질문과답변 (QnA)

  • profile (Field3)
  • questioin (FK)
  • answer (Field2)

친구_필터 (Friend_Filter)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • gender (Field8)
  • age (Field9)
  • active_loction_id (Field10)
  • resident_location_id (Field11)
  • distance (Field12)
  • pet_category (Field6)
  • pet_sub_category (Field7)
  • pet_about (Field22)
  • height (Field13)
  • mbti (Field14)
  • job (Field15)
  • graduation (Field16)
  • contact (Field18)
  • drinking (Field19)
  • smoking (Field20)
  • workout (Field21)
  • family (Field)
  • constellation (Field2)
  • politics (Field3)
  • religion (Field4)
  • diet (Field17)
  • sleeping (Field5)
  • language (Field23)
  • 친구모드에relation필드없음 (Field24)

칭찬보내기 (Compliment)

  • sender_id (Field)
  • receiver_id (Field2)
  • media_id (Field3)
  • content (Field4)

패스 (User_Pass)

  • passer (Field)
  • receiver (Field2)
  • mode (Field3)

프로필 코드 (Profile_Code)

  • pre_code (Field)
  • code (Field2)
  • category (Field3)
  • name (Field4)
  • is_active (Field5)

프로필_가능언어 (Untitled5)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • code (Field2)
  • detail (Field3)

프로필_관심사 (Untitled4)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • code (Field2)
  • detail (Field3)

프로필_기본 (Profile)

  • id (Field27) — 기본 키
  • user (Field) — fk
  • nickname (Field2) — str
  • is_advanced (Field41) — bool
  • birth (Field3) — date
  • birth_time (Field5) — str
  • gender (Field30) — str
  • age (Field4) — int
  • photo_verified (Field8) — bool
  • pet (Field32) — bool
  • likes_count (Field38) — int
  • active_location (Field7) — fk
  • active_log (Field39) — float
  • active_lat (Field40) — float
  • resident_location (Field42) — fk
  • resident_lat (Field43) — float
  • resident_log (Field6) — float
  • height (Field12) — int
  • mbti (Field9) — str
  • job (Field10) — fk
  • graduation (Field11) — fk
  • contact (Field13) — fk
  • drinking (Field14) — fk
  • smoking (Field15) — fk
  • workout (Field16) — fk
  • family (Field17) — fk
  • constellation (Field18) — fk
  • politics (Field19) — fk
  • religion (Field20) — fk
  • company_name (Field23) — str
  • conmapy_title (Field24) — str
  • school_name (Field25) — str
  • diet (Field28) — str
  • sleeping (Field29) — str
  • is_new (Field22) — bool
  • latest_access (Field34) — bool
  • activity_score (Field45) — int
  • popularity_score (Field46) — int
  • progress (Field47) — float

프로필_나의성격 (CopyOfUntitled3)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • code (Field2)
  • detail (Field4)

프로필_데이트 (Profile_Adopt)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • content (Field8)
  • question (Field)
  • greeting (Field2)
  • relationship (Field3)

프로필_미디어 (Profile_Media)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • media_url (Field2)
  • file_name (Field3)
  • thumb_url (Field5)
  • order (Field4)
  • media_type (Field)

프로필_선호스타일 (Untitled6)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • code (Field2)
  • detail (Field3)

프로필_친구 (Profile_Friend)

  • profile_id (Field27) — 외래 키 → 프로필_기본.id
  • content (Field8)
  • greeting (Field2)
  • relationship (Field3)