zz
Tables (12)
image
- id — BIGINT
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- extension — VARCHAR(30)
- uuid — VARCHAR(50)
- name — VARCHAR(255)
member
- id — BIGINT
- coin — INTEGER
- sms_agree — BOOLEAN
- state — SMALLINT
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- profile_id — BIGINT
- role_id — BIGINT
- phone_number — VARCHAR(15)
- kakao_id — VARCHAR(50)
message
- id — BIGINT
- send_type — INTEGER
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- receiver_id — BIGINT
- sender_id — BIGINT
- content — VARCHAR(255)
mood
- mood_id — BIGINT
- mood_image_id — BIGINT
- artist — VARCHAR(255)
- title — VARCHAR(255)
music
- music_id — BIGINT
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- profile_id — BIGINT
- artist — VARCHAR(255)
- title — VARCHAR(255)
- video_id — VARCHAR(255)
profile
- profile_id — BIGINT
- is_profile_complete — BOOLEAN
- latitude — DOUBLE
- longitude — DOUBLE
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- mood_id — BIGINT
- profile_image_id — BIGINT
- name — VARCHAR(15)
- one_line_introduction — VARCHAR(50)
- likeable_music_taste — VARCHAR(500)
- self_introduction — VARCHAR(500)
- birth_date — VARCHAR(255)
- gender — VARCHAR(255)
- mbti — VARCHAR(255)
profile_like
- profile_like_id — BIGINT
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- liked_profile_id — BIGINT
- member — BIGINT
profile_tag
- profile_tag_id — BIGINT
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- profile_id — BIGINT
- tag_id — BIGINT
- state — VARCHAR(255)
profile_unlock
- profile_unlock_id — BIGINT
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- viewed_profile_id — BIGINT
- viewer_profile_id — BIGINT
role
- id — BIGINT
- created_date — TIMESTAMP(6)
- modified_date — TIMESTAMP(6)
- name — VARCHAR(255)
tag
- tag_id — BIGINT
- name — VARCHAR(20)
- type — VARCHAR(255)
term
- id — BIGINT
- created_date — DATE
- version — BIGINT
- type — VARCHAR(255)
- content — TEXT