Datadictionary OpenWave 3.1.25 |
|
Table: tbhorspeelautomaten
Datadictionary OpenWave 3.1.25 |
|
Table: tbhorspeelautomaten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met de speelautomaten per horecavergunning
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhorspeelautomaten_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyhorecavergunningen |
integer |
|
|
|
|
Foreign key naar TbHorecavergunningen.dnkey |
|
|
dvvergnummer |
varchar(20) |
|
|
|
|
Vergunning nummer. |
|
|
ddverleendvan |
timestamp |
|
|
|
|
Vergunning geldig vanaf datum. |
|
|
ddverleendtot |
timestamp |
|
|
|
|
Vergunning geldig t/m datum (vervaldatum). |
|
|
dlconvenant |
char(1) |
|
|
|
'F'::bpchar |
T of F of leeg. Convenant. |
|
|
dvcategorie |
char(1) |
|
|
|
|
Foreign key naar TbHorSpAutCategorie.dnkey |
|
|
dnaantalkans |
integer |
|
|
|
|
Aantal kansspeelautomaten. |
|
|
dnaantalbeh |
integer |
|
|
|
|
Aantal behendigheidsautomaten. |
|
|
dvmemo |
varchar(4000) |
|
|
|
|
Memo. LET OP in de database is de inhoud gezipt opgeslagen! |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_horspeelautomat_horautcat |
dvcategorie |
dvcode |
No Action |
No Action |
|
Immediate |
|
|
cfk_horspeelautomat_horecaverg |
dnkeyhorecavergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_horspaut_convenant |
dlconvenant = ANY (ARRAY['T'::bpchar, 'F'::bpchar, ''::bpchar]) |
|
cnn_horspaut_categorie |
dvcategorie IS NOT NULL |
|
cnn_horspaut_dnkeyhorverg |
dnkeyhorecavergunningen IS NOT NULL |
|
cnn_horspaut_vergnummer |
dvvergnummer IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhorspeelautomaten |
btree |
|
dnkey |
|
|
|
idx_horspautomaten_horecaverg |
btree |
|
dnkeyhorecavergunningen |
|
|
|
idx_horspautomaten_horspautcat |
btree |
|
dvcategorie |
|
|
|
Triggers
There are no triggers for table tbhorspeelautomaten
Rules
There are no rules for table tbhorspeelautomaten
Policies
There are no policies for table tbhorspeelautomaten
Referenced
There are no tables referenced by table tbhorspeelautomaten
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhorecavergunningen INTEGER,
dvvergnummer VARCHAR(20),
ddverleendvan TIMESTAMP WITHOUT TIME ZONE,
ddverleendtot TIMESTAMP WITHOUT TIME ZONE,
dlconvenant CHAR(1) DEFAULT 'F'::bpchar,
dvcategorie CHAR(1),
dnaantalkans INTEGER,
dnaantalbeh INTEGER,
dvmemo VARCHAR(4000),
CONSTRAINT cpk_tbhorspeelautomaten PRIMARY KEY(dnkey),
CONSTRAINT chk_horspaut_convenant CHECK (dlconvenant = ANY (ARRAY['T'::bpchar, 'F'::bpchar, ''::bpchar])),
CONSTRAINT cnn_horspaut_categorie CHECK (dvcategorie IS NOT NULL),
CONSTRAINT cnn_horspaut_dnkeyhorverg CHECK (dnkeyhorecavergunningen IS NOT NULL),
CONSTRAINT cnn_horspaut_vergnummer CHECK (dvvergnummer IS NOT NULL),
CONSTRAINT cfk_horspeelautomat_horautcat FOREIGN KEY (dvcategorie)
REFERENCES public.tbhorspautcategorie(dvcode)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_horspeelautomat_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
REFERENCES public.tbhorecavergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhorspeelautomaten
IS 'Tabel met de speelautomaten per horecavergunning';
COMMENT ON COLUMN public.tbhorspeelautomaten.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhorspeelautomaten.dnkeyhorecavergunningen
IS 'Foreign key naar TbHorecavergunningen.dnkey';
COMMENT ON COLUMN public.tbhorspeelautomaten.dvvergnummer
IS 'Vergunning nummer.';
COMMENT ON COLUMN public.tbhorspeelautomaten.ddverleendvan
IS 'Vergunning geldig vanaf datum.';
COMMENT ON COLUMN public.tbhorspeelautomaten.ddverleendtot
IS 'Vergunning geldig t/m datum (vervaldatum).';
COMMENT ON COLUMN public.tbhorspeelautomaten.dlconvenant
IS 'T of F of leeg. Convenant.';
COMMENT ON COLUMN public.tbhorspeelautomaten.dvcategorie
IS 'Foreign key naar TbHorSpAutCategorie.dnkey';
COMMENT ON COLUMN public.tbhorspeelautomaten.dnaantalkans
IS 'Aantal kansspeelautomaten.';
COMMENT ON COLUMN public.tbhorspeelautomaten.dnaantalbeh
IS 'Aantal behendigheidsautomaten.';
COMMENT ON COLUMN public.tbhorspeelautomaten.dvmemo
IS 'Memo. LET OP in de database is de inhoud gezipt opgeslagen!';
CREATE INDEX idx_horspautomaten_horecaverg ON public.tbhorspeelautomaten
USING btree (dnkeyhorecavergunningen);
CREATE INDEX idx_horspautomaten_horspautcat ON public.tbhorspeelautomaten
USING btree (dvcategorie COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|