batch

Tables (17)

BATCH_JOB_EXECUTION

  • JOB_EXECUTION_ID — bigint — Primary key — NOT NULL
  • VERSION — bigint
  • JOB_INSTANCE_ID — bigint — Foreign key → BATCH_JOB_INSTANCE.JOB_INSTANCE_ID — NOT NULL
  • CREATE_TIME — datetime(6) — NOT NULL
  • START_TIME — datetime(6)
  • END_TIME — datetime(6)
  • STATUS — varchar(10)
  • EXIT_CODE — varchar(2500)
  • EXIT_MESSAGE — varchar(2500)
  • LAST_UPDATED — datetime(6)

BATCH_JOB_EXECUTION_CONTEXT

  • JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
  • SHORT_CONTEXT — varchar(2500) — NOT NULL
  • SERIALIZED_CONTEXT — text

BATCH_JOB_EXECUTION_PARAMS

  • JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
  • PARAMETER_NAME — varchar(100) — NOT NULL
  • PARAMETER_TYPE — varchar(100) — NOT NULL
  • PARAMETER_VALUE — varchar(2500)
  • IDENTIFYING — char(1) — NOT NULL

BATCH_JOB_EXECUTION_SEQ

  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

BATCH_JOB_INSTANCE

  • JOB_INSTANCE_ID — bigint — Primary key — NOT NULL
  • VERSION — bigint
  • JOB_NAME — varchar(100) — NOT NULL
  • JOB_KEY — varchar(32) — NOT NULL

BATCH_JOB_SEQ

  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

BATCH_STEP_EXECUTION

  • STEP_EXECUTION_ID — bigint — Primary key — NOT NULL
  • VERSION — bigint — NOT NULL
  • STEP_NAME — varchar(100) — NOT NULL
  • JOB_EXECUTION_ID — bigint — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
  • CREATE_TIME — datetime(6) — NOT NULL
  • START_TIME — datetime(6)
  • END_TIME — datetime(6)
  • STATUS — varchar(10)
  • COMMIT_COUNT — bigint
  • READ_COUNT — bigint
  • FILTER_COUNT — bigint
  • WRITE_COUNT — bigint
  • READ_SKIP_COUNT — bigint
  • WRITE_SKIP_COUNT — bigint
  • PROCESS_SKIP_COUNT — bigint
  • ROLLBACK_COUNT — bigint
  • EXIT_CODE — varchar(2500)
  • EXIT_MESSAGE — varchar(2500)
  • LAST_UPDATED — datetime(6)

BATCH_STEP_EXECUTION_CONTEXT

  • STEP_EXECUTION_ID — bigint — Foreign key → BATCH_STEP_EXECUTION.STEP_EXECUTION_ID — NOT NULL
  • SHORT_CONTEXT — varchar(2500) — NOT NULL
  • SERIALIZED_CONTEXT — text

BATCH_STEP_EXECUTION_SEQ

  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

monthly_settlement

  • monthly_settlement_id — binary(16) — Primary key — NOT NULL
  • net_sales — double
  • settlement_date_time — datetime(6) — NOT NULL
  • shop_id — binary(16) — NOT NULL
  • shop_name — varchar(255) — NOT NULL
  • total_refunds — double
  • total_sales — double

order

  • order_id — binary(16) — Primary key — NOT NULL
  • cancel_date_time — datetime(6)
  • completion_date_time — datetime(6)
  • discount_type — enum('FIRST_ORDER_DISCOUNT','NONE','VIP_DISCOUNT')
  • price — double — NOT NULL
  • start_date_time — datetime(6) — NOT NULL
  • status — enum('CANCEL','COMPLEMENT','DURING')
  • shop_id — binary(16) — Foreign key → shop.shop_id

order_payment

  • order_payment_id — binary(16) — Primary key — NOT NULL
  • cancel_date_time — datetime(6)
  • completion_datetime — datetime(6)
  • start_date_time — datetime(6)
  • status — enum('COMPLETED','FAILED','PENDING','REFUNDED')
  • order_id — binary(16) — Foreign key → order.order_id — NOT NULL

order_transaction

  • order_transaction_id — binary(16) — Primary key — NOT NULL
  • completion_date_time — datetime(6)
  • discount_type — enum('FIRST_ORDER_DISCOUNT','NONE','VIP_DISCOUNT')
  • price — double — NOT NULL
  • shop_id — binary(16)
  • shop_name — varchar(255)
  • status — enum('CANCEL','COMPLEMENT','DURING')

refresh_tokens

  • refresh_token_id — varchar(255) — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • user_id — binary(16)
  • token — varchar(255)

settlement

  • settlement_id — binary(16) — Primary key — NOT NULL
  • net_sales — double
  • order_count — int
  • settlement_date_time — datetime(6) — NOT NULL
  • shop_id — binary(16) — NOT NULL
  • shop_name — varchar(255) — NOT NULL
  • total_refunds — double
  • total_sales — double

shop

  • shop_id — binary(16) — Primary key — NOT NULL
  • create_date_time — datetime(6)
  • modified_date_time — datetime(6)
  • name — varchar(255) — NOT NULL
  • user_id — binary(16) — Foreign key → user.user_id — NOT NULL

user

  • user_id — binary(16) — Primary key — NOT NULL
  • create_date_time — datetime(6)
  • modified_date_time — datetime(6)
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — enum('ADMIN','OWNER')