42partner
Tables (27)
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)
- JOB_CONFIGURATION_LOCATION — VARCHAR(2500)
- INDEX — `JOB_INST_EXEC_FK`
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
- TYPE_CD — VARCHAR(6) — NOT NULL
- KEY_NAME — VARCHAR(100) — NOT NULL
- STRING_VAL — VARCHAR(250)
- DATE_VAL — DATETIME(6)
- LONG_VAL — BIGINT
- DOUBLE_VAL — DOUBLE
- IDENTIFYING — CHAR(1) — NOT NULL
- INDEX — `JOB_EXEC_PARAMS_FK`
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
- START_TIME — DATETIME(6) — NOT NULL
- 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)
- INDEX — `JOB_EXEC_STEP_FK`
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
activity
- activity_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- activity_type — VARCHAR(255) — NOT NULL
- content_category — VARCHAR(255) — NOT NULL
- score — INT — NOT NULL
- match_id — BIGINT — Foreign key → matchs.match_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- INDEX — `FK5gvi57aromrv7qddhrshkaiij`
- INDEX — `FKgksyi74c6if2f2xl4fd893nnl`
article
- article_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- anonymity — BIT(1) — NOT NULL
- api_id — VARCHAR(50) — NOT NULL
- content — LONGTEXT — NOT NULL
- content_category — VARCHAR(255) — NOT NULL
- date — DATE — NOT NULL
- is_complete — BIT(1) — NOT NULL
- is_deleted — BIT(1) — NOT NULL
- participant_num — INT — NOT NULL
- participant_num_max — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
article_match_condition
- article_match_condition_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- article_id — BIGINT — Foreign key → article.article_id — NOT NULL
- match_condition_id — BIGINT — Foreign key → match_condition.match_condition_id — NOT NULL
- INDEX — `FK6pnrarc1cprtd64ynsq74vncs`
- INDEX — `FK86ml9gucolh3wnmwapv145b33`
article_member
- article_member_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- is_author — BIT(1) — NOT NULL
- article_id — BIGINT — Foreign key → article.article_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- INDEX — `FKis2l2o5qkjsxrylbawhniom3k`
- INDEX — `FKra6a8djsh2o2gmeapcavyrkk2`
authority
- authority_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- api_id — VARCHAR(50) — NOT NULL
- permission — VARCHAR(255) — NOT NULL
hibernate_sequence
- next_val — BIGINT
match_condition
- match_condition_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- condition_category — VARCHAR(255) — NOT NULL
- value — VARCHAR(255) — NOT NULL
match_condition_match
- match_condition_match_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- match_id — BIGINT — Foreign key → matchs.match_id — NOT NULL
- match_condition_id — BIGINT — Foreign key → match_condition.match_condition_id — NOT NULL
- INDEX — `FKmwv5vdd2f1qbcu6ht4fqde09c`
- INDEX — `FKk0b5ur5jj7g8ohp4r1by9u2xg`
match_member
- match_member_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- is_author — BIT(1) — NOT NULL
- match_id — BIGINT — Foreign key → matchs.match_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- INDEX — `FKkvol6hkdgauxto079pld591g2`
- INDEX — `FKouikacpm4hv3qwjvix8xo1e7t`
matchs
- match_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- api_id — VARCHAR(50) — NOT NULL
- content_category — VARCHAR(255) — NOT NULL
- match_status — VARCHAR(255) — NOT NULL
- method_category — VARCHAR(255) — NOT NULL
- participant_num — INT — NOT NULL
- article_id — BIGINT — Foreign key → article.article_id
- INDEX — `FKdidecf1fqjr5fn4bntxrv3xws`
member
- member_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- api_id — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
opinion
- opinion_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- api_id — VARCHAR(50) — NOT NULL
- content — LONGTEXT — NOT NULL
- is_deleted — BIT(1) — NOT NULL
- level — INT — NOT NULL
- parent_api_id — VARCHAR(255)
- article_id — BIGINT — Foreign key → article.article_id — NOT NULL
- member_author_id — BIGINT — Foreign key → member.member_id — NOT NULL
- INDEX — `FKhfubgbgw9kmmyb9s8tcfbuy2u`
- INDEX — `FKmrybhoeyulk3rley5dp9v37um`
random_matches
- random_match_id — BIGINT — Primary key — NOT NULL
- dtype — VARCHAR(31) — NOT NULL
- content_category — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- is_expired — BIT(1) — NOT NULL
- place — VARCHAR(255) — NOT NULL
- type_of_study — VARCHAR(255)
- way_of_eating — VARCHAR(255)
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- INDEX — `idx__created_at`
- INDEX — `FK2w9x07u5tw87ragyyxk94ore`
role
- role_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- api_id — VARCHAR(50) — NOT NULL
- value — VARCHAR(255) — NOT NULL
role_authority
- role_id — BIGINT — Foreign key → role.role_id — NOT NULL
- authority_id — BIGINT — Foreign key → authority.authority_id — NOT NULL
- INDEX — `FKqbri833f7xop13bvdje3xxtnw`
try_judge
- try_judge_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- participating_meal_article_count — INT — NOT NULL
- participating_study_article_count — INT — NOT NULL
- random_meal_count — INT — NOT NULL
- random_study_article_count — INT — NOT NULL
- writing_meal_article_count — INT — NOT NULL
- writing_study_article_count — INT — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- INDEX — `FK1iaw4w1ekhohlbgwnivkwvoxc`
user
- user_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- api_id — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- isoauth2 — BIT(1) — NOT NULL
- o_auth2type — INT — NOT NULL
- oauth2username — VARCHAR(30) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- slack_email — VARCHAR(80)
- username — VARCHAR(30) — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- INDEX — `FKtcx8a5i8q7mmh7xl2fi44o8v2`
user_role
- user_role_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — INT
- role_id — BIGINT — Foreign key → role.role_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- INDEX — `FKa68196081fvovjhkek5m97n3y`
- INDEX — `FK859n2jvi8ivhui0rl0esws6o`