Datadictionary OpenWave 3.1.25 |
|
Table: tbrechtengroepmappen
Datadictionary OpenWave 3.1.25 |
|
Table: tbrechtengroepmappen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel gekoppel aan tbrechten voor autorisaties up- en download per map
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbrechtengroepmappen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyrechten |
integer |
|
|
|
|
Foreign key naar tbrechten.dbkey : de rechtengroep |
|
|
dvmapfileshare |
varchar(255) |
|
|
|
|
Map op fileshare waarvoor up- en downloadrechten gelden voor de rechtengroep |
|
|
dvmapcmis |
varchar(255) |
|
|
|
|
Map op cmis/afresco waarvoor up- en downloadrechten gelden voor de rechtengroep |
|
|
dldownload |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan is de rechtengroep geautoriseerd voor downloads vanaf de map |
|
|
dlupload |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan is de rechtengroep geautoriseerd voor uploads naar de map |
|
|
dvinfo |
varchar(255) |
|
|
|
|
Nadere beschrijving |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum tot wanneer de autoridatie geldig is. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_rechtengrmap_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_rechtengrmap_dldownload |
dldownload = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_rechtengrmap_dlupload |
dlupload = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_rechtengrmap_dldownload |
dldownload IS NOT NULL |
|
cnn_rechtengrmap_dlupload |
dlupload IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbrechtengroepmappen |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbrechtengroepmappen
Rules
There are no rules for table tbrechtengroepmappen
Policies
There are no policies for table tbrechtengroepmappen
Referenced
There are no tables referenced by table tbrechtengroepmappen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyrechten INTEGER,
dvmapfileshare VARCHAR(255),
dvmapcmis VARCHAR(255),
dldownload CHAR(1) DEFAULT 'F'::bpchar,
dlupload CHAR(1) DEFAULT 'F'::bpchar,
dvinfo VARCHAR(255),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbrechtengroepmappen PRIMARY KEY(dnkey),
CONSTRAINT chk_rechtengrmap_dldownload CHECK (dldownload = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_rechtengrmap_dlupload CHECK (dlupload = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_rechtengrmap_dldownload CHECK (dldownload IS NOT NULL),
CONSTRAINT cnn_rechtengrmap_dlupload CHECK (dlupload IS NOT NULL),
CONSTRAINT cfk_rechtengrmap_keyrechten FOREIGN KEY (dnkeyrechten)
REFERENCES public.tbrechten(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbrechtengroepmappen
IS 'Tabel gekoppel aan tbrechten voor autorisaties up- en download per map';
COMMENT ON COLUMN public.tbrechtengroepmappen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbrechtengroepmappen.dnkeyrechten
IS 'Foreign key naar tbrechten.dbkey : de rechtengroep';
COMMENT ON COLUMN public.tbrechtengroepmappen.dvmapfileshare
IS 'Map op fileshare waarvoor up- en downloadrechten gelden voor de rechtengroep ';
COMMENT ON COLUMN public.tbrechtengroepmappen.dvmapcmis
IS 'Map op cmis/afresco waarvoor up- en downloadrechten gelden voor de rechtengroep ';
COMMENT ON COLUMN public.tbrechtengroepmappen.dldownload
IS 'T of F. Indien T dan is de rechtengroep geautoriseerd voor downloads vanaf de map';
COMMENT ON COLUMN public.tbrechtengroepmappen.dlupload
IS 'T of F. Indien T dan is de rechtengroep geautoriseerd voor uploads naar de map';
COMMENT ON COLUMN public.tbrechtengroepmappen.dvinfo
IS 'Nadere beschrijving';
COMMENT ON COLUMN public.tbrechtengroepmappen.ddvervaldatum
IS 'Datum tot wanneer de autoridatie geldig is.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|