Trusta

Tables (36)

CATEGORY (p_category)

  • 카테고리 id (category_id) — BIGINT — Primary key — NOT NULL
  • 카테고리 이름 (name) — VARCHAR
  • 생성일시 (created_at) — TIMESTAMP

PRODUCT (p_product)

  • 상품 고유 id (product_id) — UUID — Primary key — NOT NULL
  • 카테고리 id (category_id2) — BIGINT — Foreign key → CATEGORY.카테고리 id — NOT NULL
  • 판매자 id (seller_id) — BIGINT
  • 카테고리 id (category_id) — BIGINT
  • 제목 (title) — STRING
  • 설명 (description) — TEXT
  • 가격 (price) — BIGINT
  • 등급 (grade) — ENUM
  • 판매상태 (status) — ENUM
  • 조회수 (view_count) — INT
  • 생성일시 (created_at) — TIMESTAMP
  • 수정일시 (updated_at) — TIMESTAMP
  • 삭제일시 (deleted_at) — TIMESTAMP

PRODUCT_IMAGE (p_product_images)

  • 이미지 고유 id (id) — UUID — Primary key — NOT NULL
  • 상품 고유 id (product_id) — UUID — Foreign key → PRODUCT.상품 고유 id — NOT NULL
  • 카테고리 id (category_id2) — BIGINT — Foreign key → PRODUCT.카테고리 id — NOT NULL
  • 이미지 url (image_url) — STRING
  • 대표이미지 여부 (is_thumbnail) — BOOLEAN
  • 이미지 노출 순서 (sort_order) — INT
  • 이미지 업로드 일시 (created_at) — TIMESTAMP

cash_ledger

  • cash_ledger_id — UUID — Primary key — NOT NULL
  • bank_account — VARCHAR(100) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • cash_tx_type — VARCHAR(50) — NOT NULL
  • ref_type — VARCHAR(50) — NOT NULL
  • ref_id — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • idempotency_key — VARCHAR(100) — NOT NULL
  • point_tx_id — UUID

delivery

  • delivery_id — VARCHAR(26) — Primary key
  • order_id — VARCHAR(26)
  • inspection_id — VARCHAR(26)
  • delivery_type — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • sender_id — VARCHAR(26) — NOT NULL
  • sender_info — JSONB — NOT NULL
  • receiver_id — VARCHAR(26) — NOT NULL
  • receiver_info — JSONB — NOT NULL
  • items — JSONB — NOT NULL
  • shipping_fee — INT — NOT NULL
  • fee_bearer — VARCHAR(20) — NOT NULL — SENDER/RECEIVER/PLATFORM
  • carrier — VARCHAR(30) — CJ/HANJIN/LOTTE etc.
  • tracking_number — VARCHAR(50)
  • batch_id — VARCHAR(26)
  • memo — VARCHAR(255)
  • scheduled_at — TIMESTAMPTZ
  • shipped_at — TIMESTAMPTZ
  • delivered_at — TIMESTAMPTZ
  • estimated_arrival — TIMESTAMPTZ
  • cancel_reason — VARCHAR(255)

delivery_batch

  • batch_id — VARCHAR(26) — Primary key — NOT NULL
  • batch_name — VARCHAR(50)
  • batch_type — VARCHAR(20)
  • Field

delivery_history

  • history_id — VARCHAR(26) — Primary key — NOT NULL
  • delivery_id — VARCHAR(26) — Foreign key → delivery.delivery_id
  • from_status — VARCHAR(20)
  • to_status — VARCHAR(20)
  • changed_by — VARCHAR(26)
  • change_source — VARCHAR(20)
  • change_reason — VARCHAR(255)
  • metadata — JSONB
  • changed_at — TIMESTAMPTZ

delivery_tracking

  • tracking_id — VARCHAR(26) — Primary key
  • delivery_id — VARCHAR(26) — Foreign key → delivery.delivery_id
  • tracking_number — VARCHAR(50) — NOT NULL
  • carrier — VARCHAR(30) — NOT NULL
  • event_code — VARCHAR(50) — NOT NULL
  • event_description — VARCHAR(255) — NOT NULL
  • location — VARCHAR(100)
  • event_at — TIMESTAMPTZ — NOT NULL
  • raw_payload — JSONB

