Database structure
Below you will find an overview of all database tables of Woo Batches. These database tables are created when the respective plugins are installed in your WordPress database.
woo_batches
Section titled “woo_batches”| Name | Type | Null | Default / Extra |
|---|---|---|---|
id Primary key | BIGINT(20) | NO | NONE | AUTO_INCREMENT |
batch_number | VARCHAR(255) | NO | NONE |
supplier | VARCHAR(255) | YES | NULL |
store_location | VARCHAR(255) | YES | NULL |
expiration_date | DATETIME | YES | NULL |
product_id | BIGINT(20) | NO | NONE |
quantity | BIGINT(20) | NO | NONE |
quantity_available | BIGINT(20) | NO | NONE |
created_at | DATETIME | NO | CURRENT_TIMESTAMP |