Datadictionary OpenWave 3.1.32 |
|
Table: tbmilartmba
Datadictionary OpenWave 3.1.32 |
|
Table: tbmilartmba
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met artikelnummers onder de BAL activiteiten van tbsrttoestemming per paragraaf
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilartmba_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodemba |
integer |
|
|
|
|
Niet meer in gebruiik sinds databaseversie 3.1.32 |
|
|
dvartikelnr |
varchar(20) |
|
|
|
|
Artikelnummer. |
|
|
dvartikeltekst |
varchar(4000) |
|
|
|
|
Beschrijving van artikelnummer. |
|
|
dvrisicocode |
varchar(20) |
|
|
|
|
Waardering van artikel naar risico |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum dat artikel is komen te vervallen |
|
|
dvplicht |
char(1) |
|
|
|
'G'::bpchar |
(G)een, (I)nformatieplicht, (M)eldingsplicht of (V)ergunningsplicht of (Z)orgplicht. |
|
|
dvbevoegdgezag |
char(1) |
|
|
|
'G'::bpchar |
(G)emeente, (P)rovincie, (R)ijk of (W)aterschap |
|
|
dnkeysrttoestemming |
integer |
|
|
|
|
Foreign key naar tbsrttoestemming.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilartmba_dnkeysrttoestemming |
dnkeysrttoestemming |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbmilartmba_dvbevoegdgezag |
dvbevoegdgezag = ANY (ARRAY['G'::bpchar, 'P'::bpchar, 'R'::bpchar, 'W'::bpchar]) |
|
chk_tbmilartmba_dvplicht |
dvplicht = ANY (ARRAY['G'::bpchar, 'I'::bpchar, 'M'::bpchar, 'V'::bpchar, 'Z'::bpchar]) |
|
cnn_tbmilartmba_dvbevoegdgezag |
dvbevoegdgezag IS NOT NULL |
|
cnn_tbmilartmba_dvplicht |
dvplicht IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilartmba |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbmilartmba
Rules
There are no rules for table tbmilartmba
Policies
There are no policies for table tbmilartmba
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbtoest_dnkeymilartmbakz |
dnkeymilartmbakz |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodemba INTEGER,
dvartikelnr VARCHAR(20),
dvartikeltekst VARCHAR(4000),
dvrisicocode VARCHAR(20),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
dvplicht CHAR(1) DEFAULT 'G'::bpchar,
dvbevoegdgezag CHAR(1) DEFAULT 'G'::bpchar,
dnkeysrttoestemming INTEGER,
CONSTRAINT cpk_tbmilartmba PRIMARY KEY(dnkey),
CONSTRAINT chk_tbmilartmba_dvbevoegdgezag CHECK (dvbevoegdgezag = ANY (ARRAY['G'::bpchar, 'P'::bpchar, 'R'::bpchar, 'W'::bpchar])),
CONSTRAINT chk_tbmilartmba_dvplicht CHECK (dvplicht = ANY (ARRAY['G'::bpchar, 'I'::bpchar, 'M'::bpchar, 'V'::bpchar, 'Z'::bpchar])),
CONSTRAINT cnn_tbmilartmba_dvbevoegdgezag CHECK (dvbevoegdgezag IS NOT NULL),
CONSTRAINT cnn_tbmilartmba_dvplicht CHECK (dvplicht IS NOT NULL),
CONSTRAINT cfk_tbmilartmba_dnkeysrttoestemming FOREIGN KEY (dnkeysrttoestemming)
REFERENCES public.tbsrttoestemming(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilartmba
IS 'Tabel met artikelnummers onder de BAL activiteiten van tbsrttoestemming per paragraaf ';
COMMENT ON COLUMN public.tbmilartmba.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilartmba.dnkeymilcodemba
IS 'Niet meer in gebruiik sinds databaseversie 3.1.32';
COMMENT ON COLUMN public.tbmilartmba.dvartikelnr
IS 'Artikelnummer.';
COMMENT ON COLUMN public.tbmilartmba.dvartikeltekst
IS 'Beschrijving van artikelnummer.';
COMMENT ON COLUMN public.tbmilartmba.dvrisicocode
IS 'Waardering van artikel naar risico';
COMMENT ON COLUMN public.tbmilartmba.ddvervaldatum
IS 'Datum dat artikel is komen te vervallen';
COMMENT ON COLUMN public.tbmilartmba.dvplicht
IS '(G)een, (I)nformatieplicht, (M)eldingsplicht of (V)ergunningsplicht of (Z)orgplicht.';
COMMENT ON COLUMN public.tbmilartmba.dvbevoegdgezag
IS '(G)emeente, (P)rovincie, (R)ijk of (W)aterschap';
COMMENT ON COLUMN public.tbmilartmba.dnkeysrttoestemming
IS 'Foreign key naar tbsrttoestemming.dnkey';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|