Database Structure
Iconic Delivery Slots stores the information of delivery date and timeslot in the following locations:
- 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