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')