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 |
|||
|
|
dvaccess_token |
text |
|
|
|
|
De gegenereerde toegangs-token |
|
|
dnexpires_in |
integer |
|
|
|
|
Aantal seconden dat token in leven blijft na creatie |
|
|
dvtoken_type |
varchar(20) |
|
|
|
|
Type van token (zoals bearer) |
|
|
dddatetime_created |
timestamp |
|
|
|
|
datum + tijdstip van creatie van de token |
|
|
dninvoke_nbf_seconds |
integer |
|
|
|
|
Aantal seconden dat token nog niet gebruikt mah worden na dddatetime_created |
|
|
dvscope |
varchar(100) |
|
|
|
|
Toepassingsgebied van de token |
Foreign Keys
There are no foreign keys for table tbaccesstoken
Check Constraints
There are no check constraints for table tbaccesstoken
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
CREATE TABLE public.tbaccesstoken (
dnkey SERIAL,
dvaccess_token TEXT,
dnexpires_in INTEGER,
dvtoken_type VARCHAR(20),
dddatetime_created TIMESTAMP WITHOUT TIME ZONE,
dninvoke_nbf_seconds INTEGER,
dvscope VARCHAR(100),
CONSTRAINT cpk_tbaccesstoken PRIMARY KEY(dnkey)
) ;
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.dvaccess_token
IS 'De gegenereerde toegangs-token';
COMMENT ON COLUMN public.tbaccesstoken.dnexpires_in
IS 'Aantal seconden dat token in leven blijft na creatie';
COMMENT ON COLUMN public.tbaccesstoken.dvtoken_type
IS 'Type van token (zoals bearer)';
COMMENT ON COLUMN public.tbaccesstoken.dddatetime_created
IS 'datum + tijdstip van creatie van de token';
COMMENT ON COLUMN public.tbaccesstoken.dninvoke_nbf_seconds
IS 'Aantal seconden dat token nog niet gebruikt mah worden na dddatetime_created';
COMMENT ON COLUMN public.tbaccesstoken.dvscope
IS 'Toepassingsgebied van de token';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 17-5-2024 15:06 |
![]() ![]() ![]() |