---
title: "Database Structure"
source: "https://docs.nexcess.com/software/kadence/iconic/delivery-slots/database-structure-2/"
description: "Coming soon: Iconic Delivery Slots is becoming part of Kadence Shop Kit. You may see both names used while we update the product, documentation, and customer ex…"
vertical: "Software"
area: "Delivery Slots"
date: "2023-08-26"
last_modified: "2026-08-12"
---

# Database Structure

**Coming soon:** Iconic Delivery Slots is becoming part of Kadence Shop Kit. You may see both names used while we update the product, documentation, and customer experience.

Iconic Delivery Slots stores the information of delivery date and timeslot in the following locations:

1. Custom table `wp_jckwds`: This is a custom table created by Delivery Slots and contains the following columns.

| Column | Type |
|---|---|
| id | mediumint(9) |
| datetimeid | text NULL |
| processed | tinyint(1) NULL |
| order\_id | mediumint(9) NULL |
| user\_id | text NULL |
| expires | text NULL |
| date | datetime NULL |
| starttime | mediumint(4) unsigned zerofill NULL |
| endtime | mediumint(4) unsigned zerofill NULL |
| asap | tinyint(1) *NULL* |

2\. Order meta: Delivery Slots also uses the order meta to store the delivery slots information within the orders when they are created. The following meta keys are used to store the information:

- jckwds\_date
- jckwds\_date\_ymd
- jckwds\_shipping\_method
- jckwds\_timeslot
- jckwds\_timeslot\_id
- jckwds\_timestamp

3\. Subscription orders use a different set of meta keys to store delivery slot information. The following meta keys are used for subscription orders:

- \_iconic\_wds\_subscription\_date\_ymd
- \_iconic\_wds\_subscription\_date
- \_iconic\_wds\_subscription\_timeslot
- \_iconic\_wds\_subscription\_timeslot\_id
- \_iconic\_wds\_subscription\_shipping\_method
- \_iconic\_wds\_subscription\_timestamp
- \_iconic\_wds\_subscription\_anchor\_day