# knappointment Afspraak - Catalog: `AfasOnline` - Schema: `UpdateConnector` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `knappointment` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `apid` | `int32` | Afspraak | | | | `apit` | `varchar2(20)` | Technische type afspraak | | | | `appe` | `char` | Persoonlijk | | | | `apty` | `int32` | Type afspraak | | | | `body` | `varchar2` | Inhoud | | | | `dafr` | `datetime` | Vanaf | | | | `dati` | `datetime` | Tot | | | | `fri` | `char` | Vrijdag | | | | `isre` | `char` | Repeterende afspraak | | | | `link` | `varchar2(255)` | Link | | | | `loid` | `varchar2(25)` | Locatie | | | | `lotx` | `varchar2(255)` | Locatie anders | | | | `mon` | `char` | Maandag | | | | `rein` | `int32` | Terugkeerpatroon interval | | | | `reti` | `datetime` | Einddatum reeks | | | | `sat` | `char` | Zaterdag | | | | `sbid` | `int32` | Dossieritem | | | | `sbj` | `varchar2(100)` | Onderwerp | | | | `stem` | `char` | Notificatie e-mail naar interne genodigden sturen | | | | `sun` | `char` | Zondag | | | | `thu` | `char` | Donderdag | | | | `tue` | `char` | Dinsdag | | | | `wed` | `char` | Woensdag | | |