db_ecological_db |
|
Table: t_user_usr
db_ecological_db |
|
Table: t_user_usr
Schema
Owner
ecological_db
Tablespace
(default)
Descriptions
Table containing the users having the right to connect to the application.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
usr_id |
serial |
|
|
|
nextval('application.t_user_usr_usr_id_seq'::regclass) |
User ID (postgres). |
|
|
usr_login |
varchar(255) |
|
|
|
|
User login. |
|
|
usr_password |
varchar(255) |
|
|
|
|
User password. |
|
|
usr_mail |
varchar(255) |
|
|
|
|
User mail. |
|
|
usr_activation_code |
varchar(255) |
|
|
|
|
Activation code generated during account validation and allowing the user to create his login and password. |
|
|
usr_blocked |
boolean |
|
|
|
false |
Boolean indicating whether the user has had their account request refused or if their account is blocked. |
Foreign Keys
There are no foreign keys for table t_user_usr
Check Constraints
There are no check constraints for table t_user_usr
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
usr_id |
|
|
|
|
btree |
|
usr_login |
|
|
Uniqueness on the user's login. |
|
btree |
|
usr_mail |
|
|
Uniqueness on the user's mail. |
Triggers
There are no triggers for table t_user_usr
Rules
There are no rules for table t_user_usr
Policies
There are no policies for table t_user_usr
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
urol_usr_id |
usr_id |
Cascade |
No Action |
|
Immediate |
Associating a user account with a role. |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
usr_id SERIAL,
usr_login VARCHAR(255),
usr_password VARCHAR(255),
usr_mail VARCHAR(255) NOT NULL,
usr_activation_code VARCHAR(255),
usr_blocked BOOLEAN DEFAULT false NOT NULL,
CONSTRAINT c_pk_t_user_usr PRIMARY KEY(usr_id),
CONSTRAINT c_uni_login_usr UNIQUE(usr_login),
CONSTRAINT c_uni_mail_usr UNIQUE(usr_mail)
) ;
COMMENT ON TABLE application.t_user_usr
IS 'Table containing the users having the right to connect to the application.';
COMMENT ON COLUMN application.t_user_usr.usr_id
IS 'User ID (postgres).';
COMMENT ON COLUMN application.t_user_usr.usr_login
IS 'User login.';
COMMENT ON COLUMN application.t_user_usr.usr_password
IS 'User password.';
COMMENT ON COLUMN application.t_user_usr.usr_mail
IS 'User mail.';
COMMENT ON COLUMN application.t_user_usr.usr_activation_code
IS 'Activation code generated during account validation and allowing the user to create his login and password.';
COMMENT ON COLUMN application.t_user_usr.usr_blocked
IS 'Boolean indicating whether the user has had their account request refused or if their account is blocked.';
COMMENT ON CONSTRAINT c_uni_login_usr ON application.t_user_usr
IS 'Uniqueness on the user''s login.';
COMMENT ON CONSTRAINT c_uni_mail_usr ON application.t_user_usr
IS 'Uniqueness on the user''s mail.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|