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