giddy_backend

Tables (27)

T_admin (Untitled18)

  • id (Key) — bigint — Primary key — NOT NULL
  • account_id (Field) — varchar(30)
  • password (Field2) — varchar(255)
  • department (Field3) — varchar(30)
  • state (Field4) — varchar(30)
  • date_created (Field5) — timestamptz
  • date_updated (Field6) — timestamptz

T_alert_message (Untitled20)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • message (Field) — varchar(255)
  • read_yn (Field4) — varchar(1)
  • ignored_yn (Field5) — varchar(1)
  • date_created (Field2) — timestamptz — 구현에 따라 불필요할 수 있음
  • date_sent (Field3) — timestamptz — 구현에 따라 불필요할 수 있음
  • alert_category (Field6) — varchar(30)

T_contact _us (Untitled13)

  • id (Key) — bigint — Primary key — NOT NULL
  • first_name (Field) — varchar(30)
  • email (Field2) — varchar(255)
  • message (Field3) — text
  • reply_yn (Field4) — varchar(1)
  • reply_message (Field5) — text
  • date_created (Field6) — timestamptz
  • Field7 — timestamptz

T_matches (Untitled14)

  • id (Key) — bigint — Primary key — NOT NULL
  • unmatched_reason_id (Key4) — varchar(10) — Foreign key → t_meta_unmatch_reason.id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • subject_user_id (Key3) — bigint — Foreign key → T_user.id — NOT NULL
  • state (Field) — varchar(10)
  • date_created (Field3) — timestamptz
  • deleted_yn (Field2) — varhar(1)
  • date_updated (Field5) — timestamptz
  • date_deleted (Field6) — timestamptz
  • pair_matches_id (Field4) — bigint
  • read_yn (Field7) — varhar(1)
  • show_match_yn (Field8) — varhar(1)

T_meta_communication_style (Untitled8)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • value (Field) — varchar(50)
  • Field2 — integer

T_meta_date_intentions (Untitled10)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • value (Field) — varchar(50)
  • order_index (Field2) — integer

T_meta_family_plan (Untitled9)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • value (Field) — varchar(50)
  • order_index (Field2) — integer

T_meta_leave_reason (Untitled7)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • value (Field) — varchar(50)
  • order_index (Field2) — integer

T_meta_prompt (Untitled11)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • value (Field) — varchar(50)

T_meta_report_reason (Untitled12)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • value (Field) — varchar(50)
  • order_index (Field2) — integer

