Datadictionary OpenWave 3.1.21 |
|
Table: tbrechtengroepmappen
Datadictionary OpenWave 3.1.21 |
|
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
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
)
WITH (oids = false);
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 2-10-2020 12:10 |
|