Datadictionary OpenWave 3.1.25 |
|
Table: tbadm_objects
Datadictionary OpenWave 3.1.25 |
|
Table: tbadm_objects
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Controletabel met alle verondersteld aanwezige databaseobjecten
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbadm_objects_dnkey_seq'::regclass) |
|
|
|
dvname |
varchar(200) |
|
|
|
|
|
|
|
dvtype |
varchar(25) |
|
|
|
|
|
|
|
dvversion |
varchar(10) |
|
|
|
|
|
|
|
dvdata_type |
varchar(50) |
|
|
|
|
|
|
|
dnmax_length |
integer |
|
|
|
|
|
Foreign Keys
There are no foreign keys for table tbadm_objects
Check Constraints
There are no check constraints for table tbadm_objects
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbadm_objects |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbadm_objects
Rules
There are no rules for table tbadm_objects
Policies
There are no policies for table tbadm_objects
Referenced
There are no tables referenced by table tbadm_objects
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
22969 |
Pages |
276 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvname VARCHAR(200),
dvtype VARCHAR(25),
dvversion VARCHAR(10),
dvdata_type VARCHAR(50),
dnmax_length INTEGER,
CONSTRAINT cpk_tbadm_objects PRIMARY KEY(dnkey)
) ;
COMMENT ON TABLE public.tbadm_objects
IS 'Controletabel met alle verondersteld aanwezige databaseobjecten';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|