Monew
Tables (15)
BATCH_JOB_EXECUTION
- JOB_EXECUTION_ID — BIGINT — NOT NULL
- VERSION — BIGINT
- JOB_INSTANCE_ID — BIGINT — Foreign key → BATCH_JOB_INSTANCE.JOB_INSTANCE_ID — NOT NULL
- CREATE_TIME — TIMESTAMP — NOT NULL
- START_TIME — TIMESTAMP
- END_TIME — TIMESTAMP
- STATUS — VARCHAR(10)
- EXIT_CODE — VARCHAR(2500)
- EXIT_MESSAGE — VARCHAR(2500)
- LAST_UPDATED — TIMESTAMP
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_INSTANCE
- JOB_INSTANCE_ID — BIGINT — NOT NULL
- VERSION — BIGINT
- JOB_NAME — VARCHAR(100) — NOT NULL
- JOB_KEY — VARCHAR(32) — NOT NULL
BATCH_STEP_EXECUTION
- STEP_EXECUTION_ID — BIGINT — 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 — TIMESTAMP — NOT NULL
- START_TIME — TIMESTAMP
- END_TIME — TIMESTAMP
- 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 — TIMESTAMP
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
article_views
- id — uuid — NOT NULL
- article_id — uuid — NOT NULL
- viewed_by — uuid — NOT NULL
- client_ip — varchar(45)
- viewed_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
articles
- id — uuid — NOT NULL
- interest_id — uuid
- source — varchar(100)
- source_url — text — NOT NULL
- title — varchar(255) — NOT NULL
- summary — text
- view_count — bigint
- comment_count — bigint
- publish_date — timestamp
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
comment_likes
- id — uuid — NOT NULL
- comment_id — uuid — NOT NULL — eferences public.comments on delete cascad
- user_id — uuid — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
comments
- id — uuid — NOT NULL
- article_id — uuid — NOT NULL
- user_id — uuid — NOT NULL
- content — varchar(500) — NOT NULL
- like_count — bigint
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
interest_keywords
- id — uuid — NOT NULL
- interest_id — uuid — NOT NULL
- keyword_value — varchar(50) — NOT NULL
interests
- id — uuid — NOT NULL
- name — varchar(50) — NOT NULL
- subscriber_count — bigint
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
notifications
- id — uuid — NOT NULL
- user_id — uuid — NOT NULL
- content — text — NOT NULL
- resource_type — varchar(50)
- resource_id — uuid
- is_confirmed — boolean
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
subscriptions
- id — uuid — NOT NULL
- user_id — uuid — NOT NULL
- interest_id — uuid — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
users
- id — uuid — NOT NULL
- email — varchar(255) — NOT NULL
- nickname — varchar(20) — NOT NULL
- password — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- status — varchar(20)