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