inspection

  • inspection_id — VARCHAR(26) — Primary key
  • product_id — VARCHAR(26) — NOT NULL
  • seller_id — VARCHAR(26) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • original_price — BIGINT — NOT NULL
  • suggested_price — BIGINT
  • final_price — BIGINT — S/A/B/C
  • quality_grade — VARCHAR(5)
  • inspector_id — VARCHAR(26)
  • inspection_result — JSONB
  • inspector_note — TEXT
  • reject_reason — TEXT
  • center_received_at — TIMESTAMPTZ
  • inspection_started_at — TIMESTAMPTZ
  • inspection_done_at — TIMESTAMPTZ
  • priced_at — TIMESTAMPTZ
  • seller_decided_at — TIMESTAMPTZ

inspection_history

  • history_id — VARCHAR(26) — Primary key
  • inspection_id — VARCHAR(26) — Foreign key → inspection.inspection_id
  • from_status — VARCHAR(30)
  • to_status — VARCHAR(30) — NOT NULL
  • changed_by — VARCHAR(26)
  • change_reason — VARCHAR(255)
  • metadata — JSONB
  • changed_at — TIMESTAMPTZ — NOT NULL

inspection_outbox

  • outbox_id — VARCHAR(26) — Primary key
  • aggregate_type — VARCHAR(50) — NOT NULL
  • aggregate_id — VARCHAR(26) — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • topic — VARCHAR(100) — NOT NULL
  • payload — JSONB — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • published_at — TIMESTAMPTZ
  • retry_count — INT — NOT NULL
  • last_error — TEXT

inspection_photo

  • photo_id — VARCHAR(26) — Primary key
  • inspection_id — VARCHAR(26) — Foreign key → inspection.inspection_id
  • photo_url — TEXT — NOT NULL
  • photo_type — VARCHAR(20) — NOT NULL
  • display_order — INT — NOT NULL
  • caption — VARCHAR(255)

inspection_pricing_history

  • pricing_history_id — VARCHAR(26) — Primary key
  • inspection_id — VARCHAR(26) — Foreign key → inspection.inspection_id
  • suggested_price — BIGINT — NOT NULL
  • price_reason — TEXT
  • inspector_id — VARCHAR(26) — NOT NULL
  • is_final — BOOLEAN — NOT NULL

order_event_log

  • event_id — BIGSERIAL
  • order_id — BIGINT — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • payload — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL

order_item

  • order_item_id — BIGSERIAL — Primary key
  • order_id — BIGINT — Foreign key → orders.order_id
  • product_id — BIGINT — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • quantity — INT — NOT NULL
  • price — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ
  • updated_by — BIGINT
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT

order_return

  • order_return_id — BIGSERIAL — Primary key
  • order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
  • return_status — VARCHAR(30) — NOT NULL
  • reason — VARCHAR(200)
  • refund_amount — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ
  • updated_by — BIGINT
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT

order_status_history

  • order_status_history_id — BIGINT — Primary key
  • order_id — BIGINT — Foreign key → orders.order_id
  • prev_status — VARCHAR(30) — NOT NULL
  • next_status — VARCHAR(30) — NOT NULL
  • reason — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL

orders

  • order_id — BIGINT — Primary key
  • order_uid — UUID — NOT NULL
  • buyer_id — BIGINT — NOT NULL
  • buyer_name — VARCHAR(100) — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • seller_name — VARCHAR(100) — NOT NULL
  • product_id — BIGINT — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • order_type — VARCHAR(20) — NOT NULL
  • order_status — VARCHAR(30) — NOT NULL
  • total_amount — BIGINT — NOT NULL
  • shipping_fee — INT — NOT NULL
  • version — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ
  • updated_by — BIGINT
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT

payment

  • payment_id — UUID — Primary key — NOT NULL
  • order_id — CHAR(36) — NOT NULL
  • buyer_id — CHAR(36) — NOT NULL
  • payment_status — VARCHAR(30) — NOT NULL
  • amount — BIGINT — NOT NULL
  • version — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — CHAR(36)
  • updated_at — TIMESTAMPTZ
  • updated_by — CHAR(36)

