Datadictionary OpenWave 3.1.32 |
|
Table: tbswfoinpartners
Datadictionary OpenWave 3.1.32 |
|
Table: tbswfoinpartners
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met OIN ketenpartners voor de samenwerkingsruimte
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbswfoinpartners_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyswfruimte |
integer |
|
|
|
|
Foreign key naar tbswfruimte.dnkey. |
|
|
dnkeyoin |
integer |
|
|
|
|
Foreign key naar tboin.dnkey. |
|
|
dvprivilege |
varchar(20) |
|
|
|
|
VT (Volledige Toegang) of BT (Beperkte Toegang). Toegang tot documenten in het samenwerkingsdossier. |
|
|
dduitswf |
timestamp |
|
|
|
|
Datum dat ketenpartner (OIN-nummer) uit SWF-ruimte is verwijderd. |
|
|
ddtoegevoegd |
timestamp |
|
|
|
|
Datum dat ketenpartner (OIN-nummer) is toegevoegd in SWF-ruimte. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbswfoinpartners_keyoin |
dnkeyoin |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbswfoinpartners_keyswf |
dnkeyswfruimte |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbswfoinpartners_dnkeyoin |
dnkeyoin IS NOT NULL |
|
cnn_tbswfoinpartners_dnkeyswf |
dnkeyswfruimte IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbswfoinpartners |
btree |
|
dnkey |
|
|
|
idx_tbswfoinpartners_keyoin |
btree |
|
dnkeyoin |
|
|
|
idx_tbswfoinpartners_keyswf |
btree |
|
dnkeyswfruimte |
|
|
|
Triggers
There are no triggers for table tbswfoinpartners
Rules
There are no rules for table tbswfoinpartners
Policies
There are no policies for table tbswfoinpartners
Referenced
There are no tables referenced by table tbswfoinpartners
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyswfruimte INTEGER,
dnkeyoin INTEGER,
dvprivilege VARCHAR(20),
dduitswf TIMESTAMP WITHOUT TIME ZONE,
ddtoegevoegd TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbswfoinpartners PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbswfoinpartners_dnkeyoin CHECK (dnkeyoin IS NOT NULL),
CONSTRAINT cnn_tbswfoinpartners_dnkeyswf CHECK (dnkeyswfruimte IS NOT NULL),
CONSTRAINT cfk_tbswfoinpartners_keyoin FOREIGN KEY (dnkeyoin)
REFERENCES public.tboin(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbswfoinpartners_keyswf FOREIGN KEY (dnkeyswfruimte)
REFERENCES public.tbswfruimte(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbswfoinpartners
IS 'Tabel met OIN ketenpartners voor de samenwerkingsruimte';
COMMENT ON COLUMN public.tbswfoinpartners.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbswfoinpartners.dnkeyswfruimte
IS 'Foreign key naar tbswfruimte.dnkey.';
COMMENT ON COLUMN public.tbswfoinpartners.dnkeyoin
IS 'Foreign key naar tboin.dnkey.';
COMMENT ON COLUMN public.tbswfoinpartners.dvprivilege
IS 'VT (Volledige Toegang) of BT (Beperkte Toegang). Toegang tot documenten in het samenwerkingsdossier.';
COMMENT ON COLUMN public.tbswfoinpartners.dduitswf
IS 'Datum dat ketenpartner (OIN-nummer) uit SWF-ruimte is verwijderd.';
COMMENT ON COLUMN public.tbswfoinpartners.ddtoegevoegd
IS 'Datum dat ketenpartner (OIN-nummer) is toegevoegd in SWF-ruimte.';
CREATE INDEX idx_tbswfoinpartners_keyoin ON public.tbswfoinpartners
USING btree (dnkeyoin);
CREATE INDEX idx_tbswfoinpartners_keyswf ON public.tbswfoinpartners
USING btree (dnkeyswfruimte);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|