zxc
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)))