Datadictionary OpenWave 3.1.30
Previous topic Chapter index Next topic

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

 

 

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
Previous topic Chapter index Next topic