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