Datadictionary OpenWave 3.1.25 |
|
Table: tbavpdigitaal
Datadictionary OpenWave 3.1.25 |
|
Table: tbavpdigitaal
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met bestandsverwijzingen die gekoppeld zijn aan een brandweer-aanvalsplan
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbavpdigitaal_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyaanvalsplannen |
integer |
|
|
|
|
Foreign key naar tbaanvalsplannen.dnkey |
|
|
dvbestandsnaam |
varchar(50) |
|
|
|
|
Naam van bestand (zonder map) met extensie. |
|
|
ddregdatum |
timestamp |
|
|
|
|
Registratiedatum van bestand. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbavpdigitaal_keyaanvalsp |
dnkeyaanvalsplannen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbavpdigitaal_bestandsn |
dvbestandsnaam IS NOT NULL |
|
cnn_tbavpdigitaal_ddreg |
ddregdatum IS NOT NULL |
|
cnn_tbavpdigitaal_keyaanvalsp |
dnkeyaanvalsplannen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbavpdigitaal |
btree |
|
dnkey |
|
|
|
idx_tbavpdigitaal_keyaanvalsp |
btree |
|
dnkeyaanvalsplannen |
|
|
|
Triggers
There are no triggers for table tbavpdigitaal
Rules
There are no rules for table tbavpdigitaal
Policies
There are no policies for table tbavpdigitaal
Referenced
There are no tables referenced by table tbavpdigitaal
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyaanvalsplannen INTEGER,
dvbestandsnaam VARCHAR(50),
ddregdatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbavpdigitaal PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbavpdigitaal_bestandsn CHECK (dvbestandsnaam IS NOT NULL),
CONSTRAINT cnn_tbavpdigitaal_ddreg CHECK (ddregdatum IS NOT NULL),
CONSTRAINT cnn_tbavpdigitaal_keyaanvalsp CHECK (dnkeyaanvalsplannen IS NOT NULL),
CONSTRAINT cfk_tbavpdigitaal_keyaanvalsp FOREIGN KEY (dnkeyaanvalsplannen)
REFERENCES public.tbaanvalsplannen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbavpdigitaal
IS 'Tabel met bestandsverwijzingen die gekoppeld zijn aan een brandweer-aanvalsplan';
COMMENT ON COLUMN public.tbavpdigitaal.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbavpdigitaal.dnkeyaanvalsplannen
IS 'Foreign key naar tbaanvalsplannen.dnkey';
COMMENT ON COLUMN public.tbavpdigitaal.dvbestandsnaam
IS 'Naam van bestand (zonder map) met extensie.';
COMMENT ON COLUMN public.tbavpdigitaal.ddregdatum
IS 'Registratiedatum van bestand.';
CREATE INDEX idx_tbavpdigitaal_keyaanvalsp ON public.tbavpdigitaal
USING btree (dnkeyaanvalsplannen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|