melly

Tables (12)

tb_comment

  • is_deleted — bit
  • comment_id — bigint
  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • memory_id — bigint
  • parent_id — bigint
  • user_id — bigint
  • content — tinytext — NOT NULL

tb_comment_like

  • comment_id — bigint
  • comment_like_id — bigint
  • user_id — bigint

tb_group_and_user

  • created_date — datetime(6)
  • group_and_user_id — bigint
  • groups_id — bigint
  • last_modified_date — datetime(6)
  • user_id — bigint

tb_keyword

  • created_date — datetime(6)
  • id — bigint
  • last_modified_date — datetime(6)
  • memory_id — bigint
  • content — varchar(255)

tb_memory (메모리)

  • memory_id (메모리ID) — bigint — Primary key — NOT NULL
  • is_deleted (삭제여부) — bit
  • created_date (생성일자) — datetime(6)
  • group_id (그룹ID) — bigint
  • last_modified_date (수정일자) — datetime(6)
  • place_id (장소ID) — bigint
  • stars (평점) — bigint
  • user_id (유저ID) — bigint
  • open_type (공개 범위) — enum
  • title (제목) — varchar(255)
  • content (게시글) — tinytext

tb_memory_image (메모리 이미지)

  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • memory_id — bigint
  • memory_image_id — bigint
  • image_path — varchar(255)

tb_memory_keywords (메모리 키워드)

  • keywords_id — bigint — NOT NULL
  • memory_memory_id — bigint — NOT NULL

tb_notification

  • is_read — bit
  • notification_type — tinyint
  • id — bigint
  • memory_id — bigint
  • notification_date_time — datetime(6)
  • user_id — bigint
  • content — varchar(255)
  • nickname — varchar(255)
  • profile_image — varchar(255)
  • check — (`notification_type` between 0 and 2)

tb_place (장소)

  • is_deleted — bit
  • lat — double
  • lng — double
  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • place_id — bigint
  • place_category — varchar(255)
  • place_image — varchar(255)
  • place_name — varchar(255)

tb_place_scrap (장소 스크랩)

  • created_date — datetime(6)
  • last_modified_date — datetime(6)
  • place_id — bigint
  • place_scrap_id — bigint
  • user_id — bigint
  • scrap_type — enum — NOT NULL

tb_user (유저)

  • user_id (유저ID) — bigint — Primary key — NOT NULL
  • enable_app_push (앱 전체 푸시 동의) — bit
  • enable_comment_like_push (댓글 좋아요 알림 동의) — bit
  • enable_comment_push (댓글 작성 알림 동의) — bit
  • created_date (생성일자) — datetime(6)
  • last_modified_date (수정일자) — datetime(6)
  • age_group (연령대) — enum
  • email (이메일) — varchar(255)
  • gender (성별) — enum
  • nickname (닉네임) — varchar(255)
  • password (비밀번호) — varchar(255)
  • profile_image (프로필이미지 URL) — varchar(255)
  • provider (소셜 로그인 타입) — enum
  • recommend_activity (추천 액티비티) — enum
  • recommend_group (추천 그룹) — enum
  • recommend_place (추천 장소) — enum
  • role_type (권한 종류) — enum
  • social_id (소셜 로그인 ID) — varchar(255)
  • user_status (유저상태) — enum

tb_user_group

  • group_icon — int — NOT NULL
  • is_deleted — bit — NOT NULL
  • created_date — datetime(6)
  • group_id — bigint
  • last_modified_date — datetime(6)
  • version — bigint
  • group_name — varchar(255) — NOT NULL
  • group_type — enum — NOT NULL
  • invite_link — varchar(255)