seamdb_final 15th of April 2009
Previous topic Chapter index Next topic

Table: role_permissions

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

There is no description for table role_permissions

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

role__id

bigint

 

 

 

 

permission_id

bigint

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fk1c07be3b436098f5

permission_id

public.permission

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table role_permissions

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

role_permissions_pkey

btree

 

role__id, permission_id

 

 

Triggers

There are no triggers for table role_permissions

 

Rules

There are no rules for table role_permissions

 

Referenced

There are no tables referenced by table role_permissions

 

Options

Option

Value

Inherited From

 

Rows

3553

Pages

21

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."role_permissions" (
 "role__id" BIGINT NOT NULL,
 "permission_id" BIGINT NOT NULL,
 CONSTRAINT "role_permissions_pkey" PRIMARY KEY("role__id", "permission_id"),
 CONSTRAINT "fk1c07be3b436098f5" FOREIGN KEY ("permission_id")
   REFERENCES "public"."permission"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) WITH OIDS;

This file was generated by Erling Andersen eran@life.ku.dk
Previous topic Chapter index Next topic