db_globoxylo
Previous topic Chapter index Next topic

Table: t_organisation_org

 

 

Schema

application

 

Owner

globoxylo

 

Tablespace

(default)

 

Descriptions

Table contenant les organisations (Centre INRAe pour le LDAP INRAe).

 

Columns

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

org_id

serial

 

nextval('application.t_organisation_org_org_id_seq'::regclass)

Identifiant de l'organisation (postgres).

 

 

org_ldap_uid

varchar(100)

 

 

 

 

Identifiant LDAP de l'organisation.

 

 

org_code

varchar(100)

 

 

Code de l'organisation.

 

 

org_libelle

varchar(255)

 

 

 

Libellé de l'organisation.

 

Foreign Keys

There are no foreign keys for table t_organisation_org

 

Check Constraints

There are no check constraints for table t_organisation_org

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

c_pk_t_organisation_org

btree

 

org_id

 

c_uni_code_org

btree

 

org_code

 

Contrainte d'unicité sur le code de l'organisation.

 

Triggers

There are no triggers for table t_organisation_org

 

Rules

There are no rules for table t_organisation_org

 

Policies

There are no policies for table t_organisation_org

 

Referenced

Table

Schema

Foreign Key

Columns

FK Table

FK Columns

Delete Action

Update Action

Deferrable

Check Time

Description

t_utilisateur_usr

application

c_fk_usr_org

usr_org_id

application.t_organisation_org

org_id

No Action

No Action

 

Immediate

Rattachement d'une organisation à un utilisateur.

 

Properties

Property

Value

Inherited From

 

Rows

-1

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE application.t_organisation_org (
 org_id SERIAL,
 org_ldap_uid VARCHAR(100),
 org_code VARCHAR(100) NOT NULL,
 org_libelle VARCHAR(255) NOT NULL,
 CONSTRAINT c_pk_t_organisation_org PRIMARY KEY(org_id),
 CONSTRAINT c_uni_code_org UNIQUE(org_code)
) ;

COMMENT ON TABLE application.t_organisation_org
IS 'Table contenant les organisations (Centre INRAe pour le LDAP INRAe).';

COMMENT ON COLUMN application.t_organisation_org.org_id
IS 'Identifiant de l''organisation (postgres).';

COMMENT ON COLUMN application.t_organisation_org.org_ldap_uid
IS 'Identifiant LDAP de l''organisation.';

COMMENT ON COLUMN application.t_organisation_org.org_code
IS 'Code de l''organisation.';

COMMENT ON COLUMN application.t_organisation_org.org_libelle
IS 'Libellé de l''organisation.';

COMMENT ON CONSTRAINT c_uni_code_org ON application.t_organisation_org
IS 'Contrainte d''unicité sur le code de l''organisation.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)
Previous topic Chapter index Next topic