softeer-main-project

Tables (25)

ADDRESS

  • address_id — uuid — Primary key — NOT NULL
  • address_alias — varchar(50)
  • latitude — decimal(11, 8) — NOT NULL
  • longitude — decimal(11, 8) — NOT NULL
  • address_line_2 — varchar(255) — NOT NULL
  • address_line_1 — varchar(255) — NOT NULL
  • boormi_id — uuid — Foreign key → BOORMI.boormi_id — NOT NULL

BOORMI

  • boormi_id — uuid — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL — unique
  • password — varchar(255) — NOT NULL
  • name — varchar(50) — NOT NULL
  • phone_number — varchar(50) — NOT NULL — unique
  • birthdate — date — NOT NULL
  • user_cd — enum('ACTIVE', 'DELETED', 'RESTRICTED', 'BANNED')
  • is_dreami_activated — boolean
  • is_admin — boolean — NOT NULL
  • created_dtm — timestamp — NOT NULL
  • updated_dtm — timestamp
  • deleted_dtm — timestamp
  • boormi_avg_score — decimal(3, 2) — NOT NULL
  • restricted_dtm — timestamp

BOORMI_REVIEW

  • review_id — uuid — Primary key — NOT NULL
  • score — integer — NOT NULL
  • detail — varchar(200)
  • created_dtm — timestamp — NOT NULL
  • updated_dtm — timestamp
  • deleted_dtm — timestamp
  • order_id — uuid — Foreign key → ORDERS.order_id — NOT NULL

CANCEL

  • cancel_id — uuid — Primary key — NOT NULL
  • canceled_dtm — timestamp — NOT NULL
  • cancel_reason — varchar(50)
  • note — text
  • is_penalty_applied — boolean — NOT NULL
  • canceler_cd — enum('ADMIN', 'BOORMI', 'DREAMI') — NOT NULL
  • order_id — uuid — Foreign key → ORDERS.order_id — NOT NULL

DELIVERY

  • delivery_id — uuid — Primary key — NOT NULL
  • delivery_cd — enum — NOT NULL
  • picked_up_dtm — timestamp
  • delivery_start_dtm — timestamp
  • delivery_end_dtm — timestamp
  • received_dtm — timestamp
  • order_id — uuid — Foreign key → ORDERS.order_id — NOT NULL
  • dreami_id — uuid
  • boormi_id — uuid
  • current_latitude — decimal(11, 8)
  • current_longitude — decimal(11, 8)
  • route_path — text
  • estimated_completion_dtm — timestamp
  • offline_sms_sent_dtm — timestamp

DELIVERY_CERTIFICATION

  • certification_id — uuid — Primary key — NOT NULL
  • delivery_id — uuid — Foreign key → DELIVERY.delivery_id — NOT NULL
  • is_contact — boolean — NOT NULL
  • image_key — varchar(500)
  • sign_key — varchar(500)
  • submitted_dtm — timestamp — NOT NULL

DREAMI

  • dreami_id — uuid — Foreign key → BOORMI.boormi_id — NOT NULL
  • reject_detail — varchar(255)
  • request_dtm — timestamp
  • review_dtm — timestamp
  • request_cd — enum('REQUESTED', 'REVIEWING', 'APPROVED', 'REJECTED') — NOT NULL
  • id_card_key — varchar(500) — NOT NULL
  • dreami_avg_score — decimal(3,2) — NOT NULL
  • criminal_record_key — varchar(500) — NOT NULL

DREAMI_REQUEST_DENIED_DETAILS

  • reject_id — uuid — Primary key — NOT NULL
  • rejected_dtm — timestamp — NOT NULL
  • reject_detail — varchar(200)
  • dreami_id — uuid — Foreign key → DREAMI.dreami_id — NOT NULL

