Datadictionary OpenWave 3.1.25 |
|
Table: tbhorterras
Datadictionary OpenWave 3.1.25 |
|
Table: tbhorterras
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met terrasvergunningen per horeca-vergunning
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhorterras_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyhorecavergunningen |
integer |
|
|
|
|
Foreign key naar TbHorecavergunningen.DnKey. |
|
|
dvvergnummer |
varchar(20) |
|
|
|
|
Terrasvergunning nummer. |
|
|
ddverleendvan |
timestamp |
|
|
|
|
Vergunning geldig vanaf datum. |
|
|
ddverleendtot |
timestamp |
|
|
|
|
Vergunning geldig t/m datum (vervaldatum). |
|
|
dvomschrijving |
varchar(2000) |
|
|
|
|
Omschrijving vergunning. |
|
|
dvgrond |
char(1) |
|
|
|
''::bpchar |
E of G of B of leeg. Eigendom grond (Eigen, Gemeente, Beiden of leeg. |
|
|
dvtekeningnr |
varchar(30) |
|
|
|
|
Tekening nummer plattegrond. |
|
|
dvmemo |
varchar(4000) |
|
|
|
|
Memo. LET OP in de database is de inhoud gezipt opgeslagen! |
|
|
dvwebsite |
varchar(200) |
|
|
|
|
Website van tekening. |
|
|
dfoppervlakte |
double precision |
|
|
|
|
Oppervlakte van terras. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_horterras_horecaverg |
dnkeyhorecavergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_horterras_grond |
dvgrond = ANY (ARRAY['E'::bpchar, 'G'::bpchar, 'B'::bpchar, ''::bpchar]) |
|
cnn_horterras_dnkeyhorverg |
dnkeyhorecavergunningen IS NOT NULL |
|
cnn_horterras_vergnummer |
dvvergnummer IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhorterras |
btree |
|
dnkey |
|
|
|
idx_horterras_horecaverg |
btree |
|
dnkeyhorecavergunningen |
|
|
|
Triggers
There are no triggers for table tbhorterras
Rules
There are no rules for table tbhorterras
Policies
There are no policies for table tbhorterras
Referenced
There are no tables referenced by table tbhorterras
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,
dvomschrijving VARCHAR(2000),
dvgrond CHAR(1) DEFAULT ''::bpchar,
dvtekeningnr VARCHAR(30),
dvmemo VARCHAR(4000),
dvwebsite VARCHAR(200),
dfoppervlakte DOUBLE PRECISION,
CONSTRAINT cpk_tbhorterras PRIMARY KEY(dnkey),
CONSTRAINT chk_horterras_grond CHECK (dvgrond = ANY (ARRAY['E'::bpchar, 'G'::bpchar, 'B'::bpchar, ''::bpchar])),
CONSTRAINT cnn_horterras_dnkeyhorverg CHECK (dnkeyhorecavergunningen IS NOT NULL),
CONSTRAINT cnn_horterras_vergnummer CHECK (dvvergnummer IS NOT NULL),
CONSTRAINT cfk_horterras_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
REFERENCES public.tbhorecavergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhorterras
IS 'Tabel met terrasvergunningen per horeca-vergunning';
COMMENT ON COLUMN public.tbhorterras.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhorterras.dnkeyhorecavergunningen
IS 'Foreign key naar TbHorecavergunningen.DnKey.';
COMMENT ON COLUMN public.tbhorterras.dvvergnummer
IS 'Terrasvergunning nummer.';
COMMENT ON COLUMN public.tbhorterras.ddverleendvan
IS 'Vergunning geldig vanaf datum.';
COMMENT ON COLUMN public.tbhorterras.ddverleendtot
IS 'Vergunning geldig t/m datum (vervaldatum).';
COMMENT ON COLUMN public.tbhorterras.dvomschrijving
IS 'Omschrijving vergunning.';
COMMENT ON COLUMN public.tbhorterras.dvgrond
IS 'E of G of B of leeg. Eigendom grond (Eigen, Gemeente, Beiden of leeg.';
COMMENT ON COLUMN public.tbhorterras.dvtekeningnr
IS 'Tekening nummer plattegrond.';
COMMENT ON COLUMN public.tbhorterras.dvmemo
IS 'Memo. LET OP in de database is de inhoud gezipt opgeslagen!';
COMMENT ON COLUMN public.tbhorterras.dvwebsite
IS 'Website van tekening.';
COMMENT ON COLUMN public.tbhorterras.dfoppervlakte
IS 'Oppervlakte van terras.';
CREATE INDEX idx_horterras_horecaverg ON public.tbhorterras
USING btree (dnkeyhorecavergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|