Datadictionary OpenWave 3.1.32 |
|
Table: tbaccesstoken
Datadictionary OpenWave 3.1.32 |
|
Table: tbaccesstoken
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met uitgegeven tokens ten behove van ZGW-API aanroepen. Rijen worden opgeschoond op grond van instelling
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbaccesstoken_dnkey_seq'::regclass) |
Primary key |
|
|
dvtoken_type |
varchar(20) |
|
|
|
|
Type van token (zoals bearer) |
|
|
dvtoken |
varchar(4000) |
|
|
|
|
De gegenereerde toegangs-token |
|
|
ddvalidfrom |
timestamp |
|
|
|
|
Datum + tijdstip van creatie van de token |
|
|
ddvaliduntil |
timestamp |
|
|
|
|
Datum + tijdstip tot wanneer token geldig is |
|
|
dvcodemedewerker |
char(5) |
|
|
|
|
Foriegn key naar tbmedewerker.dvcode voor wie de token is uitgegeven |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbaccesstoken_dvcodemedewerker |
dvcodemedewerker |
dvcode |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbaccesstoken_dvcodemedewerker |
dvcodemedewerker IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbaccesstoken |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbaccesstoken
Rules
There are no rules for table tbaccesstoken
Policies
There are no policies for table tbaccesstoken
Referenced
There are no tables referenced by table tbaccesstoken
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvtoken_type VARCHAR(20),
dvtoken VARCHAR(4000),
ddvalidfrom TIMESTAMP WITHOUT TIME ZONE,
ddvaliduntil TIMESTAMP WITHOUT TIME ZONE,
dvcodemedewerker CHAR(5),
CONSTRAINT cpk_tbaccesstoken PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbaccesstoken_dvcodemedewerker CHECK (dvcodemedewerker IS NOT NULL),
CONSTRAINT cfk_tbaccesstoken_dvcodemedewerker FOREIGN KEY (dvcodemedewerker)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbaccesstoken
IS 'Tabel met uitgegeven tokens ten behove van ZGW-API aanroepen. Rijen worden opgeschoond op grond van instelling';
COMMENT ON COLUMN public.tbaccesstoken.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbaccesstoken.dvtoken_type
IS 'Type van token (zoals bearer)';
COMMENT ON COLUMN public.tbaccesstoken.dvtoken
IS 'De gegenereerde toegangs-token';
COMMENT ON COLUMN public.tbaccesstoken.ddvalidfrom
IS 'Datum + tijdstip van creatie van de token';
COMMENT ON COLUMN public.tbaccesstoken.ddvaliduntil
IS 'Datum + tijdstip tot wanneer token geldig is';
COMMENT ON COLUMN public.tbaccesstoken.dvcodemedewerker
IS 'Foriegn key naar tbmedewerker.dvcode voor wie de token is uitgegeven';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|