Package db2sdk provides common conversion routines from database types to codersdk types.

Package dbauthz provides an authorization layer on top of the database.

Code generated by coderd/database/gen/metrics.

package dbmock contains a mocked implementation of the database.Store interface for use in tests.

GenLockID generates a unique and consistent lock ID from a given string.

IsQueryCanceledError checks if the error is due to a query being canceled.

IsUniqueViolation checks if the error is due to a unique violation.

New creates a new database store using a SQL database connection.

Now returns a standardized timezone used for database resources.

Time returns a time compatible with Postgres.

Well-known lock IDs for lock functions in the database.

ALTER TABLE ONLY files ADD CONSTRAINT files_hash_created_by_key UNIQUE (hash, created_by);.

ALTER TABLE ONLY git_auth_links ADD CONSTRAINT git_auth_links_provider_id_user_id_key UNIQUE (provider_id, user_id);.

ALTER TABLE ONLY group_members ADD CONSTRAINT group_members_user_id_group_id_key UNIQUE (user_id, group_id);.

ALTER TABLE ONLY groups ADD CONSTRAINT groups_name_organization_id_key UNIQUE (name, organization_id);.

CREATE UNIQUE INDEX idx_api_key_name ON api_keys USING btree (user_id, token_name) WHERE (login_type = 'token'::login_type);.

CREATE UNIQUE INDEX idx_organization_name ON organizations USING btree (name);.

CREATE UNIQUE INDEX idx_organization_name_lower ON organizations USING btree (lower(name));.

CREATE UNIQUE INDEX idx_users_email ON users USING btree (email) WHERE (deleted = false);.

CREATE UNIQUE INDEX idx_users_username ON users USING btree (username) WHERE (deleted = false);.

ALTER TABLE ONLY licenses ADD CONSTRAINT licenses_jwt_key UNIQUE (jwt);.

ALTER TABLE ONLY parameter_schemas ADD CONSTRAINT parameter_schemas_job_id_name_key UNIQUE (job_id, name);.

ALTER TABLE ONLY parameter_values ADD CONSTRAINT parameter_values_scope_id_name_key UNIQUE (scope_id, name);.

ALTER TABLE ONLY provisioner_daemons ADD CONSTRAINT provisioner_daemons_name_key UNIQUE (name);.

ALTER TABLE ONLY site_configs ADD CONSTRAINT site_configs_key_key UNIQUE (key);.

CREATE UNIQUE INDEX templates_organization_id_name_idx ON templates USING btree (organization_id, lower((name)::text)) WHERE (deleted = false);.

ALTER TABLE ONLY template_version_parameters ADD CONSTRAINT template_version_parameters_template_version_id_name_key UNIQUE (template_version_id, name);.

ALTER TABLE ONLY template_versions ADD CONSTRAINT template_versions_template_id_name_key UNIQUE (template_id, name);.

ALTER TABLE ONLY template_version_variables ADD CONSTRAINT template_version_variables_template_version_id_name_key UNIQUE (template_version_id, name);.

CREATE UNIQUE INDEX users_email_lower_idx ON users USING btree (lower(email)) WHERE (deleted = false);.

CREATE UNIQUE INDEX users_username_lower_idx ON users USING btree (lower(username)) WHERE (deleted = false);.

ALTER TABLE ONLY workspace_apps ADD CONSTRAINT workspace_apps_agent_id_slug_idx UNIQUE (agent_id, slug);.

ALTER TABLE ONLY workspace_build_parameters ADD CONSTRAINT workspace_build_parameters_workspace_build_id_name_key UNIQUE (workspace_build_id, name);.

ALTER TABLE ONLY workspace_builds ADD CONSTRAINT workspace_builds_job_id_key UNIQUE (job_id);.

ALTER TABLE ONLY workspace_builds ADD CONSTRAINT workspace_builds_workspace_id_build_number_key UNIQUE (workspace_id, build_number);.

CREATE UNIQUE INDEX workspace_proxies_lower_name_idx ON workspace_proxies USING btree (lower(name)) WHERE (deleted = false);.

ALTER TABLE ONLY workspace_resource_metadata ADD CONSTRAINT workspace_resource_metadata_name UNIQUE (workspace_resource_id, key);.

CREATE UNIQUE INDEX workspaces_owner_id_lower_idx ON workspaces USING btree (owner_id, lower((name)::text)) WHERE (deleted = false);.

This is also in codersdk/workspaceagents.go and should be kept in sync.

This is also in codersdk/workspaceagents.go and should be kept in sync.

This is also in codersdk/workspaceagents.go and should be kept in sync.

This is also in codersdk/workspaceagents.go and should be kept in sync.

AuditOAuthConvertState is never stored in the database.

We keep this separate from replicas in case we need to break the coordinator out into its own service.

Joins in the username + avatar url of the created by user.

Visible fields of users are allowed to be joined with other tables for including context of other resources.

DBTX represents a database connection or transaction.

Store contains all queryable database functions.

Specifies the method of authentication.

TemplateACL is a map of ids to permissions.

UniqueConstraint represents a named unique constraint on a table.