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