DREAMI_REVIEW

  • review_id — uuid — Primary key — NOT NULL
  • score — integer — NOT NULL
  • content — varchar(200)
  • created_dtm — timestamp — NOT NULL
  • updated_dtm — timestamp
  • deleted_dtm — timestamp
  • order_id — uuid — Foreign key → ORDERS.order_id — NOT NULL

EXCHANGES

  • exchanges_id — uuid — Primary key — NOT NULL
  • amount — bigint — NOT NULL
  • created_dtm — timestamp — NOT NULL
  • point_tx_id — uuid — Foreign key → POINT_TX.point_tx_id — NOT NULL
  • money_tx_id — uuid — Foreign key → MONEY_TX.money_tx_id — NOT NULL
  • wallet_id — uuid — Foreign key → WALLET.wallet_id — NOT NULL

MATCHING

  • matching_id — uuid — Primary key — NOT NULL
  • accepted_dtm — timestamp
  • canceled_dtm — timestamp
  • created_dtm — timestamp — NOT NULL
  • order_id — uuid — Foreign key → ORDERS.order_id — NOT NULL

MONEY_LEDGERS

  • money_ledgers_id — uuid — Primary key — NOT NULL
  • amount — bigint — NOT NULL
  • balance_after — bigint — NOT NULL
  • created_dtm — timestamp — NOT NULL
  • wallet_id — uuid — Foreign key → MONEY_WALLET.wallet_id — NOT NULL
  • money_tx_id — uuid — Foreign key → MONEY_TX.money_tx_id — NOT NULL

MONEY_TX

  • money_tx_id — uuid — Primary key — NOT NULL
  • status — enum('PENDING', 'SETTLED', 'REJECTED') — NOT NULL
  • amount — bigint — NOT NULL
  • created_dtm — timestamp — NOT NULL
  • updated_dtm — timestamp
  • type — enum('SETTLEMENT', 'REVERSAL', 'CLAIM_ADJUSTMENT', 'EXCHANGE_OUT') — NOT NULL
  • order_id — uuid — Foreign key → ORDERS.order_id
  • wallet_id — uuid — Foreign key → MONEY_WALLET.wallet_id — NOT NULL

MONEY_WALLET

  • wallet_id — uuid — Foreign key → WALLET.wallet_id — NOT NULL
  • pending_amount — bigint — NOT NULL
  • amount — bigint — NOT NULL
  • updated_dtm — timestamp — NOT NULL

ORDERS

  • order_id — uuid — Primary key — NOT NULL
  • boormi_id — uuid — Foreign key → BOORMI.boormi_id — NOT NULL
  • dreami_id — uuid — Foreign key → DREAMI.dreami_id
  • item_name — varchar(50) — NOT NULL
  • item_cd — enum('DOCUMENT', 'SAMPLE', 'PACKAGE', 'ETC') — NOT NULL
  • item_detail — varchar(255)
  • delivery_amount — bigint
  • order_cd — enum — NOT NULL
  • delivery_eta — int — NOT NULL — 수정 불가능 (변동 사항은 변동 예상시간)
  • origin_latitude — decimal(11, 8)
  • origin_longitude — decimal(11, 8)
  • origin_alias — varchar(50)
  • origin_address_line_1 — varchar(255)
  • origin_address_line_2 — varchar(255)
  • destination_latitude — decimal(11, 8)
  • destination_longitude — decimal(11, 8)
  • destination_alias — varchar(50)
  • destination_address_line_1 — varchar(255)
  • destination_address_line_2 — varchar(255)
  • delivery_request — varchar(255)
  • image_key — varchar(500)
  • delivery_request_dtm — timestamp — NOT NULL
  • delivery_distance — bigint
  • route_path — text
  • pending_offer_id — uuid

ORDER_STATUS_HISTORY

  • order_status_id — uuid — Primary key — NOT NULL
  • previous_cd — enum
  • new_cd — enum — NOT NULL
  • changed_dtm — timestamp — NOT NULL
  • order_id — uuid — Foreign key → ORDERS.order_id — NOT NULL

