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`