Datadictionary OpenWave 3.1.25 |
|
Table: tblhsmatrix
Datadictionary OpenWave 3.1.25 |
|
Table: tblhsmatrix
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van landelijke Handhavingsstratgie matrix
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tblhsmatrix_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcode |
char(2) |
|
|
|
|
Not null en uniek. Bijv B3. |
|
|
dvgevolgen |
varchar(100) |
|
|
|
|
Vrijwel nihil, Beperkt, Van Belang, of Aanzienlijk dreigend en/of onomkeerbaar |
|
|
dvgedragovertreder |
varchar(100) |
|
|
|
|
Goed willend, moet kunnen, calculerend of criminieel |
|
|
dvstrafrecht |
varchar(200) |
|
|
|
|
Gevuld met strafrecht maatregel indien van toepassing |
|
|
dvbestuursrechtbestraf |
varchar(200) |
|
|
|
|
Gevuld met bestuurlijke bestraffende maatregel indien van toepassing |
|
|
dvbestuursrechtherstel |
varchar(200) |
|
|
|
|
Gevuld met bestuurlijke herstellende maatregel indien van toepassing |
Foreign Keys
There are no foreign keys for table tblhsmatrix
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tblhsmatrix_dvcode |
dvcode IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tblhsmatrix |
btree |
|
dnkey |
|
|
|
idu_tblhsmatrix_dvcode |
btree |
|
dvcode |
|
|
|
Triggers
There are no triggers for table tblhsmatrix
Rules
There are no rules for table tblhsmatrix
Policies
There are no policies for table tblhsmatrix
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbinsponr_dnkeylhsmatrix |
dnkeylhsmatrix |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcode CHAR(2),
dvgevolgen VARCHAR(100),
dvgedragovertreder VARCHAR(100),
dvstrafrecht VARCHAR(200),
dvbestuursrechtbestraf VARCHAR(200),
dvbestuursrechtherstel VARCHAR(200),
CONSTRAINT cpk_tblhsmatrix PRIMARY KEY(dnkey),
CONSTRAINT cnn_tblhsmatrix_dvcode CHECK (dvcode IS NOT NULL)
) ;
COMMENT ON TABLE public.tblhsmatrix
IS 'Tabel van landelijke Handhavingsstratgie matrix';
COMMENT ON COLUMN public.tblhsmatrix.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tblhsmatrix.dvcode
IS 'Not null en uniek. Bijv B3.';
COMMENT ON COLUMN public.tblhsmatrix.dvgevolgen
IS 'Vrijwel nihil, Beperkt, Van Belang, of Aanzienlijk dreigend en/of onomkeerbaar';
COMMENT ON COLUMN public.tblhsmatrix.dvgedragovertreder
IS 'Goed willend, moet kunnen, calculerend of criminieel';
COMMENT ON COLUMN public.tblhsmatrix.dvstrafrecht
IS 'Gevuld met strafrecht maatregel indien van toepassing';
COMMENT ON COLUMN public.tblhsmatrix.dvbestuursrechtbestraf
IS 'Gevuld met bestuurlijke bestraffende maatregel indien van toepassing';
COMMENT ON COLUMN public.tblhsmatrix.dvbestuursrechtherstel
IS 'Gevuld met bestuurlijke herstellende maatregel indien van toepassing';
CREATE UNIQUE INDEX idu_tblhsmatrix_dvcode ON public.tblhsmatrix
USING btree (dvcode COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|