PAYMENT

  • payment_id — uuid — Primary key — NOT NULL
  • payment_amount — bigint — NOT NULL
  • payment_cd — enum('CARD', 'BANK_TRANSFER', 'TOSS_PAY') — NOT NULL
  • payment_dtm — timestamp — NOT NULL
  • refund_dtm — timestamp
  • boormi_id — uuid — Foreign key → BOORMI.boormi_id — NOT NULL

PAYMENT_METHOD

  • payment_method_id — uuid — Primary key — NOT NULL
  • billing_key — varchar(255) — NOT NULL — unique
  • pg_name — varchar(255) — NOT NULL
  • payment_method_cd — enum('CARD', 'BANK_TRANSFER', 'TOSS_PAY') — NOT NULL
  • masking_no — varchar(20) — NOT NULL
  • is_default_payment — boolean — NOT NULL
  • created_dtm — timestamp — NOT NULL
  • updated_dtm — timestamp
  • deleted_dtm — timestamp
  • boormi_id — uuid — Foreign key → BOORMI.boormi_id — NOT NULL

PICKUP_CERTIFICATION

  • certification_id — uuid — Primary key — NOT NULL
  • is_contact — boolean — NOT NULL — 대면, 비대면
  • image_key — varchar(500)
  • sign_key — varchar(500)
  • submitted_dtm — timestamp — NOT NULL
  • order_id — uuid — Foreign key → ORDERS.order_id — NOT NULL

POINT_LEDGERS

  • point_ledgers_id — uuid — Primary key — NOT NULL
  • amount — bigint — NOT NULL
  • balance_after — bigint — NOT NULL
  • created_dtm — timestamp — NOT NULL
  • wallet_id — uuid — Foreign key → POINT_WALLET.wallet_id — NOT NULL
  • point_tx_id — uuid — Foreign key → POINT_TX.point_tx_id — NOT NULL

POINT_TX

  • point_tx_id — uuid — Primary key — NOT NULL
  • type — enum('CHARGE', 'PAYMENT', 'REFUND', 'EXCHANGE_IN') — NOT NULL
  • status — enum('PENDING', 'PAID', 'REFUNDED_PARTIAL', 'REFUNDED_FULL') — NOT NULL
  • amount — bigint — NOT NULL
  • created_dtm — timestamp — NOT NULL
  • updated_dtm — timestamp
  • payment_id — uuid — Foreign key → PAYMENT.payment_id
  • order_id — uuid — Foreign key → ORDERS.order_id
  • wallet_id — uuid — Foreign key → POINT_WALLET.wallet_id — NOT NULL

POINT_WALLET

  • wallet_id — uuid — Foreign key → WALLET.wallet_id — NOT NULL
  • amount — bigint — NOT NULL
  • updated_dtm — timestamp — NOT NULL

SETTLEMENT_DETAILS

  • settlement_id — uuid — Primary key — NOT NULL
  • dreami_id — uuid — Foreign key → DREAMI.dreami_id — NOT NULL
  • settlement_account — varchar(50) — NOT NULL
  • registered_dtm — timestamp — NOT NULL
  • settlement_bank — varchar(50) — NOT NULL
  • account_holder — varchar(50)

UPLOAD_SESSION

  • upload_session_id — binary(16) — Primary key — NOT NULL
  • purpose — varchar(50) — NOT NULL
  • resource_id — binary(16)
  • s3_key — varchar(500) — NOT NULL
  • status — enum('ISSUED', 'CONSUMED') — NOT NULL
  • issued_dtm — timestamp — NOT NULL
  • consumed_dtm — timestamp
  • boormi_id — uuid — Foreign key → BOORMI.boormi_id — NOT NULL

WALLET

  • wallet_id — uuid — Primary key — NOT NULL
  • boormi_id — uuid — Foreign key → DREAMI.dreami_id — NOT NULL