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