project_invitations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('project_invitations_id_seq'::regclass)
created_at timestamp 22 null
updated_at timestamp 22 null
expires_at timestamptz 28 null
uuid uuid 2147483647 null
current_uses int4 10 0
max_uses int4 10 null
project_id int4 10 null
projects.id project_invitations_project_id_foreignC
role_id int4 10 null
roles.id project_invitations_role_id_foreignR
add_to_sessions bool 1 false

Indexes

Constraint Name Type Sort Column(s)
project_invitations_pkey Primary key Asc id
project_invitations_uuid_unique Must be unique Asc uuid

Check Constraints

Constraint Name Constraint
check_max_uses (((max_uses IS NULL) OR (current_uses <= max_uses)))

Relationships