payment_tx

  • payment_tx_id — BIGINT — Primary key — NOT NULL
  • payment_id (payment_id2) — UUID — Foreign key → payment.payment_id — NOT NULL
  • payment_tx_uid — CHAR(36) — NOT NULL
  • payment_id — BIGINT — NOT NULL
  • tx_type — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • amount — BIGINT — NOT NULL
  • pg_tx_id — VARCHAR(100)
  • pg_response_code — VARCHAR(50)
  • pg_response_message — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — CHAR(36) — NOT NULL
  • updated_at — TIMESTAMPTZ
  • updated_by — CHAR(36)

payout

  • payout_id — UUID — Primary key — NOT NULL
  • wallet_id — BIGINT — NOT NULL
  • user_id — CHAR(36) — NOT NULL
  • amount — BIGINT
  • bank_name — VARCHAR(100)
  • account_number — VARCHAR(100) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • completed_at — DATETIME
  • failed_at — DATETIME
  • failure_reason — VARCHAR(255)
  • version — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — CHAR(36) — NOT NULL

pg_payment

  • pg_payment_id — UUID — Primary key — NOT NULL
  • payment_id — BIGINT — NOT NULL
  • refund_id — BIGINT
  • status — VARCHAR(30) — NOT NULL
  • fee_amount — BIGINT — NOT NULL
  • vat_amount — BIGINT — NOT NULL
  • product_price — BIGINT — NOT NULL
  • total_amount — BIGINT — NOT NULL
  • paid_at — DATETIME
  • pg_provider — VARCHAR(50)
  • pg_tx_id — VARCHAR(100)
  • pg_response_message — VARCHAR(255)
  • version — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — CHAR(36)
  • updated_at — TIMESTAMPTZ
  • updated_by — CHAR(36)

pg_reconciliation

  • reconciliation_id — UUID — Primary key — NOT NULL
  • pg_provider — VARCHAR(50) — NOT NULL
  • pg_total_amount — BIGINT — NOT NULL
  • pg_fee_amount — INT — NOT NULL
  • pg_net_amount — BIGINT — NOT NULL
  • expected_total_amount — BIGINT — NOT NULL
  • expected_fee_amount — INT — NOT NULL
  • expected_net_amount — BIGINT — NOT NULL
  • match — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

point_transaction

  • point_tx_id — UUID — Primary key — NOT NULL
  • wallet_id — UUID — Foreign key — NOT NULL
  • ref_id — VARCHAR(100) — NOT NULL
  • ref_type — VARCHAR(50) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • tx_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • idempotency_key — VARCHAR(100) — NOT NULL

refund

  • refund_id — BIGINT — Primary key — NOT NULL
  • payment_id (payment_id2) — UUID — Foreign key → payment.payment_id — NOT NULL
  • refund_uid — CHAR(36) — NOT NULL
  • order_id — CHAR(36) — NOT NULL
  • payment_id — BIGINT — NOT NULL
  • buyer_id — CHAR(36) — NOT NULL
  • refund_type — VARCHAR(20) — NOT NULL
  • amount — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(255)
  • approved_at — DATETIME
  • completed_at — DATETIME
  • version — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — CHAR(36)
  • updated_at — TIMESTAMPTZ
  • updated_by — CHAR(36)

settlement

  • settlement_id — UUID — Primary key
  • cash_in — BIGINT — NOT NULL
  • cash_out — BIGINT — NOT NULL
  • daily_pg_fee — INT — NOT NULL
  • daily_bank_fee — INT — NOT NULL
  • total_cash — BIGINT — NOT NULL
  • pg_fee — INT — NOT NULL
  • bank_fee — INT — NOT NULL
  • total_available_points — BIGINT — NOT NULL
  • total_escrow_points — BIGINT — NOT NULL
  • receivable_amount — BIGINT — NOT NULL
  • revenue — BIGINT — NOT NULL
  • other_revenue — BIGINT — NOT NULL
  • estimated_amount — BIGINT — NOT NULL
  • actual_balance — BIGINT — NOT NULL
  • scheduled_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ — NOT NULL