T_profile_image (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • url (Field) — text
  • main_profile_yn (Field2) — varchar(1)
  • date_created (Field3) — timestamptz
  • date_updated (Field4) — timestamptz
  • image_order (Field5) — smallint

T_report (Untitled15)

  • id (Key) — bigint — Primary key — NOT NULL
  • report_reason_id (Key4) — varchar(10) — Foreign key → T_meta_report_reason.id — NOT NULL
  • user_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • reported_user_id (Key3) — bigint — Foreign key → T_user.id — NOT NULL
  • date_reported (Field) — timestamptz
  • detail_reason (Field2) — varchar(255)

T_user (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • phone_number (Field) — varchar(20)
  • verified_yn (Field3) — varchar(1)
  • state (Field6) — varchar(10)
  • email (Field8) — varchar(255)
  • date_verified (Field16) — timestamptz
  • date_updated (Field17) — timestamptz
  • date_last_logged_in (Field5) — timestamptz
  • date_created (Field7) — timestamptz
  • social_token (Field2) — varchar(255)
  • expired_yn (Field9) — varchar(1)
  • social_token_type (Field10) — varchar(30)

T_user_option (Untitled6)

  • user_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • notice_conversation_yn (Field) — varchar(1)
  • notice_new_matches_yn (Field2) — varchar(1)
  • notice_promotions_yn (Field3) — varchar(1)
  • terms_third_party_yn (Field4) — varchar(1)
  • connection_instagram_yn (Field6) — varchar(1)
  • connection_facebook_yn (Field7) — varchar(1)
  • connection_apple_yn (Field8) — varchar(1)
  • leave_reason_id (Key3) — varchar(10) — Foreign key → T_meta_leave_reason.id — NOT NULL
  • date_updated (Field5) — timestamptz

T_user_profile (Untitled4)

  • user_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • firstName (Field) — varchar(30)
  • lastName (Field2) — varchar(30)
  • gender (Field23) — varchar(30)
  • birth_date (Field3) — timestamptz
  • location_latitude (Field4) — double
  • location_longitude (Field5) — double
  • height (Field6) — double
  • workplace (Field8) — varchar(30)
  • job_title (Field9) — varchar(30
  • first_communication_style_id (Key3) — varchar(10) — Foreign key → T_meta_communication_style.id — NOT NULL
  • second_communication_style_id (Key4) — varchar(10) — Foreign key → T_meta_communication_style.id — NOT NULL
  • familiy_plan_id (Key5) — varchar(10) — Foreign key → T_meta_family_plan.id — NOT NULL
  • relationship_id (Key7) — varchar(10) — Foreign key → T_meta_date_intentions.id — NOT NULL
  • school (Field10) — varchar(30)
  • visible_gender_yn (Field11) — varchar(1)
  • visible_height_yn (Field12) — varchar(1)
  • visible_ethnicity_yn (Field13) — varchar(1)
  • visible_relationship_yn (Field14) — varchar(1)
  • visible_communication_style_yn (Field15) — varchar(1)
  • visible_preference_family_plan_yn (Field16) — varchar(1)
  • visible_work_yn (Field17) — varchar(1)
  • visible_school_yn (Field18) — varchar(1)
  • preference_family_plan_id (Key6) — varchar(10) — Foreign key → T_meta_family_plan.id — NOT NULL
  • preference_relationship_id (Key8) — varchar(10) — Foreign key → T_meta_date_intentions.id — NOT NULL
  • preference_gender (Field30) — varchar(30)
  • preference_min_age (Field19) — int
  • preference_max_age (Field20) — int
  • preference_min_distance (Field21) — int
  • preference_max_distance (Field22) — int
  • star_sign (Field31) — varchar(10)
  • smoking_yn (Field24) — varchar(1)
  • politics (Field25) — varchar(30)
  • drinking (Field26) — varchar(30)
  • drugs (Field27) — varchar(30)
  • covid_vaccine_yn (Field28) — varchar(1)
  • first_prompt_id (Key9) — varchar(10) — Foreign key → T_meta_prompt.id — NOT NULL
  • first_prompt_answer (Field32) — varchar(255)
  • second_prompt_id (Key10) — varchar(10) — Foreign key → T_meta_prompt.id — NOT NULL
  • second_prompt_answer (Field33) — varchar(255)
  • third_prompt_id (Key11) — varchar(10) — Foreign key → T_meta_prompt.id — NOT NULL
  • third_prompt_answer (Field34) — varchar(255)
  • date_updated (Field29) — timestamptz
  • away_yn (Field7) — varchar(1)
  • Field35

T_verified_image (Untitled17)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • url (Field) — text

t_conversation (Untitled21)

  • id (Key) — bigint — Primary key — NOT NULL
  • requester_id (Key4) — bigint — Foreign key → T_user.id — NOT NULL
  • respondent_id (Key5) — bigint — Foreign key → T_user.id — NOT NULL
  • comment_type (Field3) — varchar(10)
  • profileImageUrl (Field10) — text
  • prompt_id (Key3) — varchar(10) — Foreign key → T_meta_prompt.id — NOT NULL
  • match_id (Key6) — bigint — Foreign key → T_matches.id — NOT NULL
  • state (Field2) — varchar(10)
  • prompt_answer (Field4) — varchar(255)
  • request_comment (Field7) — text
  • date_requested (Field5) — timestamptz
  • date_started (Field6) — timestamptz
  • date_closed (Field) — timestamptz
  • sendbird_url (Field8) — text
  • respond_comment_yn (Field9) — varchar(1)
  • report_yn (Field11) — varchar(1)

t_discover_reject (Untitled22)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • discover_user_id (Key3) — bigint — Foreign key → T_user.id — NOT NULL
  • date_created (Field) — timestamptz

t_like (Untitled19)

  • id (Key) — bigint — Primary key — NOT NULL
  • requester_id (Key2) — bigint — Foreign key → T_user.id — NOT NULL
  • respondent_id (Key3) — bigint — Foreign key → T_user.id — NOT NULL
  • date_created (Field) — timestamptz
  • date_responded (Field2) — timestamptz
  • state (Field3) — varchar(15)
  • liked_yn (Field4) — varchar(1)

t_meta_away_option (Untitled16)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • value (Field) — varchar(150)
  • order_index (Field2) — smallint

t_meta_covid_vaccine (Untitled24)

  • id (Key) — varchar(5) — Primary key — NOT NULL
  • value (Field) — varchar(30)
  • index_order (Field2) — integer

t_meta_ethnicity (Untitled5)

  • id (Key) — varchar(5) — Primary key — NOT NULL
  • value (Field) — varchar(30)
  • order_index (Field2) — integer

t_meta_geo_location (Untitled2)

  • id (Key) — integer — Primary key — NOT NULL
  • string_value (Field) — varchar(255)
  • country_name (Field2) — varchar(50)
  • city_name (Field3) — varcahr(200)
  • city_geometry (Field4) — geometry(Point)
  • state_name (Field5) — varchar(100)
  • state_abbreviation (Field6) — varchar(3)
  • Field7

t_meta_politics (Untitled25)

  • id (Key) — varchar(5) — Primary key — NOT NULL
  • value (Field) — varchar(30)
  • index_order (Field2) — integer

t_meta_religion (Untitled26)

  • id (Key) — varchar(5) — Primary key — NOT NULL
  • value (Field) — varchar(30)
  • index_order (Field2) — integer

t_meta_sexuality (Untitled27)

  • id (Key) — varchar(5) — Primary key — NOT NULL
  • value (Field) — varchar(30)
  • index_order (Field2) — integer

t_meta_unmatch_reason (Untitled23)

  • id (Key) — varchar(10) — Primary key — NOT NULL
  • value (Field) — varchar(50)
  • order_index (Field2) — integer