Datadictionary OpenWave 3.1.32 |
|
Table: tbdcinspopmerkingen
Datadictionary OpenWave 3.1.32 |
|
Table: tbdcinspopmerkingen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met opmerkingen bij onrechtmatigheden uit Digitale Checklisten.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbdcinspopmerkingen_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeyinsponrechtm |
integer |
|
|
|
|
Foreign key naar tbinsponrechtm.dnkey |
|
|
dvremarkid |
varchar(40) |
|
|
|
|
Opmerking ID zoals deze bij Digitale Checklisten bekend is |
|
|
dvremarkvalue |
varchar(4000) |
|
|
|
|
Inhoud van de opmerking zoals deze bij Digitale Checklisten bekend is |
|
|
ddremarkcreated |
timestamp |
|
|
|
|
Datum dat de opmerking aangemaakt is in Digitale Checklisten |
|
|
ddremarkupdated |
timestamp |
|
|
|
|
Datum dat de opmerking aangepast is in Digitale Checklisten |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbdcinspopmerkingen_dnkeyinsponrechtm |
dnkeyinsponrechtm |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbdcinspopmerkingen_ddremarkcreated |
ddremarkcreated IS NOT NULL |
|
cnn_tbdcinspopmerkingen_dnkeyinsponrechtm |
dnkeyinsponrechtm IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbdcinspopmerkingen |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbdcinspopmerkingen
Rules
There are no rules for table tbdcinspopmerkingen
Policies
There are no policies for table tbdcinspopmerkingen
Referenced
There are no tables referenced by table tbdcinspopmerkingen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyinsponrechtm INTEGER,
dvremarkid VARCHAR(40),
dvremarkvalue VARCHAR(4000),
ddremarkcreated TIMESTAMP WITHOUT TIME ZONE,
ddremarkupdated TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbdcinspopmerkingen PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbdcinspopmerkingen_ddremarkcreated CHECK (ddremarkcreated IS NOT NULL),
CONSTRAINT cnn_tbdcinspopmerkingen_dnkeyinsponrechtm CHECK (dnkeyinsponrechtm IS NOT NULL),
CONSTRAINT cfk_tbdcinspopmerkingen_dnkeyinsponrechtm FOREIGN KEY (dnkeyinsponrechtm)
REFERENCES public.tbinsponrechtm(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbdcinspopmerkingen
IS 'Tabel met opmerkingen bij onrechtmatigheden uit Digitale Checklisten.';
COMMENT ON COLUMN public.tbdcinspopmerkingen.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbdcinspopmerkingen.dnkeyinsponrechtm
IS 'Foreign key naar tbinsponrechtm.dnkey';
COMMENT ON COLUMN public.tbdcinspopmerkingen.dvremarkid
IS 'Opmerking ID zoals deze bij Digitale Checklisten bekend is';
COMMENT ON COLUMN public.tbdcinspopmerkingen.dvremarkvalue
IS 'Inhoud van de opmerking zoals deze bij Digitale Checklisten bekend is';
COMMENT ON COLUMN public.tbdcinspopmerkingen.ddremarkcreated
IS 'Datum dat de opmerking aangemaakt is in Digitale Checklisten';
COMMENT ON COLUMN public.tbdcinspopmerkingen.ddremarkupdated
IS 'Datum dat de opmerking aangepast is in Digitale Checklisten';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|