gerrit 2.12.x 版本 数据库表介绍 之 postgresql
下面是2.12.x版本的 数据库表
List of relations
TABLE_SCHEM | TABLE_NAME | TABLE_TYPE
------------+-----------------------------+-----------
public | account_external_ids | TABLE
public | account_group_by_id | TABLE
public | account_group_by_id_aud | TABLE
public | account_group_members | TABLE
public | account_group_members_audit | TABLE
public | account_group_names | TABLE
public | account_groups | TABLE
public | account_patch_reviews | TABLE
public | account_project_watches | TABLE
public | account_ssh_keys | TABLE
public | accounts | TABLE
public | change_messages | TABLE
public | changes | TABLE
public | patch_comments | TABLE
public | patch_set_approvals | TABLE
public | patch_sets | TABLE
public | schema_version | TABLE
public | starred_changes | TABLE
public | submodule_subscriptions | TABLE
public | system_config | TABLE
accounts表
这个表是保存账号相关信息的
SELECT ordinal_position,column_name, data_type, column_default FROM information_schema.columns WHERE table_name ='accounts';
ordinal_position | column_name | data_type | column_default
-----------------+-------------------------------+--------------------------+---------------
1 | registered_on | timestamp with time zone | NULL
2 | full_name | character varying | NULL
3 | preferred_email | character varying | NULL
5 | maximum_page_size | smallint | 0
6 | show_site_header | character | 'N'::bpchar
7 | use_flash_clipboard | character | 'N'::bpchar
8 | download_url | character varying | NULL
9 | download_command | character varying | NULL
10 | copy_self_on_email | character | 'N'::bpchar
11 | date_format | character varying | NULL
12 | time_format | character varying | NULL
13 | relative_date_in_change_table | character | 'N'::bpchar
14 | diff_view | character varying | NULL
15 | size_bar_in_change_table | character | 'N'::bpchar
16 | legacycid_in_change_table | character | 'N'::bpchar
17 | review_category_strategy | character varying | NULL
18 | mute_common_path_prefixes | character | 'N'::bpchar
19 | inactive | character | 'N'::bpchar
20 | account_id | integer | 0
select account_id, full_name, preferred_email from accounts where account_id=1000000;
account_id | full_name | preferred_email
------------+------------+--------------------------
1000000 | xxxxxxx xx | xxxxxx.xx@xxxxxxxxx.com
account_id 是个数字,第一次登录gerrit的时候会自动分配一个,这个基本上是账号的唯一标识了。第一个登录的账号id是1000000,后续的依次累加。
full_name 是 全名,显示的名称,和登录时候填写的账号可以是不一样的,这里也可以是中文的,如果是用的ldap认证的,这里就是ldap里面的全名。
preferred_email 是邮箱地址,如果是用的ldap认证的,这里就是ldap里面的邮箱。
inactive 表示这个账号是否可用,取值 'N' 和 'Y', N表示不能使用,不能登录,不能访问ssh下代码等。表示账号被禁用。离职的员工可用把账号禁用了。
account_external_ids 表
SELECT ordinal_position,column_name, data_type, column_default FROM information_schema.columns WHERE table_name ='account_external_ids';
ordinal_position | column_name | data_type | column_default
-----------------+---------------+-------------------+----------------------
1 | account_id | integer | 0
2 | email_address | character varying | NULL
3 | password | character varying | NULL
4 | external_id | character varying | ''::character varying
account_groups 表
这个是群组相关的表。还有个account_group_names表和他对应的,这个表只存放了群组名称。
SELECT ordinal_position,column_name, data_type, column_default FROM information_schema.columns WHERE table_name ='account_groups';
ordinal_position | column_name | data_type