api_id int not_null auto_increment comment(Primary key - unique identifier for each API configuration)
username varchar(64) not_null comment(API username for authentication)
api_key text not_null comment(API key for authentication - should be securely hashed)
status tinyint(1) not_null defaut(0) comment(API status - 0: disabled, 1: enabled)
date_added datetime not_null comment(Timestamp when API configuration was created)
date_modified datetime not_null comment(Timestamp of last modification)
get_product_status tinyint(1) not_null defaut(0) comment(Permission to read product data - 0: denied, 1: allowed)
update_product_status tinyint(1) not_null defaut(0) comment(Permission to update product data - 0: denied, 1: allowed)
insert_product_status tinyint(1) not_null defaut(0) comment(Permission to create product data - 0: denied, 1: allowed)
delete_product_status tinyint(1) not_null defaut(0) comment(Permission to delete product data - 0: denied, 1: allowed)
get_categories_status tinyint(1) not_null defaut(0) comment(Permission to read category data - 0: denied, 1: allowed)
update_categories_status tinyint(1) not_null defaut(0) comment(Permission to update category data - 0: denied, 1: allowed)
insert_categories_status tinyint(1) not_null defaut(0) comment(Permission to create category data - 0: denied, 1: allowed)
delete_categories_status tinyint(1) not_null defaut(0) comment(Permission to delete category data - 0: denied, 1: allowed)
get_customer_status tinyint(1) not_null defaut(0) comment(Permission to read customer data - 0: denied, 1: allowed)
update_customer_status tinyint(1) not_null defaut(0) comment(Permission to update customer data - 0: denied, 1: allowed)
insert_customer_status tinyint(1) not_null defaut(0) comment(Permission to create customer data - 0: denied, 1: allowed)
delete_customer_status tinyint(1) not_null defaut(0) comment(Permission to delete customer data - 0: denied, 1: allowed)
get_order_status tinyint(1) not_null defaut(0) comment(Permission to read order data - 0: denied, 1: allowed)
update_order_status tinyint(1) not_null defaut(0) comment(Permission to update order data - 0: denied, 1: allowed)
insert_order_status tinyint(1) not_null defaut(0) comment(Permission to create order data - 0: denied, 1: allowed)
delete_order_status tinyint(1) not_null defaut(0) comment(Permission to delete order data - 0: denied, 1: allowed)
get_manufacturer_status tinyint(1) not_null defaut(0) comment(Permission to read manufacturer data - 0: denied, 1: allowed)
update_manufacturer_status tinyint(1) not_null defaut(0) comment(Permission to update manufacturer data - 0: denied, 1: allowed)
insert_manufacturer_status tinyint(1) not_null defaut(0) comment(Permission to create manufacturer data - 0: denied, 1: allowed)
delete_manufacturer_status tinyint(1) not_null defaut(0) comment(Permission to delete manufacturer data - 0: denied, 1: allowed)
get_supplier_status tinyint(1) not_null defaut(0) comment(Permission to read supplier data - 0: denied, 1: allowed)
update_supplier_status tinyint(1) not_null defaut(0) comment(Permission to update supplier data - 0: denied, 1: allowed)
insert_supplier_status tinyint(1) not_null defaut(0) comment(Permission to create supplier data - 0: denied, 1: allowed)
delete_supplier_status tinyint(1) not_null defaut(0) comment(Permission to delete supplier data - 0: denied, 1: allowed)

--
primary api_id
idx_api_id api_id
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci
comment REST API configurations with granular permission control for external integrations