Datadictionary OpenWave 3.1.32 |
|
Table: tbipauthorisationlist
Datadictionary OpenWave 3.1.32 |
|
Table: tbipauthorisationlist
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met volledige IP-nummers (van robots) die toegang hebben bij een bepaald OpenWave endpoint (zie tbendpointlist)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbipauthorisationlist_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeyendpointlist |
integer |
|
|
|
|
Foreign key naar tbendpointlist.dnkey |
|
|
dvipremote |
varchar(40) |
|
|
|
|
Volledig ip-nummer |
|
|
dvomschrijving |
varchar(200) |
|
|
|
|
Van wie is dit ip-nummer |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbipauthorisationlist_dnkeyendpointlist |
dnkeyendpointlist |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbipauthorisationlist_dnkeyendpointlist |
dnkeyendpointlist IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbipauthorisationlist |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbipauthorisationlist
Rules
There are no rules for table tbipauthorisationlist
Policies
There are no policies for table tbipauthorisationlist
Referenced
There are no tables referenced by table tbipauthorisationlist
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyendpointlist INTEGER,
dvipremote VARCHAR(40),
dvomschrijving VARCHAR(200),
CONSTRAINT cpk_tbipauthorisationlist PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbipauthorisationlist_dnkeyendpointlist CHECK (dnkeyendpointlist IS NOT NULL),
CONSTRAINT cfk_tbipauthorisationlist_dnkeyendpointlist FOREIGN KEY (dnkeyendpointlist)
REFERENCES public.tbendpointlist(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbipauthorisationlist
IS 'Tabel met volledige IP-nummers (van robots) die toegang hebben bij een bepaald OpenWave endpoint (zie tbendpointlist)';
COMMENT ON COLUMN public.tbipauthorisationlist.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbipauthorisationlist.dnkeyendpointlist
IS 'Foreign key naar tbendpointlist.dnkey';
COMMENT ON COLUMN public.tbipauthorisationlist.dvipremote
IS 'Volledig ip-nummer';
COMMENT ON COLUMN public.tbipauthorisationlist.dvomschrijving
IS 'Van wie is dit ip-nummer';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|