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)

email

  • 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