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)