Datadictionary OpenWave 3.1.25 |
|
Table: tbsession
Datadictionary OpenWave 3.1.25 |
|
Table: tbsession
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel bevat de sessies in gebruik
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbsession_dnkey_seq'::regclass) |
Primary key. |
|
|
dvuuid |
varchar(40) |
|
|
|
|
Uniek ID van de sessie |
|
|
dvcodemedewerkers |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode. not null |
|
|
dntype |
integer |
|
|
|
|
|
|
|
ddcreated |
timestamp |
|
|
|
now()::timestamp without time zone |
Datum/tijd waarop de kaart gecreeerd is. Aan de hand van deze tijd kan bijv. besloten worden dat de sessie verlopen is. |
|
|
ddinvoked |
timestamp |
|
|
|
now()::timestamp without time zone |
Datum/tijd waarop de kaart voor het laatst gelezen is. Aan de hand van deze tijd kan bijv. besloten worden dat de sessie verlopen is. |
|
|
dvremote_ip |
varchar(50) |
|
|
|
|
Ip-adres waarvandaan is ingelogd. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbsession_codemedew |
dvcodemedewerkers |
dvcode |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbsession_ddcreated |
ddcreated IS NOT NULL |
|
cnn_tbsession_ddinvoked |
ddinvoked IS NOT NULL |
|
cnn_tbsession_dvcodemedew |
dvcodemedewerkers IS NOT NULL |
|
cnn_tbsession_dvuuid |
dvuuid IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbsession |
btree |
|
dnkey |
|
|
|
idu_tbsession_dvuuid |
btree |
|
dvuuid |
|
|
|
idx_tbsession_ddinvoked |
btree |
|
ddinvoked |
|
|
|
idx_tbsession_dvcodemedew |
btree |
|
dvcodemedewerkers |
|
|
|
Triggers
There are no triggers for table tbsession
Rules
There are no rules for table tbsession
Policies
There are no policies for table tbsession
Referenced
There are no tables referenced by table tbsession
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvuuid VARCHAR(40),
dvcodemedewerkers CHAR(5),
dntype INTEGER,
ddcreated TIMESTAMP WITHOUT TIME ZONE DEFAULT now()::timestamp without time zone,
ddinvoked TIMESTAMP WITHOUT TIME ZONE DEFAULT now()::timestamp without time zone,
dvremote_ip VARCHAR(50),
CONSTRAINT cpk_tbsession PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbsession_ddcreated CHECK (ddcreated IS NOT NULL),
CONSTRAINT cnn_tbsession_ddinvoked CHECK (ddinvoked IS NOT NULL),
CONSTRAINT cnn_tbsession_dvcodemedew CHECK (dvcodemedewerkers IS NOT NULL),
CONSTRAINT cnn_tbsession_dvuuid CHECK (dvuuid IS NOT NULL),
CONSTRAINT cfk_tbsession_codemedew FOREIGN KEY (dvcodemedewerkers)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbsession
IS 'Tabel bevat de sessies in gebruik';
COMMENT ON COLUMN public.tbsession.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbsession.dvuuid
IS 'Uniek ID van de sessie';
COMMENT ON COLUMN public.tbsession.dvcodemedewerkers
IS 'Foreign key naar tbmedewerkers.dvcode. not null';
COMMENT ON COLUMN public.tbsession.ddcreated
IS 'Datum/tijd waarop de kaart gecreeerd is. Aan de hand van deze tijd kan bijv. besloten worden dat de sessie verlopen is.';
COMMENT ON COLUMN public.tbsession.ddinvoked
IS 'Datum/tijd waarop de kaart voor het laatst gelezen is. Aan de hand van deze tijd kan bijv. besloten worden dat de sessie verlopen is.';
COMMENT ON COLUMN public.tbsession.dvremote_ip
IS 'Ip-adres waarvandaan is ingelogd.';
CREATE UNIQUE INDEX idu_tbsession_dvuuid ON public.tbsession
USING btree (dvuuid COLLATE pg_catalog."default");
CREATE INDEX idx_tbsession_ddinvoked ON public.tbsession
USING btree (ddinvoked);
CREATE INDEX idx_tbsession_dvcodemedew ON public.tbsession
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 |
|