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