settlement_adjustment

  • settlement_adjustment_id — UUID — Primary key — NOT NULL
  • settlement_id — UUID — Foreign key → settlement.settlement_id — NOT NULL
  • adjustment_type — VARCHAR(50) — NOT NULL
  • reason — TEXT — NOT NULL
  • amount — INT — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

trust_score

  • trust_score_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.유저 내부 식별자 — NOT NULL
  • score — BIGINT — NOT NULL
  • version — INT — NOT NULL
  • updated_at — TIMESTAMPTZ

user

  • 유저 내부 식별자 (user_id) — BIGINT — Primary key — NOT NULL
  • 유저 외부 노출용 (user_uid) — UUID — NOT NULL
  • 로그인아이디 (username) — VARCHAR(100) — NOT NULL
  • 키클록 아이디 (keycloak_id) — VARCHAR(100)
  • 유저 권한 (role) — user_role — NOT NULL — ADMIN / INSPECTOR/MEMBER
  • 유저 상태 (user_status) — user_status — NOT NULL — PENDING / APPROVED / REJECTED / SUSPENDED
  • 멤버쉽 등금 (membership) — membership_grade — NOT NULL — BRONZE /SILVER /GOLD /PLATINUM
  • 신뢰도 점수 (reputation_score) — BIGINT — NOT NULL
  • 슬랙/ 디스코드 아이디 (slack_id) — VARCHAR(100)
  • 이메일 (email) — VARCHAR(100) — NOT NULL
  • 유저 가입 일자 (created_at) — TIMESTAMPTZ — NOT NULL
  • 유저 권한 변경 시기 (updated_at) — TIMESTAMPTZ
  • 삭제일시 (deleted_at) — TIMESTAMPTZ
  • 삭제자 (deleted_by) — BIGINT
  • 마지막 수정자 (updated_by) — BIGINT
  • 낙관적 락 버전 (version) — INT — NOT NULL

user_account

  • account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • bank_code — VARCHAR(10) — NOT NULL
  • account_number — VARCHAR(100) — NOT NULL
  • account_holder — VARCHAR(50) — NOT NULL
  • account_type — VARCHAR(20) — NOT NULL
  • is_verified — BOOLEAN — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ
  • updated_by — BIGINT
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • Key — Foreign key → user.유저 내부 식별자 — NOT NULL

user_address

  • address_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • recipient_name — VARCHAR(50) — NOT NULL
  • recipient_phone — VARCHAR(20) — NOT NULL
  • zip_code — VARCHAR(10) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • address_detail — VARCHAR(100)
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ
  • updated_by — BIGINT
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • Key — Foreign key → user.유저 내부 식별자 — NOT NULL

user_membership_history

  • membership_history_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • prev_membership — VARCHAR(20) — NOT NULL
  • next_membership — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • Key — Foreign key → user.유저 내부 식별자 — NOT NULL

user_report

  • report_id — BIGINT — Primary key — NOT NULL
  • report_uid — UUID — NOT NULL
  • reported_user_id — BIGINT — Foreign key — NOT NULL
  • reporter_user_id — BIGINT — Foreign key — NOT NULL
  • reason — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING/REVIEWED/DISMISSED
  • reviewed_at — TIMESTAMPTZ
  • reviewed_by — BIGINT
  • Key — Foreign key → user.유저 내부 식별자 — NOT NULL

user_status_history

  • status_history_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • prev_status — VARCHAR(20) — NOT NULL
  • next_status — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • Key — Foreign key → user.유저 내부 식별자 — NOT NULL

user_suspension

  • suspension_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • reason — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • expires_at — TIMESTAMPTZ
  • released_at — TIMESTAMPTZ
  • released_by — BIGINT
  • released_reason — VARCHAR(200)
  • Key — Foreign key → user.유저 내부 식별자 — NOT NULL

wallet

  • Key — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • balance — BIGINT — NOT NULL
  • wallet_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • version — BIGINT