Datadictionary OpenWave 3.1.25 |
|
Table: tbmilcodepas
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilcodepas
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met coderngen en reducties Programmatische Aanpak Stikstof
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilcodepas_dnkey_seq'::regclass) |
Primary key. |
|
|
dvpascode |
varchar(15) |
|
|
|
|
PAS (Programmatische Aanpak Stikstof) codering. |
|
|
dvpasoms |
varchar(1000) |
|
|
|
|
Omschrijving pascodering. |
|
|
dfreduperctot |
double precision |
|
|
|
|
Reductiepercentage totaal. |
|
|
dfredupercvloer |
double precision |
|
|
|
|
Reductiepercentage vloer (RV). |
|
|
dfreduperckelder |
double precision |
|
|
|
|
Reductiepercentage kelder. (RK) |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Vervaldatum van codering. |
Foreign Keys
There are no foreign keys for table tbmilcodepas
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmilcodepas_dvpascode |
dvpascode IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilcodepas |
btree |
|
dnkey |
|
|
|
idu_tbmilcodepas_dvpascode |
btree |
|
dvpascode |
|
|
|
Triggers
There are no triggers for table tbmilcodepas
Rules
There are no rules for table tbmilcodepas
Policies
There are no policies for table tbmilcodepas
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbmilemstal_dnkeymilcdpas |
dnkeymilcodepas |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbmilemstal_dnkeymilcdpas2 |
dnkeymilcodepas2 |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvpascode VARCHAR(15),
dvpasoms VARCHAR(1000),
dfreduperctot DOUBLE PRECISION,
dfredupercvloer DOUBLE PRECISION,
dfreduperckelder DOUBLE PRECISION,
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmilcodepas PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmilcodepas_dvpascode CHECK (dvpascode IS NOT NULL)
) ;
COMMENT ON TABLE public.tbmilcodepas
IS 'Tabel met coderngen en reducties Programmatische Aanpak Stikstof';
COMMENT ON COLUMN public.tbmilcodepas.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilcodepas.dvpascode
IS 'PAS (Programmatische Aanpak Stikstof) codering.';
COMMENT ON COLUMN public.tbmilcodepas.dvpasoms
IS 'Omschrijving pascodering.';
COMMENT ON COLUMN public.tbmilcodepas.dfreduperctot
IS 'Reductiepercentage totaal.';
COMMENT ON COLUMN public.tbmilcodepas.dfredupercvloer
IS 'Reductiepercentage vloer (RV).';
COMMENT ON COLUMN public.tbmilcodepas.dfreduperckelder
IS 'Reductiepercentage kelder. (RK)';
COMMENT ON COLUMN public.tbmilcodepas.ddvervaldatum
IS 'Vervaldatum van codering.';
CREATE UNIQUE INDEX idu_tbmilcodepas_dvpascode ON public.tbmilcodepas
USING btree (dvpascode COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|