Dumped on 2014-07-01

Index of database - coprdb


Table: action

action Structure
F-Key Name Type Description
id serial PRIMARY KEY
action_type integer NOT NULL
object_type character varying(20)
object_id integer
old_value character varying(255)
new_value character varying(255)
data text
result integer
message text
created_on integer
ended_on integer

Index - Schema public


Table: alembic_version

alembic_version Structure
F-Key Name Type Description
version_num character varying(32) NOT NULL

Index - Schema public


Table: build

build Structure
F-Key Name Type Description
id serial PRIMARY KEY
pkgs text
canceled boolean
repos text
submitted_on integer NOT NULL
started_on integer
ended_on integer
results text
memory_reqs integer
timeout integer
user.id user_id integer
copr.id copr_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: build_chroot

build_chroot Structure
F-Key Name Type Description
mock_chroot.id mock_chroot_id integer PRIMARY KEY
build.id build_id integer PRIMARY KEY
status integer

Index - Schema public


Table: copr

copr Structure
F-Key Name Type Description
id serial PRIMARY KEY
name character varying(100) NOT NULL
repos text
created_on integer
description text
instructions text
deleted boolean
playground boolean
user.id owner_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: copr_chroot

copr_chroot Structure
F-Key Name Type Description
buildroot_pkgs text
mock_chroot.id mock_chroot_id integer PRIMARY KEY
copr.id copr_id integer PRIMARY KEY

Index - Schema public


Table: copr_permission

copr_permission Structure
F-Key Name Type Description
copr_builder smallint
copr_admin smallint
user.id user_id integer PRIMARY KEY
copr.id copr_id integer PRIMARY KEY

Index - Schema public


Table: legal_flag

legal_flag Structure
F-Key Name Type Description
id serial PRIMARY KEY
raise_message text
raised_on integer
resolved_on integer
copr.id copr_id integer
user.id reporter_id integer
user.id resolver_id integer

Index - Schema public


Table: mock_chroot

mock_chroot Structure
F-Key Name Type Description
id serial PRIMARY KEY
os_release character varying(50) NOT NULL
os_version character varying(50) NOT NULL
arch character varying(50) NOT NULL
is_active boolean

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: user

user Structure
F-Key Name Type Description
id serial PRIMARY KEY
openid_name character varying(100) NOT NULL
mail character varying(150) NOT NULL
timezone character varying(50)
proven boolean
admin boolean
api_login character varying(40) NOT NULL
api_token character varying(40) NOT NULL
api_token_expiration date NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict