42Partner

Tables (18)

activity

  • activity_id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • version — int
  • score — int — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

article

  • member_id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • version — int
  • anonymity — bit(1) — NOT NULL
  • api_id — varchar(50) — NOT NULL
  • complete — bit(1) — NOT NULL
  • content — longtext — NOT NULL
  • participant_num — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • member_author_id — bigint — Foreign key → member.member_id — NOT NULL

article_match_condition

  • article_match_condition_id — bigint — Primary key — NOT NULL
  • article_id — bigint — Foreign key → article.member_id — NOT NULL
  • match_condition_id — bigint — Foreign key → match_condition.match_condition_id — NOT NULL

authority

  • authority_id — bigint — Primary key — NOT NULL
  • 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
  • condition_category — varchar(255) — NOT NULL
  • value — varchar(255) — NOT NULL

match_condition_match

  • match_condition_match_id — bigint — Primary key — NOT NULL
  • match_condition_id — bigint — Foreign key → match_condition.match_condition_id — NOT NULL
  • match_id — bigint — Foreign key → matching.match_id — NOT NULL

match_member

  • match_member_id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • version — int
  • match_id — bigint — Foreign key → matching.match_id — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

matching

  • match_id — bigint — Primary key — NOT NULL
  • match_type — varchar(31) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • version — int
  • api_id — varchar(50) — NOT NULL
  • match_status — varchar(255) — NOT NULL

meal_apply_match

  • match_id — bigint — Foreign key → matching.match_id — NOT NULL

meal_random_match

  • match_id — bigint — Foreign key → matching.match_id — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • version — int
  • api_id — varchar(50) — NOT NULL
  • nickname — varchar(30) — NOT NULL
  • article_id — bigint — Foreign key → article.member_id — NOT NULL

opinion

  • opinion_id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • version — int
  • anonymity — bit(1) — NOT NULL
  • api_id — varchar(50) — NOT NULL
  • content — longtext — NOT NULL
  • article_id — bigint — Foreign key → article.member_id — NOT NULL
  • member_author_id — bigint — Foreign key → member.member_id — NOT NULL

role

  • role_id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • 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

study_random_match

  • match_id — bigint — Foreign key → matching.match_id — NOT NULL

user

  • user_id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • version — int
  • account_non_expired — bit(1) — NOT NULL
  • account_non_locked — bit(1) — NOT NULL
  • api_id — varchar(50) — NOT NULL
  • credentials_non_expired — bit(1) — NOT NULL
  • email — varchar(100) — NOT NULL
  • enabled — bit(1) — 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

user_role

  • user_role_id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • version — int
  • role_id — bigint — Foreign key → role.role_id — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL