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