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