Datadictionary OpenWave 3.1.25 |
|
Table: tbmewafdeling
Datadictionary OpenWave 3.1.25 |
|
Table: tbmewafdeling
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met afdelingen waaraan een medewerker kan worden toegekend
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmewafdeling_dnkey_seq'::regclass) |
De primary key van de exportregel |
|
|
dvomschrijving |
varchar(100) |
|
|
|
|
Omschrijving van de afdeling |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Vervaldatum van de afdeling |
Foreign Keys
There are no foreign keys for table tbmewafdeling
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmewafdeling_omschrijving |
dvomschrijving IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmewafdeling |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbmewafdeling
Rules
There are no rules for table tbmewafdeling
Policies
There are no policies for table tbmewafdeling
Referenced
There are no tables referenced by table tbmewafdeling
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvomschrijving VARCHAR(100),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmewafdeling PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmewafdeling_omschrijving CHECK (dvomschrijving IS NOT NULL)
) ;
COMMENT ON TABLE public.tbmewafdeling
IS 'Tabel met afdelingen waaraan een medewerker kan worden toegekend';
COMMENT ON COLUMN public.tbmewafdeling.dnkey
IS 'De primary key van de exportregel';
COMMENT ON COLUMN public.tbmewafdeling.dvomschrijving
IS 'Omschrijving van de afdeling';
COMMENT ON COLUMN public.tbmewafdeling.ddvervaldatum
IS 'Vervaldatum van de afdeling';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|