Duett

Tables (12)

image

  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • extension — character — NOT NULL
  • uuid — character — NOT NULL
  • name — character — NOT NULL

member

  • coin — integer — NOT NULL
  • sms_agree — boolean
  • state — smallint — NOT NULL
  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • profile_id — bigint
  • role_id — bigint — NOT NULL
  • phone_number — character — NOT NULL
  • kakao_id — character — NOT NULL

message

  • send_type — integer — NOT NULL
  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • receiver_id — bigint
  • sender_id — bigint
  • content — character — NOT NULL

mood

  • mood_id — bigint — NOT NULL
  • mood_image_id — bigint
  • artist — character — NOT NULL
  • title — character — NOT NULL

music

  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • music_id — bigint — NOT NULL
  • profile_id — bigint
  • artist — character — NOT NULL
  • title — character — NOT NULL
  • video_id — character — NOT NULL

profile

  • is_profile_complete — boolean — NOT NULL
  • latitude — double
  • longitude — double
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • mood_id — bigint
  • profile_id — bigint — NOT NULL
  • profile_image_id — bigint
  • name — character
  • one_line_introduction — character
  • likeable_music_taste — character
  • self_introduction — character
  • birth_date — character
  • gender — character
  • mbti — character
  • WOMAN::character — varying
  • NONE::character — varying)::text)))
  • ISFJ::character — varying
  • ISTP::character — varying
  • ISTJ::character — varying
  • INFP::character — varying
  • INFJ::character — varying
  • INTP::character — varying
  • INTJ::character — varying
  • ESFP::character — varying
  • ESFJ::character — varying
  • ESTP::character — varying
  • ESTJ::character — varying
  • ENFP::character — varying
  • ENFJ::character — varying
  • ENTP::character — varying
  • ENTJ::character — varying
  • NONE::character — varying)::text)))

profile_like

  • created_date — timestamp(6)
  • liked_profile_id — bigint
  • member — bigint
  • modified_date — timestamp(6)
  • profile_like_id — bigint — NOT NULL

profile_tag

  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • profile_id — bigint
  • profile_tag_id — bigint — NOT NULL
  • tag_id — bigint
  • state — character
  • STANDARD::character — varying
  • FEATURED::character — varying)::text)))

profile_unlock

  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • profile_unlock_id — bigint — NOT NULL
  • viewed_profile_id — bigint
  • viewer_profile_id — bigint

role

  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • name — character — NOT NULL

tag

  • tag_id — bigint — NOT NULL
  • name — character — NOT NULL
  • type — character
  • HOBBY::character — varying)::text)))

term

  • created_date — date
  • id — bigint — NOT NULL
  • version — bigint
  • type — character
  • content — text
  • PRIVACY_POLICY::character — varying)::text)))