Schema
Owner
arboretum
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 |
---|---|---|---|---|---|---|
btree |
|
org_id |
|
|||
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 |
---|---|---|---|---|---|---|---|---|---|---|
usr_org_id |
org_id |
No Action |
No Action |
|
Immediate |
Rattachement d'une organisation à un utilisateur. |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
1 |
Pages |
1 |
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) at 07/12/2018 13:23 |