4.3.1数据库概念图

patchset

ssh_key

ID bigint(20) USERID varchar(256)USERNAME varchar(256) PUBLIC_KEY_TYPE varchar(32)PUBLIC_KEY varchar(1024)PUBLIC_KEY_COMMENT varchar(1024)FULL_PUBLIC_KEY varbinary(1024)GMT_CREATE datetime

user_info

registered_on timestampfull_name varchar(255)preferred_email varchar(255)maximum_page_size smallint(6)show_site_header char(1)use_flash_clipboard char(1)download_url varchar(20)download_command varchar(20)copy_self_on_email char(1)date_format varchar(10)time_format varchar(10)relative_date_in_change_table char(1)diff_view varchar(20)size_bar_in_change_table char(1)legacycid_in_change_table char(1)review_category_strategy varchar(20)inactive char(1)account_id int(11)mute_common_path_prefixes char(1)

group_member

ID bigint(20)GROUP_ID bigint(20)USER_NAME varchar(255)GMT_CREATE datetime

branch_rule

ID bigint(20) REPO_NAME varchar(255)BRANCH_PATTERN varchar(50)TYPE varchar(50)VALUE varchar(255)GMT_CREATE datetime

branch

ID bigint(20) REPO_NAME varchar(128)BRANCH_NAME varchar(128)FROM_BRANCH varchar(128)TO_BRANCH varchar(128)OLD_COMMIT_ID varchar(128)NEW_COMMIT_ID varchar(128)STATUS int(11)OPERATOR varchar(128)ISSUE_ID bigint(20)GMT_CREATE datetimeGMT_MODIFIED datetimeWORKFLOW_STATUS varchar(40)

commit

ID int(11) REPO varchar(255) BRANCH varchar(50) COMMITTER varchar(255)COMMIT_ID varchar(64)REF_NAME varchar(64)GMT_CREATE datetimeGMT_MODIFIED datetime

repo_info

ID bigint(20) FULL_NAME varchar(255) PRODUCT_ID bigint(20) GROUP_ID bigint(20) CREATOR varchar(255) PDB_PRODUCT_ID bigint(20) NAME varchar(255) SECRET varchar(255) ENGINEERING_TYPE varchar(45) DESCRIPTION varchar(255) GMT_CREATE datetime GMT_MODIFIED datetime DEFAULT_BRANCH varchar(50) REVIEWSETTING varchar(40) IGNORE_AGILE_SCORE tinyint(100) AUTO_SUBMIT tinyint(10) WORKFLOW_TYPE varchar(50) MAX_TOPIC_LENGTH int(100) NEED_SUBMIT_CHECK tinyint(100)

comments

line_nbr int(11) author_id int(11)written_on timestampstatus char(1)side smallint(6)message mediumtextparent_uuid varchar(40)range_start_line int(11)range_start_character int(11)range_end_line int(11)range_end_character int(11)change_id int(11)patch_set_id int(11)file_name varchar(191)uuid varchar(40)

group

ID bigint(20)NAME varchar(255)COMPANY_ID bigint(20)GERRIT_ID varchar(64)TYPE varchar(25)GMT_CREATE datetimeGMT_MODIFIED datetime

tags标签表

ID bigint(20) REPO_NAME varchar(255)TAG_NAME varchar(255)COMMIT_ID varchar(64)OPERATOR varchar(255)ARCHIVE_NAME varchar(255)PACKAGE_NAME varchar(512)MESSAGE textGMT_CREATE datetimeGMT_MODIFIED datetime

repo_set_audit

ID bigint(20)REPO_NAME varchar(255)BRANCH_NAME varchar(255)TAG_NAME varchar(255)OPERATOR varchar(255)WORKFLOW_TYPE varchar(25)FROM_STATUS varchar(40)TO_STATUS varchar(40)GMT_CREATE datetimeGMT_MODIFIED datetime

changes

change_key varchar(60) created_on timestamplast_updated_on timestampowner_account_id int(11)dest_project_name varchar(255)dest_branch_name varchar(255)status char(1)current_patch_set_id int(11)subject varchar(255)topic varchar(255)row_version int(11)change_id int(11)original_subject varchar(255)submission_id varchar(255)

repo_CR_info

ID bigint(20) REPO varchar(255)CR tinyint(4)PEER_REVIEW tinyint(4)ICAFE_CARD tinyint(4)PDB bigint(20)CI tinyint(4)WORK_FLOW varchar(255)TYPE varchar(255)UPDATE_AT datetimeSTYLE_CHECK tinyint(4)SECURITY_CHECK tinyint(4)STATIC_CHECK tinyint(4)

1:nchange_id = change_id

change_msg

group_audit

ID bigint(20) GROUP_ID bigint(20)GROUP_NAME varchar(255)OPERATOR varchar(255)OPERATION_TYPE varchar(30)DETAIL textGMT_CREATE datetimeGMT_MODIFIED datetime

log日志管理表

id：自增id user_id：管理员idusername：管理员名字realname：管理员名字ip：操作的IP地址（可能会有IPv6？）operator_id:操作人idoperation：操作模块名（操作标题）content：操作描述（详细描述）created_at：操作时间

1:nID = GROUP_ID

repo_group_relation

ID bigint(20)REPO_ID bigint(20)GROUP_ID bigint(20)ROLE varchar(25)GMT_CREATE datetimeGMT_MODIFIED datetime

favorite_repo

ID bigint(20) REPO_ID bigint(20)USER_NAME varchar(255)GMT_CREATE datetimeGMT_MODIFIED datetime