Dumped on 2021-09-06
F-Key | Name | Type | Description |
---|---|---|---|
dos_id | integer | PRIMARY KEY DEFAULT nextval(('dossier_id'::text)::regclass) | |
dos_name | text | UNIQUE NOT NULL | |
dos_description | text | ||
dos_email | integer |
DEFAULT '-1'::integer
Max emails per day : 0 none , -1 unlimited or max value |
Tables referencing this one via Foreign Key Constraints:
F-Key | Name | Type | Description |
---|---|---|---|
use_id | integer | PRIMARY KEY DEFAULT nextval(('users_id'::text)::regclass) | |
use_first_name | text | ||
use_name | text | ||
use_login | text | UNIQUE NOT NULL | |
use_active | integer | ||
use_pass | text | ||
use_admin | integer | ||
use_email | text |
Email of the user |
Name | Constraint |
---|---|
ac_users_use_active_check | CHECK (((use_active = 0) OR (use_active = 1))) |
Tables referencing this one via Foreign Key Constraints:
F-Key | Name | Type | Description |
---|---|---|---|
ac_id | serial | PRIMARY KEY | |
ac_user | text | ||
ac_date | timestamp without time zone | DEFAULT now() | |
ac_ip | text | ||
ac_state | text | ||
ac_module | text | ||
ac_url | text |
Name | Constraint |
---|---|
valid_state | CHECK ((ac_state = ANY (ARRAY['FAIL'::text, 'SUCCESS'::text, 'AUDIT'::text, 'ADMIN'::text]))) |
Count the sent email by folder
F-Key | Name | Type | Description |
---|---|---|---|
id | serial |
PRIMARY KEY
primary key |
|
de_date | character varying(8) |
UNIQUE#1
NOT NULL
Date YYYYMMDD |
|
de_sent_email | integer |
NOT NULL
Number of sent emails |
|
ac_dossier.dos_id | dos_id | integer |
UNIQUE#1
NOT NULL
Link to ac_dossier |
F-Key | Name | Type | Description |
---|---|---|---|
jnt_id | integer | PRIMARY KEY DEFAULT nextval(('seq_jnt_use_dos'::text)::regclass) | |
ac_users.use_id | use_id | integer | UNIQUE#1 NOT NULL |
ac_dossier.dos_id | dos_id | integer | UNIQUE#1 NOT NULL |
F-Key | Name | Type | Description |
---|---|---|---|
mod_id | integer | PRIMARY KEY DEFAULT nextval(('s_modid'::text)::regclass) | |
mod_name | text | NOT NULL | |
mod_desc | text |
F-Key | Name | Type | Description |
---|---|---|---|
p_id | character varying(16) | PRIMARY KEY | |
p_value | numeric(5,2) | NOT NULL | |
p_created | timestamp without time zone | DEFAULT now() |
F-Key | Name | Type | Description |
---|---|---|---|
ac_users.use_id | use_id | bigint | NOT NULL |
request | text | PRIMARY KEY | |
password | text | NOT NULL | |
created_on | timestamp with time zone | ||
created_host | text | ||
recover_on | timestamp with time zone | ||
recover_by | text |
F-Key | Name | Type | Description |
---|---|---|---|
the_name | text | NOT NULL | |
the_filestyle | text | ||
the_filebutton | text |
The user's global parameter
F-Key | Name | Type | Description |
---|---|---|---|
ac_users.use_login | user_id | text |
PRIMARY KEY
user's login |
parameter_type | text |
PRIMARY KEY
the type of parameter |
|
parameter_value | text |
the value of parameter |
F-Key | Name | Type | Description |
---|---|---|---|
val | integer | PRIMARY KEY |
begin NEW.ac_user := substring(NEW.ac_user from 1 for 80); return NEW; end;
declare is_mono integer; begin select count (*) into is_mono from information_schema.tables where table_name='repo_version'; if is_mono = 1 then update repo_version set val=p_version; else update version set val=p_version; end if; end;
Generated by PostgreSQL Autodoc