Re-Use
Tables (24)
BC_DEAL_LOGS (블록체인 거래 로그)
- 거래로그id (be_deal_log_id) — UUID — Primary key — NOT NULL
- 이벤트타입 (event_type) — VARCHAR(20) — NOT NULL — ENUM(PENDING/IN_DELIVERY/CANCLED/COMPLETED)
- 거래수량 (amount) — BIGINT — NOT NULL
- 구매자 (buyer_id) — UUID
- 판매자 (seller_id) — UUID
- 트랜젝션해시 (escrow_tx_hash) — VARCHAR(70)
- 거래id (deal_id) — UUID — Foreign key → DEALS.거래id — NOT NULL
BC_SHIPPING_LOGS (블록체인 배송 로그)
- 배송로그Id (bc_shipping_log_id) — UUID — Primary key — NOT NULL
- 이벤트타입 (event_type) — VARCHAR(20) — NOT NULL — ENUM(TRANSFER,DEPOSIT/RELEASE/CANCLEESCROW)
- 트랜젝션해시 (ship_tx_hash) — VARCHAR(70) — NOT NULL
- 위치 (place) — VARCHAR(70) — NOT NULL
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 거래id (trade_id) — UUID — Foreign key → DEALS.거래id — NOT NULL
CATEGORIES (카테고리)
- 카테고리id (category_id) — UUID — Primary key — NOT NULL
- 활성화상태 (is_active) — BOOLEAN — NOT NULL
- 카테고리명 (name) — VARCHAR(20) — NOT NULL — ENUM
CHAT_MESSAGES (채팅메시지)
- 메시지id (chat_message_id) — String — Primary key — NOT NULL
- 채팅방Id (chat_room_id) — String — Foreign key → CHAT_ROOMS.채팅방Id — NOT NULL
- 송신자Id (sender_id) — String — Foreign key → USERS.유저Id — NOT NULL — UUID
- 타입 (message_type) — String — NOT NULL — TEXT, IMAGE
- 내용 (message) — String — NOT NULL
- 생성일자 (created_at) — ISODate — NOT NULL
CHAT_ROOMS (채팅방)
- 채팅방Id (chat_room_id) — String — Primary key — NOT NULL
- 게시글id (product_id) — String — Foreign key → POSTS.게시글id — NOT NULL
- 구매자Id (buyer_id) — String — Foreign key → USERS.유저Id — NOT NULL — UUID
- 상태 (room_state) — BOOLEAN — NOT NULL — TRUE:able/FALSE:disabled
- 생성일자 (created_at) — ISODate — NOT NULL
CREDENTIALS (유저 신분증 정보)
- id (credential_id) — UUID — Primary key — NOT NULL
- did 식별자 (did) — VARCHAR(100) — NOT NULL
- 생성일 (created_at) — TIMESTAMP
- 수정일 (updated_at) — TIMESTAMP
- 삭제일 (deleted_at) — TIMESTAMP
- 삭제여부 (is_deleted) — BOOLEAN
- 유저Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
DEALS (거래)
- 거래id (deal_id) — UUID — Primary key — NOT NULL
- 거래유형 (type) — VARCHAR(20) — NOT NULL — ENUM(PARCEL/DIRECT)
- 거래상태 (state) — VARCHAR(20) — NOT NULL — ENUM(PENDING/IN_DELIVERY/CANCLED/COMPLETED)
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 수정일자 (updated_at) — TIMESTAMP
- 거래종료일 (completed_at) — TIMESTAMP
- 거래트랜젝션해시 (trade_tx_hash) — VARCHAR(100) — NOT NULL
- 취소시 취소사유 (reason) — VARCHAR(200)
- 거래신청Id (proposal_id) — UUID — Foreign key → PROPOSALS.id — NOT NULL
FAV_POSTS (관심게시글)
- 관심글Id (fav_post_id) — UUID — Primary key — NOT NULL
- 유저Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
- 게시글id (post_id) — UUID — Foreign key → POSTS.게시글id — NOT NULL
NOTIFICATIONS (푸시알림기록)
- 알림Id (notification_id) — String — Primary key — NOT NULL
- 알림 유형 (noti_type) — String — NOT NULL — ENUM(CHAT, TRADE, SYSTEM)
- 제목 (title) — String
- 내용 (content) — STRING — 알림 본문
- 읽음 여부 (is_read) — BOOLEAN
- 발송일시 (created_at) — ISODate
- 송신경로 (sent_via) — String — ENUM(FB)
- 유저Id (user_id) — String — Foreign key → USERS.유저Id — NOT NULL — UUID
PAYMENTS (결제)
- 결제Id (payment_id) — UUID — Primary key — NOT NULL
- 결제금액 (amount) — BIGINT — NOT NULL
- 결제방법 (method) — VARCHAR(20) — NOT NULL — ENUM
- 결제상태 (pay_state) — VARCHAR(20) — NOT NULL — ENUM
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 수정일자 (updated_at) — TIMESTAMP
- 트랜젝션해시 (pay_tx_hash) — VARCHAR(70)
- 유저Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
POPULAR_WORDS (인기검색어)
- 인기검색어 Id (popular_word_id) — SERIAL — Primary key — NOT NULL
- 검색어 (keyword) — VARCHAR(50) — NOT NULL
- 검색횟수 (count) — BIGINT
- 일자 (date) — DATE — NOT NULL
POSTS (상품)
- 게시글id (post_id) — UUID — Primary key — NOT NULL
- 제목 (title) — VARCHAR(50) — NOT NULL
- 내용 (content) — TEXT — NOT NULL
- 택배거래여부 (is_parcel) — BOOLEAN — NOT NULL
- 직거래여부 (is_direct) — BOOLEAN — NOT NULL
- 직거래위치 (direct_address) — VARCHAR(50)
- 상품상태 (product_state) — VARCHAR(20) — NOT NULL — ENUM
- 거래상태 (trade_state) — VARCHAR(20) — NOT NULL — ENUM(IN_PROGRESS/TRADING/DONE)
- 가격 (price) — BIGINT — NOT NULL
- 조회수 (count) — BIGINT — NOT NULL
- 판매자 (created_by) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
- 수정자 (updated_by) — UUID
- 삭제자 (deleted_by) — UUID
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 수정일자 (updated_at) — TIMESTAMP
- 삭제일자 (deleted_at) — TIMESTAMP
- 삭제여부 (is_deleted) — BOOLEAN — NOT NULL
- 카테고리id (category_id) — UUID — Foreign key → CATEGORIES.카테고리id — NOT NULL
POST_IMAGES (상품 이미지)
- 이미지id (post_image_id) — UUID — Primary key — NOT NULL
- 링크 (image_link) — VARCHAR(200) — NOT NULL
- 생성자 (created_by) — UUID — NOT NULL
- 삭제자 (deleted_by) — UUID
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 삭제일자 (deleted_at) — TIMESTAMP
- 삭제여부 (is_deleted) — BOOLEAN — NOT NULL
- 게시글id (post_id) — UUID — Foreign key → POSTS.게시글id — NOT NULL
PROPOSALS (거래 신청)
- id (proposal_id) — UUID — Primary key — NOT NULL
- 거래방법 (type) — VARCHAR(20) — NOT NULL — PARCEL/DELEIVERY
- 제안가격 (price) — BIGINT — NOT NULL
- 수신주소 (address) — VARCHAR(300) — 택배거래시
- 신청상태 (state) — VARCHAR(50) — NOT NULL — WAIT/ACCEPTED/REJECTED
- 게시글id (post_id) — UUID — Foreign key → POSTS.게시글id — NOT NULL
- 구매자 id (buyer_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
- 생성일 (created_at) — TIMESTAMP — NOT NULL
- 삭제일 (deleted_at) — TIMESTAMP
- 삭제여부 (is_deleted) — BOOLEAN — NOT NULL
RECENT_WORDS (최근검색어)
- 최근검색어Id (recent_word_id) — UUID — Primary key — NOT NULL
- 검색어 (keyword) — VARCHAR(20) — NOT NULL
- 검색일자 (created_at) — TIMESTAMP — NOT NULL
- 유저Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
REPORTS (신고 및 문의)
- 신고Id (report_id) — UUID — Primary key — NOT NULL
- 유형 (report_type) — VARCHAR(20) — NOT NULL — ENUM(REPORT/INQUIRY)
- 대상타입 (target_type) — VARCHAR(20) — NOT NULL — ENUM(CHAT/TRADE/USER/PRODUCT,ETC)
- 대상 (target_id) — UUID
- 제목 (title) — VARCHAR(50) — NOT NULL
- 내용 (content) — TEXT — NOT NULL
- 상태 (answer_state) — BOOLEAN — NOT NULL
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 신고자id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
REPORT_ANSWERS (답변)
- 답변id (report_answer_id) — UUID — Primary key — NOT NULL
- 내용 (content) — TEXT — NOT NULL
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 신고Id (report_id) — UUID — Foreign key → REPORTS.신고Id — NOT NULL
- 답변자Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
REVIEWS (거래후기)
- 리뷰Id (review_id) — UUID — Primary key — NOT NULL
- 거래id (deal_id) — UUID — Foreign key → DEALS.거래id — NOT NULL
- 평점 (point) — BIGINT — NOT NULL
- 후기 (comment) — VARCHAR(100)
- 작성자 (reviewr_id) — UUID — NOT NULL
- 작성자타입 (reviewr_type) — VARCHAR(50) — NOT NULL — BUYER/SELLER
SHIPPING_LOGS (화물 운송 기록)
- 운송기록Id (shipping_log_id) — UUID — Primary key — NOT NULL
- 택배사 (courier_name) — VARCHAR(20)
- 송장 번호 (tracking_number) — VARCHAR(50) — NOT NULL
- 위치 (place) — VARCHAR(50)
- 상태 (shipping_state) — VARCHAR(50)
- 이벤트트랜젝션해시 (event_tx_hash) — VARCHAR(70)
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 거래id (deal_id) — UUID — Foreign key → DEALS.거래id — NOT NULL
USERS (사용자)
- 유저Id (user_id) — UUID — Primary key — NOT NULL — UUID
- 고유식별번호 (ci_hs) — VARCHAR(255) — NOT NULL — unique
- 이름 (username) — VARCHAR(20) — NOT NULL
- 전화번호 (phone_number) — VARCHAR(20) — NOT NULL
- 닉네임 (nickname) — VARCHAR(20) — NOT NULL — unique
- 프로필이미지 (profile_image) — VARCHAR(255)
- 권한 (role) — VARCHAR(20) — NOT NULL — ENUM(MASTER/USER)
- 계좌은행 (bank) — VARCHAR(10) — ENUM(은행타입)
- 계좌번호 (account) — VARCHAR(30)
- 토큰 (token) — BIGINT — NOT NULL
- 제재카운트 (reported_cnt) — BIGINT — NOT NULL
- 생성일자 (created_at) — TIMESTAMP — NOT NULL
- 수정일자 (updated_at) — TIMESTAMP
- 삭제일자 (deleted_at) — TIMESTAMP
- 생성자 (created_by) — UUID — NOT NULL
- 수정자 (updated_by) — UUID
- 삭제자 (deleted_by) — UUID
- 삭제여부 (is_deleted) — BOOLEAN — NOT NULL
USER_CATEGORIES (관심카테고리)
- 유저Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
- 카테고리id (category_id) — UUID — Foreign key → CATEGORIES.카테고리id — NOT NULL
USER_RATINGS (유저평점)
- 유저평점Id (user_rating_id) — UUID — Primary key — NOT NULL
- 완료전게시글 (in_progress_trade) — BIGINT — NOT NULL
- 완료된게시글 (completed_trade) — BIGINT — NOT NULL
- 총점 (total_score) — NUMERIC — NOT NULL
- 평점 (rate_score) — NUMERIC — NOT NULL
- 유저Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
- 수정일자 (updated_at) — TIMESTAMP
- 삭제여부 (is_deleted) — BOOLEAN — NOT NULL
USER_SESSIONS (유저 로그인 기록)
- id (user_session_id) — UUID — Primary key — NOT NULL
- 기기 Id (device_id) — VARCHAR(255) — NOT NULL
- UA 문자열 (user_agent) — TEXT
- 브라우저/OS정보 (platform) — VARCHAR(100)
- 로그인시점 (login_at) — TIMESTAMP — NOT NULL
- 삭제여부 (is_deleted) — BOOLEAN — NOT NULL — 유저 삭제 시 삭제처리
- 유저Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID
WALLETS (사용자 지갑 정보)
- id (wallet_id) — UUID — Primary key — NOT NULL
- 지갑 주소 (address) — VARCHAR(255) — NOT NULL
- 지갑 타입 (type) — VARCHAR(100) — NOT NULL — ENUM
- 플랫폼정보 (platform) — VARCHAR(100) — NOT NULL — ENUM
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 유저Id (user_id) — UUID — Foreign key → USERS.유저Id — NOT NULL — UUID