Schema
Owner
albenard
Tablespace
(default)
Descriptions
There is no description for table module
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
idmodule |
serial |
|
nextval('module_idmodule_seq'::regclass) |
|
|||
|
|
libelle |
varchar(128) |
|
|
|
||
|
|
mod_nom_court |
varchar(20) |
|
|
2-12-2009. forme courte pour session |
Foreign Keys
There are no foreign keys for table module
Check Constraints
There are no check constraints for table module
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
libelle |
|
|
||
btree |
|
mod_nom_court |
|
|
||
btree |
|
idmodule |
|
Triggers
There are no triggers for table module
Rules
There are no rules for table module
Policies
There are no policies for table module
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
idmodule |
idmodule |
No Action |
No Action |
|
Immediate |
|
||||
table_module_fid |
idmodule |
Restrict |
Restrict |
|
Immediate |
|
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
5 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.module (
idmodule SERIAL,
libelle VARCHAR(128) NOT NULL,
mod_nom_court VARCHAR(20) NOT NULL,
CONSTRAINT module_libelle_key UNIQUE(libelle),
CONSTRAINT module_mod_nom_court_key UNIQUE(mod_nom_court),
CONSTRAINT pk_module PRIMARY KEY(idmodule)
) ;
COMMENT ON COLUMN public.module.mod_nom_court
IS '2-12-2009. forme courte pour session';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |