E1I6-Notionable

Tables (13)

Answer (답변)

  • answer_id (답변id) — Long — Primary key — NOT NULL
  • inquiry_id (문의id2) — Long — Foreign key → Inquiry.inquiry_id — NOT NULL
  • user_id (유저id2) — Long — Foreign key → Inquiry.user_id — NOT NULL
  • creator_id (크리에이터id2) — Foreign key → Inquiry.creator_id — NOT NULL
  • creator_id (크리에이터id3) — Long — Foreign key → Creator.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → Inquiry.id — NOT NULL
  • title (제목) — String
  • content (답변 내용) — String
  • created_at (작성 시간) — LocalDateTime
  • file_url (파일) — String
  • status (답변 유무) — String
  • creator_id (크리에이터id) — Long
  • inquiry_id (문의id) — Long
  • template_id (템플릿id) — Long

Cart (장바구니)

  • item_id (장바구니 아이템id) — Long — Primary key — NOT NULL
  • user_id (유저id) — Long — Foreign key → User.user_id — NOT NULL
  • creator_id (크리에이터id) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL
  • thumbnail (템플릿 썸네일) — String
  • creator (크리에이터) — String
  • attribute (속성(추천, 인기 등)) — String
  • template_url (템플릿 이동 링크) — String
  • Price (템플릿 가격) — Integer
  • title (템플릿 제목) — String

Community (커뮤니티)

  • community_id (게시글 id) — Long — Primary key — NOT NULL
  • user_id (게시글 생성 유저id) — Long — Foreign key → User.user_id — NOT NULL
  • creator_id (크리에이터id) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL
  • category (게시글 카테고리) — Long
  • title (제목) — String
  • content (게시글 내용) — String
  • community_like (좋아요 수) — Long
  • community_comment (댓글 수) — Long
  • thumbnail (썸네일) — String
  • {images} (이미지 파일들) — List<String>

CommunityComment (커뮤니티댓글)

  • community_comment_id (댓글 id) — Long — Primary key — NOT NULL
  • user_id (댓글 생성 유저id) — Long — Foreign key → User.user_id — NOT NULL
  • community_id (게시글 id) — Long — Foreign key → Community.user_id — NOT NULL
  • creator_id (크리에이터id) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL
  • content (댓글 내용) — String

CommunityLike (커뮤니티좋아요)

  • comment_id (댓글 id) — Long — Primary key — NOT NULL
  • user_id (댓글 생성 유저id) — Long — Foreign key → User.user_id — NOT NULL
  • community_id (게시글 id) — Long — Foreign key → Community.community_id — NOT NULL
  • creator_id (크리에이터id) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL

CommunityReply (커뮤니티 대댓글)

  • comment_reply_id (대댓글 id) — Long — Primary key — NOT NULL
  • user_id (대댓글 생성 유저id) — Long — Foreign key → User.user_id — NOT NULL
  • community_comment_id (댓글 id) — Long — Foreign key → CommunityComment.community_comment_id — NOT NULL
  • creator_id (크리에이터id) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL
  • content (대댓글 내용) — String

Creator (크리에이터)

  • creator_id (크리에이터id) — Long — Primary key — NOT NULL
  • creator_type (입점 형태) — String
  • bank (은행) — String
  • account_number (계좌번호) — String
  • bank_paper (통장 사본) — String
  • identification (신분증 사본) — String
  • status (상태(수락, 거절, 대기)) — String
  • role (권한) — enum

Inquiry (문의)

  • inquiry_id (문의id) — Long — Primary key — NOT NULL
  • user_id (유저id2) — Long — Foreign key → User.user_id — NOT NULL
  • creator_id (크리에이터id2) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL
  • title (제목) — String
  • content (문의 내용) — String
  • file_url (파일) — String
  • created_at (작성 시간) — LocalDateTime
  • status (답변 유무) — String
  • creator_id (크리에이터id) — Long
  • user_id (유저id) — Long
  • template_id (템플릿id) — Long

Payment (결제내역)

  • paymentKey (결제ID) — String — Primary key — NOT NULL
  • user_id (유저id) — Long — Foreign key → User.user_id — NOT NULL
  • creator_id (크리에이터id) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL
  • buyer_id (구매자id) — Long
  • seller_id (판매자id) — Long
  • template_id (템플릿id) — Long
  • title (제목) — String
  • thumbnail (썸네일) — String
  • creator_name (크리에이터 이름) — String
  • price (가격) — Long
  • approved_at (적용 시간)

Review (템플릿 리뷰)

  • review_id (리뷰 id) — Long — Primary key — NOT NULL
  • template_id (템플릿id) — Long — Foreign key → Template.template_id — NOT NULL
  • user_id (템플릿 생성 유저id) — Long — Foreign key → Template.user_id — NOT NULL
  • user_id (리뷰 생성 유저id2) — Long — Foreign key → User.user_id — NOT NULL
  • creator_id (크리에이터id) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL
  • rate (만족평가) — String
  • content (내용) — String
  • {images} (이미지 파일들) — List<String>

Template (노션 템플릿)

  • template_id (템플릿id) — Long — Primary key — NOT NULL
  • user_id (유저id) — Long — Foreign key → User.user_id — NOT NULL
  • creator_id (크리에이터id) — Foreign key → User.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → User.id — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • thumbnail (썸네일) — String
  • category (카테고리) — String
  • price (가격) — Integer
  • notion_url (노션 링크) — String
  • good_rate_count (만족 댓글 수) — Integer
  • {images} (이미지 파일들) — List<String>

User (유저)

  • user_id (유저id) — Long — Primary key — NOT NULL
  • creator_id (크리에이터id) — Foreign key → Creator.creator_id — NOT NULL
  • id (인증코드id) — Long — Foreign key → user_sms_auth.id — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • user_type (회원 유형) — Integer
  • role (권한) — enum
  • nickname (닉네임) — String
  • profile (프로필) — String
  • phone_number (전화번호) — String

user_sms_auth (이메일 인증코드)

  • id (인증코드id) — Long — Primary key — NOT NULL
  • auth_code (인증코드) — String
  • phone_number (전화번호) — String