demo ERD
Tables (11)
account_accounts
- id — UUID — Primary key — NOT NULL
- user_id — UUID — NOT NULL
- status — VARCHAR(20) — NOT NULL
- cash_krw — BIGINT — NOT NULL
- locked_krw — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
account_consumed_events
- event_id — UUID — Primary key — NOT NULL
- event_type — VARCHAR(120) — NOT NULL
- consumed_at — TIMESTAMPTZ — NOT NULL
account_idempotency_records
- actor_id — VARCHAR(120) — Primary key — NOT NULL
- operation — VARCHAR(200) — Primary key — NOT NULL
- idempotency_key — VARCHAR(64) — Primary key — NOT NULL
- request_hash — VARCHAR(64) — NOT NULL
- response_payload — BYTEA — NOT NULL
- response_type — VARCHAR(200) — NOT NULL
- grpc_code — VARCHAR(40) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
account_outbox_events
- id — UUID — Primary key — NOT NULL
- event_type — VARCHAR(120) — NOT NULL
- aggregate_id — VARCHAR(120) — NOT NULL
- payload — TEXT — NOT NULL
- occurred_at — TIMESTAMPTZ — NOT NULL
- published_at — TIMESTAMPTZ
order_svc_executions
- id — BIGSERIAL — Primary key — NOT NULL
- order_id — UUID — Foreign key → order_svc_orders.id — NOT NULL
- executed_price_krw — BIGINT — NOT NULL
- executed_quantity — BIGINT — NOT NULL
- fee_krw — BIGINT — NOT NULL
- tax_krw — BIGINT — NOT NULL
- net_amount_krw — BIGINT — NOT NULL
- executed_at — TIMESTAMPTZ — NOT NULL
order_svc_idempotency_records
- actor_id — VARCHAR(120) — Primary key — NOT NULL
- operation — VARCHAR(200) — Primary key — NOT NULL
- idempotency_key — VARCHAR(64) — Primary key — NOT NULL
- request_hash — VARCHAR(64) — NOT NULL
- response_payload — BYTEA — NOT NULL
- response_type — VARCHAR(200) — NOT NULL
- grpc_code — VARCHAR(40) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
order_svc_orders
- id — UUID — Primary key — NOT NULL
- user_id — UUID — NOT NULL
- account_id — UUID — NOT NULL
- symbol — VARCHAR(20) — NOT NULL
- side — VARCHAR(10) — NOT NULL
- order_kind — VARCHAR(20) — NOT NULL
- quantity — BIGINT — NOT NULL
- price_krw — BIGINT
- reserved_amount_krw — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- parent_order_id — UUID — Foreign key → order_svc_orders.id
- idempotency_key — TEXT — NOT NULL
- executed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
order_svc_outbox_events
- id — UUID — Primary key — NOT NULL
- event_type — VARCHAR(120) — NOT NULL
- aggregate_id — VARCHAR(120) — NOT NULL
- payload — TEXT — NOT NULL
- occurred_at — TIMESTAMPTZ — NOT NULL
- published_at — TIMESTAMPTZ
reservation_idempotency_records
- actor_id — VARCHAR(120) — Primary key — NOT NULL
- operation — VARCHAR(200) — Primary key — NOT NULL
- idempotency_key — VARCHAR(64) — Primary key — NOT NULL
- request_hash — VARCHAR(64) — NOT NULL
- response_payload — BYTEA — NOT NULL
- response_type — VARCHAR(200) — NOT NULL
- grpc_code — VARCHAR(40) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
reservation_outbox_events
- id — UUID — Primary key — NOT NULL
- event_type — VARCHAR(120) — NOT NULL
- aggregate_id — VARCHAR(120) — NOT NULL
- payload — TEXT — NOT NULL
- occurred_at — TIMESTAMPTZ — NOT NULL
- published_at — TIMESTAMPTZ
reservation_reservations
- id — UUID — Primary key — NOT NULL
- user_id — UUID — NOT NULL
- account_id — UUID — NOT NULL
- symbol — VARCHAR(20) — NOT NULL
- side — VARCHAR(10) — NOT NULL
- timing — VARCHAR(20) — NOT NULL
- order_kind — VARCHAR(30) — NOT NULL
- quantity — BIGINT — NOT NULL
- price_krw — BIGINT
- scheduled_date — DATE — NOT NULL
- status — VARCHAR(20) — NOT NULL
- converted_order_id — UUID
- parent_reservation_id — UUID — Foreign key → reservation_reservations.id
- reserved_amount_krw — BIGINT — NOT NULL
- idempotency_key — TEXT — NOT NULL
- expires_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL