db_venik |
|
Table: user_group
db_venik |
|
Table: user_group
Schema
Owner
albenard
Tablespace
(default)
Descriptions
creee le 12-01-2011
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
group_name |
varchar(20) |
|
|
|
|
|
|
|
group_log |
varchar(20) |
|
|
|
|
|
|
|
group_pwd |
varchar(100) |
|
|
|
|
|
|
|
group_id |
serial |
|
|
|
nextval('user_group_group_id_seq'::regclass) |
|
Foreign Keys
There are no foreign keys for table user_group
Check Constraints
There are no check constraints for table user_group
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
group_id |
|
|
|
|
btree |
|
group_log |
|
|
|
|
btree |
|
group_name |
|
|
|
|
btree |
|
group_id |
|
|
|
Triggers
There are no triggers for table user_group
Rules
There are no rules for table user_group
Policies
There are no policies for table user_group
Referenced
There are no tables referenced by table user_group
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
4 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
|
Definition
group_name VARCHAR(20) NOT NULL,
group_log VARCHAR(20) NOT NULL,
group_pwd VARCHAR(100) NOT NULL,
group_id SERIAL,
CONSTRAINT user_group_group_id_key UNIQUE(group_id),
CONSTRAINT user_group_groupe_log_key UNIQUE(group_log),
CONSTRAINT user_group_groupe_name_key UNIQUE(group_name),
CONSTRAINT user_group_pkey PRIMARY KEY(group_id)
) ;
COMMENT ON TABLE public.user_group
IS 'creee le 12-01-2011';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|