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