Datadictionary OpenWave 3.1.25 |
|
Table: tbmedewdevices
Datadictionary OpenWave 3.1.25 |
|
Table: tbmedewdevices
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Devices die zijn toegekend aan de medewerker in kader van 2 factor authentication
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmedewdevices_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcodemedewerkers |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode. |
|
|
dvunlockcookie |
varchar(100) |
|
|
|
|
Kopie van cookie op device waarmee medewerker ooit is ingelogd. |
|
|
ddeunlockcookie |
timestamp |
|
|
|
|
Datum + tijdstip waarop dvunlockcookie voor het eerst is gebruikt. |
|
|
dvunlockuseragent |
varchar(2000) |
|
|
|
|
Apparaat en usergegevens behorende bij dvunlockcookie. |
|
|
dvremote_ip |
varchar(50) |
|
|
|
|
Ip-adres waarv de cookie wordt festald. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmedewdevices_codemedew |
dvcodemedewerkers |
dvcode |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmedewdevices_dvcodemedew |
dvcodemedewerkers IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmedewdevices |
btree |
|
dnkey |
|
|
|
idx_tbmedewdevices_dvcodemw |
btree |
|
dvcodemedewerkers |
|
|
|
Triggers
There are no triggers for table tbmedewdevices
Rules
There are no rules for table tbmedewdevices
Policies
There are no policies for table tbmedewdevices
Referenced
There are no tables referenced by table tbmedewdevices
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcodemedewerkers CHAR(5),
dvunlockcookie VARCHAR(100),
ddeunlockcookie TIMESTAMP WITHOUT TIME ZONE,
dvunlockuseragent VARCHAR(2000),
dvremote_ip VARCHAR(50),
CONSTRAINT cpk_tbmedewdevices PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmedewdevices_dvcodemedew CHECK (dvcodemedewerkers IS NOT NULL),
CONSTRAINT cfk_tbmedewdevices_codemedew FOREIGN KEY (dvcodemedewerkers)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmedewdevices
IS 'Devices die zijn toegekend aan de medewerker in kader van 2 factor authentication';
COMMENT ON COLUMN public.tbmedewdevices.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmedewdevices.dvcodemedewerkers
IS 'Foreign key naar tbmedewerkers.dvcode.';
COMMENT ON COLUMN public.tbmedewdevices.dvunlockcookie
IS 'Kopie van cookie op device waarmee medewerker ooit is ingelogd.';
COMMENT ON COLUMN public.tbmedewdevices.ddeunlockcookie
IS 'Datum + tijdstip waarop dvunlockcookie voor het eerst is gebruikt.';
COMMENT ON COLUMN public.tbmedewdevices.dvunlockuseragent
IS 'Apparaat en usergegevens behorende bij dvunlockcookie.';
COMMENT ON COLUMN public.tbmedewdevices.dvremote_ip
IS 'Ip-adres waarv de cookie wordt festald.';
CREATE INDEX idx_tbmedewdevices_dvcodemw ON public.tbmedewdevices
USING btree (dvcodemedewerkers COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|