bebe
Tables (25)
base_entity (Untitled)
- created_at (Field) — LocalDateTime
- updated_at (Field2) — LocalDateTime
block (차단)
- id (기본키) — Long — Primary key — NOT NULL
- blocker_id (차단자) — Long — Foreign key → member.member_id — NOT NULL
- blocked_id (피차단자) — Long — Foreign key → member.member_id — NOT NULL
category (카테고리)
- Key — Primary key — NOT NULL
- hot_deal_category_id (카테고리_기본키) — Long — Foreign key → hot_deal_category.hot_deal_category_id — NOT NULL
- setting_id (세팅) — Long — Foreign key → user_hotdeal_notification.setting_id — NOT NULL
- name (이름) — String
child (자녀)
- child_id (자녀 기본키) — Long — Primary key — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
- name (이름) — String
- birthday (생일) — LocalDate
communityImage (커뮤니티 이미지)
- Key — Long — Primary key — NOT NULL
- post_id (게시글) — Long — Foreign key → community_posts.post_id — NOT NULL
- img_path (이미지 경로) — String
communityLink (커뮤니티 외부링크)
- Key — Primary key — NOT NULL
- post_id (게시물) — Long — Foreign key → community_posts.post_id — NOT NULL
- link (링크) — String
community_categories (커뮤니티 카테고리)
- category_id (기본키) — Long — Primary key — NOT NULL
- name (카테고리 이름) — String
community_comments (커뮤니티 댓글)
- comment_id (댓글 기본키) — Long — Primary key — NOT NULL
- comment_id (대댓글) — Long — Foreign key → community_comments.comment_id — NOT NULL
- post_id (게시글) — Long — Foreign key → community_posts.post_id — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
- content (내용) — String
- deleted_at (삭제여부) — LocalDateTime
community_post_block (게시물 차단)
- id — Long — Primary key — NOT NULL
- post_id (게시글) — Long — Foreign key → community_posts.post_id — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
community_post_likes (커뮤니티 게시글 좋아요)
- id (커뮤니티_게시글 좋아요_기본키) — Long — Primary key — NOT NULL
- post_id (게시물) — Long — Foreign key → community_posts.post_id — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
community_posts (커뮤니티 게시글)
- post_id (기본키) — Long — Primary key — NOT NULL
- category_id (카테고리) — Long — Foreign key → community_categories.category_id — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
- title (제목) — String — NOT NULL
- content (내용) — String — NOT NULL
- deleted_at (삭제여부) — LocalDateTime
- is_certed (인증여부) — LocalDateTime
- view_count (조회수) — int
- like_count (좋아요수) — int
- comment_count (댓글 수) — int
- is_reported (신고된 게시물) — LocalDateTime
hot_deal (핫딜)
- id (기본키) — Long — Primary key — NOT NULL
- hot_deal_category_id (카테고리) — Long — Foreign key → hot_deal_category.hot_deal_category_id — NOT NULL
- name (이름) — String — NOT NULL
- img_path (이미지 경로) — String
- unit (단위) — Enum
- status (핫딜 상태) — Enum
hot_deal_category (핫딜 카테고리)
- hot_deal_category_id (카테고리_기본키) — Long — Primary key — NOT NULL
- parent_category_id (상위 카테고리) — Long — Foreign key → hot_deal_category.hot_deal_category_id — NOT NULL
- name (카테고리 이름) — String — NOT NULL
- depth (깊이) — int
hot_deal_comments (핫딜 댓글)
- comment_id (댓글_기본키) — Long — Primary key — NOT NULL
- replied_comment_id (대댓글) — Long — Foreign key → hot_deal_comments.comment_id — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
- hotdeal_id (핫딜 게시글) — Long — Foreign key → hot_deal_post.hot_deal_post_id — NOT NULL
- content (내용) — String — NOT NULL
- deleted_at (삭제여부) — LocalDateTime
hot_deal_likes (핫딜 좋아요)
- id (핫딜_좋아요_기본키) — Long — Primary key — NOT NULL
- hotdeal_id (핫딜) — Long — Foreign key → hot_deal_post.hot_deal_post_id — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
hot_deal_post (핫딜 게시글)
- hot_deal_post_id (기본키) — Long — Primary key — NOT NULL
- hot_deal_id (핫딜) — Long — Foreign key → hot_deal.id — NOT NULL
- hot_deal_category_id (카테고리_기본키) — Long — Foreign key → hot_deal_category.hot_deal_category_id — NOT NULL
- title (제목) — String — NOT NULL
- content (내용) — String — NOT NULL
- link (링크) — String
- img_path (이미지 경로) — String
- status (핫딜 상태) — Enum
- age (나이) — Int
- viewCount (조회수) — int
- likeCount (좋아요 수) — int
- deleted_at (삭제여부) — LocalDateTime
- commentCount (댓글 수) — int
hot_deal_record (핫딜 기록)
- id (기본키) — Long — Primary key — NOT NULL
- hot_deal_id (핫딜) — Long — Foreign key → hot_deal.id — NOT NULL
- date (날짜) — LocalDate
- note (비고) — String
- search_price (검색가) — int
- hot_deal_price (핫딜가) — int — NOT NULL
member (멤버)
- member_id (기본키) — Long — Primary key — NOT NULL
- nickname (닉네임) — String — NOT NULL
- email (이메일) — String
- roles (권한) — Enum — NOT NULL
- fcm_token (fcm토큰) — String
- deleted_at (회원탈퇴여부) — LocalDateTime
- role (역할) — String
member_terms_agreements (유저 약관 동의)
- Key — Primary key — NOT NULL
- member_id (기본키) — Long — Foreign key → member.member_id — NOT NULL
- agreement (서비스 이용 약관 동의) — LocalDate — NOT NULL
- private_policy (개인 수집 및 이용 동의) — LocalDate
- age (14세 이상) — BOOLEAN
notification (알림)
- notification_id (알림_기본키) — Long — Primary key — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
- target_body (대상 본문) — String
- body (본문) — String
- type (알림 타입) — Enum
- sender (발신자) — String
oauth2_user_informations
- provider_uid — VARCHAR(100) — Primary key — NOT NULL
- provider_name — VARCHAR(20) — Primary key — NOT NULL
- user_info_id — CHAR(36) — NOT NULL
- email — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
refresh_tokens
- refresh_token — CHAR(36) — Primary key — NOT NULL
- member_id (기본키) — Long — Foreign key → member.member_id — NOT NULL
- user_id — CHAR(36) — NOT NULL
- exp — TIMESTAMP — NOT NULL
reports (게시물 신고)
- id (기본키) — Long — Primary key — NOT NULL
- member_id (멤버) — Long — Foreign key → member.member_id — NOT NULL
- target_id (신고대상) — Long — NOT NULL
- reason (신고사유) — Enum — NOT NULL
- content (내용) — String — NOT NULL
user_hotdeal_notification (핫딜 설정)
- setting_id (key) — Long — Primary key — NOT NULL
- age (나이) — int
- category (핫딜 카테고리) — String
- member_id (기본키) — Long — Foreign key → member.member_id — NOT NULL
- age1 (0세) — int
- age2 (1세) — int
- Field
user_notification_settings (알림설정)
- Key — Primary key — NOT NULL
- member_id (기본키) — Long — Foreign key → member.member_id — NOT NULL
- hot_deal_notification_agreement (핫딜 알림) — BOOLEAN — NOT NULL
- hot_deal_night_notification_agreement (핫딜 야간 알림) — BOOLEAN
- comment_notification_agreement (댓글 알림) — BOOLEAN — NOT NULL
- marketing_notification_agreement (이벤트 알림) — BOOLEAN — NOT NULL
- marketing_night_notification_agreement (이벤트 야간 알림) — BOOLEAN — NOT NULL