yona1.16
Tables (62)
assignee
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → n4user.id
- project_id — bigint(20)
attachment
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- hash — varchar(255)
- container_type — varchar(20)
- mime_type — varchar(255)
- size — bigint(20)
- container_id — bigint(20) — NOT NULL
- created_date — datetime
- owner_login_id — varchar(255)
comment_thread
- id — bigint(20) — Primary key — NOT NULL
- dtype — varchar(10) — NOT NULL
- author_id — bigint(20)
- author_login_id — varchar(255)
- author_name — varchar(255)
- state — varchar(6)
- created_date — datetime
- pull_request_id — bigint(20)
- project_id — bigint(20)
- prev_commit_id — varchar(255)
- commit_id — varchar(255)
- path — varchar(255)
- start_side — varchar(1)
- start_line — int(11)
- start_column — int(11)
- end_side — varchar(1)
- end_line — int(11)
- end_column — int(11)
comment_thread_n4user
- comment_thread_id — bigint(20) — Foreign key → comment_thread.id — NOT NULL
- n4user_id — bigint(20) — Foreign key → n4user.id — NOT NULL
commit_comment
- id — bigint(20) — Primary key — NOT NULL
- project_id — bigint(20)
- path — varchar(255)
- line — int(11)
- side — varchar(1)
- contents — longtext
- created_date — datetime
- author_id — bigint(20)
- author_login_id — varchar(255)
- author_name — varchar(255)
- commit_id — varchar(255)
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → n4user.id
- email — varchar(255)
- valid — tinyint(1)
- token — varchar(255)
favorite_issue
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → n4user.id
- issue_id — bigint(20) — Foreign key → issue.id
favorite_organization
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → n4user.id
- organization_id — bigint(20) — Foreign key → organization.id
- organization_name — varchar(255)
favorite_project
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → n4user.id
- project_id — bigint(20)
- owner — varchar(255)
- project_name — varchar(255)
issue
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255)
- body — longtext
- created_date — datetime
- updated_date — datetime
- author_id — bigint(20)
- author_login_id — varchar(255)
- author_name — varchar(255)
- project_id — bigint(20)
- number — bigint(20)
- num_of_comments — int(11)
- state — int(11)
- due_date — datetime
- milestone_id — bigint(20) — Foreign key → milestone.id
- assignee_id — bigint(20) — Foreign key → assignee.id
- history — longtext
- parent_id — bigint(20) — Foreign key → issue.id
- weight — tinyint(2)
- updated_by_author_id — bigint(20)
- is_draft — tinyint(1)
issue_comment
- id — bigint(20) — Primary key — NOT NULL
- contents — longtext
- created_date — datetime
- author_id — bigint(20)
- author_login_id — varchar(255)
- author_name — varchar(255)
- issue_id — bigint(20) — Foreign key → issue.id
- project_id — bigint(20) — NOT NULL
- parent_comment_id — bigint(20) — Foreign key → issue_comment.id
issue_comment_voter
- issue_comment_id — bigint(20) — Foreign key → issue_comment.id — NOT NULL
- user_id — bigint(20) — Foreign key → n4user.id — NOT NULL
issue_event
- id — bigint(20) — Primary key — NOT NULL
- created — datetime
- sender_login_id — varchar(255)
- sender_email — varchar(255)
- issue_id — bigint(20) — Foreign key → issue.id
- event_type — varchar(34)
- old_value — longtext
- new_value — longtext
issue_issue_label
- issue_id — bigint(20) — Foreign key → issue.id — NOT NULL
- issue_label_id — bigint(20) — Foreign key → issue_label.id — NOT NULL
issue_label
- id — bigint(20) — Primary key — NOT NULL
- category_id — bigint(20) — Foreign key → issue_label_category.id
- color — varchar(255)
- name — varchar(255)
- project_id — bigint(20)
issue_label_category
- id — bigint(20) — Primary key — NOT NULL
- project_id — bigint(20)
- name — varchar(255)
- is_exclusive — tinyint(1)
issue_sharer
- id — bigint(20) — Primary key — NOT NULL
- created — date
- login_id — varchar(255)
- user_id — bigint(20) — Foreign key → n4user.id
- issue_id — bigint(20) — Foreign key → issue.id
issue_voter
- issue_id — bigint(20) — Foreign key → issue.id — NOT NULL
- user_id — bigint(20) — Foreign key → n4user.id — NOT NULL
label
- id — bigint(20) — Primary key — NOT NULL
- category — varchar(255)
- name — varchar(255)
linked_account
- id — bigint(20) — Primary key — NOT NULL
- user_credential_id — bigint(20)
- provider_user_id — varchar(255)
- provider_key — varchar(255)
mention
- id — bigint(20) — Primary key — NOT NULL
- resource_type — varchar(20)
- resource_id — varchar(255)
- user_id — bigint(20) — Foreign key → n4user.id
milestone
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255)
- due_date — datetime
- contents — longtext
- state — int(11)
- project_id — bigint(20)
n4user
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- login_id — varchar(255)
- password — varchar(255)
- password_salt — varchar(255)
- email — varchar(255)
- remember_me — tinyint(1)
- state — varchar(7)
- last_state_modified_date — datetime
- created_date — datetime
- lang — varchar(255)
- token — varchar(255)
- is_guest — tinyint(1)
- english_name — varchar(255)
notification_event
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255)
- sender_id — bigint(20)
- created — datetime
- resource_type — varchar(20)
- resource_id — varchar(255)
- event_type — varchar(34)
- old_value — longtext
- new_value — longtext
notification_event_n4user
- n4user_id — bigint(20) — Foreign key → n4user.id — NOT NULL
- notification_event_id — bigint(20) — Foreign key → notification_event.id — NOT NULL
notification_mail
- id — bigint(20) — Primary key — NOT NULL
- notification_event_id — bigint(20) — Foreign key → notification_event.id
organization
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- created — datetime
- descr — varchar(255)
organization_user
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → n4user.id
- organization_id — bigint(20) — Foreign key → organization.id
- role_id — bigint(20)
original_email
- id — bigint(20) — Primary key — NOT NULL
- message_id — varchar(255)
- resource_type — varchar(20)
- resource_id — varchar(255)
- handled_date — datetime
play_evolutions
- id — int(11) — Primary key — NOT NULL
- hash — varchar(255) — NOT NULL
- applied_at — timestamp — NOT NULL
- apply_script — text
- revert_script — text
- state — varchar(255)
- last_problem — text
posting
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255)
- body — longtext
- created_date — datetime
- updated_date — datetime
- author_id — bigint(20)
- author_login_id — varchar(255)
- author_name — varchar(255)
- project_id — bigint(20) — Foreign key → project.id
- number — bigint(20)
- num_of_comments — int(11)
- notice — tinyint(1)
- readme — tinyint(1)
- history — longtext
- parent_id — bigint(20) — Foreign key → posting.id
- updated_by_author_id — bigint(20)
posting_comment
- id — bigint(20) — Primary key — NOT NULL
- contents — longtext
- created_date — datetime
- author_id — bigint(20)
- author_login_id — varchar(255)
- author_name — varchar(255)
- posting_id — bigint(20) — Foreign key → posting.id
- project_id — bigint(20) — NOT NULL
- parent_comment_id — bigint(20) — Foreign key → posting_comment.id
posting_issue_label
- issue_label_id — bigint(20) — Primary key — NOT NULL
- posting_id — bigint(20) — Foreign key → posting.id — NOT NULL
project
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- overview — varchar(255)
- vcs — varchar(255)
- siteurl — varchar(255)
- owner — varchar(255)
- created_date — datetime
- last_issue_number — bigint(20)
- last_posting_number — bigint(20)
- original_project_id — bigint(20) — Foreign key → project.id
- last_pushed_date — datetime
- default_reviewer_count — int(11)
- is_using_reviewer_count — tinyint(1)
- organization_id — bigint(20)
- project_scope — varchar(9)
- previous_owner_login_id — varchar(255)
- previous_name — varchar(255)
- previous_name_changed_time — bigint(20)
- is_code_accessible_member_only — tinyint(1)
project_label
- label_id — bigint(20) — Primary key — NOT NULL
- project_id — bigint(20) — Foreign key → project.id — NOT NULL
project_menu_setting
- id — bigint(20) — Primary key — NOT NULL
- project_id — bigint(20) — Foreign key → project.id
- code — tinyint(1)
- issue — tinyint(1)
- pull_request — tinyint(1)
- review — tinyint(1)
- milestone — tinyint(1)
- board — tinyint(1)
project_pushed_branch
- id — bigint(20) — Primary key — NOT NULL
- pushed_date — datetime
- name — varchar(255)
- project_id — bigint(20) — Foreign key → project.id
project_transfer
- id — bigint(20) — Primary key — NOT NULL
- sender_id — bigint(20)
- destination — varchar(255)
- project_id — bigint(20) — Foreign key → project.id
- requested — datetime
- confirm_key — varchar(255)
- accepted — tinyint(1)
- new_project_name — varchar(255)
project_user
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- project_id — bigint(20) — Foreign key → project.id
- role_id — bigint(20) — Foreign key → role.id
project_visitation
- id — bigint(20) — Primary key — NOT NULL
- project_id — bigint(20) — Foreign key → project.id
- recently_visited_projects_id — bigint(20) — Foreign key → recently_visited_projects.id
- visited — datetime
property
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(25)
- value — varchar(255)
pull_request
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255)
- body — longtext
- to_project_id — bigint(20) — Foreign key → project.id
- from_project_id — bigint(20) — Foreign key → project.id
- to_branch — varchar(255)
- from_branch — varchar(255)
- contributor_id — bigint(20)
- receiver_id — bigint(20)
- created — datetime
- updated — datetime
- received — datetime
- state — int(11)
- is_conflict — tinyint(1)
- is_merging — tinyint(1)
- last_commit_id — varchar(255)
- merged_commit_id_from — varchar(255)
- merged_commit_id_to — varchar(255)
- number — bigint(20)
pull_request_commit
- id — bigint(20) — Primary key — NOT NULL
- pull_request_id — bigint(20) — Foreign key → pull_request.id
- commit_id — varchar(255)
- author_date — datetime
- created — datetime
- commit_message — longtext
- commit_short_id — varchar(255)
- author_email — varchar(255)
- state — varchar(7)
pull_request_event
- id — bigint(20) — Primary key — NOT NULL
- sender_login_id — varchar(255)
- pull_request_id — bigint(20) — Foreign key → pull_request.id
- event_type — varchar(34)
- created — datetime
- old_value — longtext
- new_value — longtext
pull_request_reviewers
- user_id — bigint(20) — Primary key — NOT NULL
- pull_request_id — bigint(20) — Foreign key → pull_request.id — NOT NULL
recent_issue
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- issue_id — bigint(20)
- posting_id — bigint(20)
- title — varchar(255)
- url — varchar(255)
- created_date — datetime
recent_project
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- owner — varchar(255)
- project_id — bigint(20) — Foreign key → project.id
- project_name — varchar(255)
recently_visited_projects
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
review_comment
- id — bigint(20) — Primary key — NOT NULL
- contents — longtext
- created_date — datetime
- author_id — bigint(20)
- author_login_id — varchar(255)
- author_name — varchar(255)
- thread_id — bigint(20)
role
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255)
- active — tinyint(1)
site_admin
- id — bigint(20) — Primary key — NOT NULL
- admin_id — bigint(20)
title_head
- id — bigint(20) — Primary key — NOT NULL
- project_id — bigint(20) — Foreign key → project.id
- head_keyword — varchar(255)
- frequency — int(11)
unwatch
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- resource_type — varchar(20)
- resource_id — varchar(255)
user_credential
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- login_id — varchar(255)
- email — varchar(255)
- name — varchar(255)
- active — tinyint(1)
- email_validated — tinyint(1)
user_enrolled_organization
- user_id — bigint(20) — Primary key — NOT NULL
- organization_id — bigint(20) — Primary key — NOT NULL
user_enrolled_project
- user_id — bigint(20) — Primary key — NOT NULL
- project_id — bigint(20) — Foreign key → project.id — NOT NULL
user_project_notification
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- project_id — bigint(20) — Foreign key → project.id
- notification_type — varchar(34)
- allowed — tinyint(1)
user_setting
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- login_default_page — varchar(255)
user_verification
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- login_id — varchar(255)
- verification_code — varchar(255)
- timestamp — bigint(20)
watch
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20)
- resource_type — varchar(20)
- resource_id — varchar(255)
webhook
- id — bigint(20) — Primary key — NOT NULL
- project_id — bigint(20) — Foreign key → project.id
- payload_url — varchar(2000)
- secret — varchar(250)
- created_at — datetime
- git_push — tinyint(1)
- webhook_type — tinyint(1)
webhook_thread
- id — bigint(20) — Primary key — NOT NULL
- webhook_id — bigint(20) — Foreign key → webhook.id
- resource_type — varchar(20)
- resource_id — varchar(255)
- thread_id — varchar(2000)
- created_at — datetime