db_toff on pggeodb.nancy.inra.fr |
|
Table: t_formulaire_access_configuration_faconf
db_toff on pggeodb.nancy.inra.fr |
|
Table: t_formulaire_access_configuration_faconf
Schema
Owner
toff
Tablespace
(default)
Descriptions
table contenant une partie de la configuration de l'application access.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
faconf_id |
serial |
|
|
|
nextval('t_formulaire_access_configuration_faconf_faconf_id_seq'::regclass) |
identifiant de la configuration. |
|
|
faconf_sgbd |
varchar(100) |
|
|
|
|
nom du sgbd utilisé. |
|
|
faconf_version |
varchar(4) |
|
|
|
|
version du sgbd utilisé. |
|
|
faconf_odbc |
boolean |
|
|
|
|
booléan indiquant si l'application est connectée à la base en mode odbc. |
|
|
faconf_deconnecte |
boolean |
|
|
|
|
booléan indiquant si l'application est connectée à la base en mode déconnecté. |
|
|
faconf_database |
varchar(100) |
|
|
|
|
nom de la base de donnée utilsée. |
|
|
faconf_role_ecriture |
varchar(100) |
|
|
|
|
nom du rôle ayant les droits en écriture. |
Foreign Keys
There are no foreign keys for table t_formulaire_access_configuration_faconf
Check Constraints
There are no check constraints for table t_formulaire_access_configuration_faconf
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
faconf_id |
|
|
|
Triggers
There are no triggers for table t_formulaire_access_configuration_faconf
Rules
There are no rules for table t_formulaire_access_configuration_faconf
Policies
There are no policies for table t_formulaire_access_configuration_faconf
Referenced
There are no tables referenced by table t_formulaire_access_configuration_faconf
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
faconf_id SERIAL,
faconf_sgbd VARCHAR(100) NOT NULL,
faconf_version VARCHAR(4),
faconf_odbc BOOLEAN NOT NULL,
faconf_deconnecte BOOLEAN NOT NULL,
faconf_database VARCHAR(100) NOT NULL,
faconf_role_ecriture VARCHAR(100),
CONSTRAINT c_pk_faconf PRIMARY KEY(faconf_id)
)
WITH (oids = false);
COMMENT ON TABLE public.t_formulaire_access_configuration_faconf
IS 'table contenant une partie de la configuration de l''application access.';
COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_id
IS 'identifiant de la configuration.';
COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_sgbd
IS 'nom du sgbd utilisé.';
COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_version
IS 'version du sgbd utilisé.';
COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_odbc
IS 'booléan indiquant si l''application est connectée à la base en mode odbc.';
COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_deconnecte
IS 'booléan indiquant si l''application est connectée à la base en mode déconnecté.';
COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_database
IS 'nom de la base de donnée utilsée.';
COMMENT ON COLUMN public.t_formulaire_access_configuration_faconf.faconf_role_ecriture
IS 'nom du rôle ayant les droits en écriture.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17 |
|