Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met OIN ketenpartners voor de samnewerkingsruimte
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. Toegang tot documenten in het samenwerkdossier.Foreign key naar tboin.dnkey. |
|
|
dduitswf |
timestamp |
|
|
|
|
Datum dat OIN-NUmmer uit de SWF is gehaald. |
|
|
ddtoegevoegd |
timestamp |
|
|
|
|
Datum dat 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
Referenced
There are no tables referenced by table tbswfoinpartners
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tbswfoinpartners (
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
)
WITH (oids = false);
COMMENT ON TABLE public.tbswfoinpartners
IS 'Tabel met OIN ketenpartners voor de samnewerkingsruimte ';
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. Toegang tot documenten in het samenwerkdossier.Foreign key naar tboin.dnkey.';
COMMENT ON COLUMN public.tbswfoinpartners.dduitswf
IS 'Datum dat OIN-NUmmer uit de SWF is gehaald.';
COMMENT ON COLUMN public.tbswfoinpartners.ddtoegevoegd
IS 'Datum dat 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-9-2021 14:10 |
![]() ![]() ![]() |