mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2025-12-24 01:57:51 -05:00
146 lines
6.3 KiB
SQL
146 lines
6.3 KiB
SQL
--
|
|
-- Constraints for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Constraints for table `ospos_customers`
|
|
--
|
|
ALTER TABLE `ospos_customers`
|
|
ADD CONSTRAINT `ospos_customers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_employees`
|
|
--
|
|
ALTER TABLE `ospos_employees`
|
|
ADD CONSTRAINT `ospos_employees_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_inventory`
|
|
--
|
|
ALTER TABLE `ospos_inventory`
|
|
ADD CONSTRAINT `ospos_inventory_ibfk_1` FOREIGN KEY (`trans_items`) REFERENCES `ospos_items` (`item_id`),
|
|
ADD CONSTRAINT `ospos_inventory_ibfk_2` FOREIGN KEY (`trans_user`) REFERENCES `ospos_employees` (`person_id`),
|
|
ADD CONSTRAINT `ospos_inventory_ibfk_3` FOREIGN KEY (`trans_location`) REFERENCES `ospos_stock_locations` (`location_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_items`
|
|
--
|
|
ALTER TABLE `ospos_items`
|
|
ADD CONSTRAINT `ospos_items_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `ospos_suppliers` (`person_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_items_taxes`
|
|
--
|
|
ALTER TABLE `ospos_items_taxes`
|
|
ADD CONSTRAINT `ospos_items_taxes_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`) ON DELETE CASCADE;
|
|
|
|
--
|
|
-- Constraints for table `ospos_item_kit_items`
|
|
--
|
|
ALTER TABLE `ospos_item_kit_items`
|
|
ADD CONSTRAINT `ospos_item_kit_items_ibfk_1` FOREIGN KEY (`item_kit_id`) REFERENCES `ospos_item_kits` (`item_kit_id`) ON DELETE CASCADE,
|
|
ADD CONSTRAINT `ospos_item_kit_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`) ON DELETE CASCADE;
|
|
|
|
--
|
|
-- Constraints for table `ospos_permissions`
|
|
--
|
|
ALTER TABLE `ospos_permissions`
|
|
ADD CONSTRAINT `ospos_permissions_ibfk_1` FOREIGN KEY (`module_id`) REFERENCES `ospos_modules` (`module_id`) ON DELETE CASCADE,
|
|
ADD CONSTRAINT `ospos_permissions_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `ospos_stock_locations` (`location_id`) ON DELETE CASCADE;
|
|
|
|
--
|
|
-- Constraints for table `ospos_grants`
|
|
--
|
|
ALTER TABLE `ospos_grants`
|
|
ADD CONSTRAINT `ospos_grants_ibfk_1` foreign key (`permission_id`) references `ospos_permissions` (`permission_id`) ON DELETE CASCADE,
|
|
ADD CONSTRAINT `ospos_grants_ibfk_2` foreign key (`person_id`) references `ospos_employees` (`person_id`) ON DELETE CASCADE;
|
|
|
|
--
|
|
-- Constraints for table `ospos_receivings`
|
|
--
|
|
ALTER TABLE `ospos_receivings`
|
|
ADD CONSTRAINT `ospos_receivings_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`),
|
|
ADD CONSTRAINT `ospos_receivings_ibfk_2` FOREIGN KEY (`supplier_id`) REFERENCES `ospos_suppliers` (`person_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_receivings_items`
|
|
--
|
|
ALTER TABLE `ospos_receivings_items`
|
|
ADD CONSTRAINT `ospos_receivings_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`),
|
|
ADD CONSTRAINT `ospos_receivings_items_ibfk_2` FOREIGN KEY (`receiving_id`) REFERENCES `ospos_receivings` (`receiving_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_sales`
|
|
--
|
|
ALTER TABLE `ospos_sales`
|
|
ADD CONSTRAINT `ospos_sales_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`),
|
|
ADD CONSTRAINT `ospos_sales_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `ospos_customers` (`person_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_sales_items`
|
|
--
|
|
ALTER TABLE `ospos_sales_items`
|
|
ADD CONSTRAINT `ospos_sales_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`),
|
|
ADD CONSTRAINT `ospos_sales_items_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`),
|
|
ADD CONSTRAINT `ospos_sales_items_ibfk_3` FOREIGN KEY (`item_location`) REFERENCES `ospos_stock_locations` (`location_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_sales_items_taxes`
|
|
--
|
|
ALTER TABLE `ospos_sales_items_taxes`
|
|
ADD CONSTRAINT `ospos_sales_items_taxes_ibfk_1` FOREIGN KEY (`sale_id`,`item_id`,`line`) REFERENCES `ospos_sales_items` (`sale_id`,`item_id`,`line`),
|
|
ADD CONSTRAINT `ospos_sales_items_taxes_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_sales_payments`
|
|
--
|
|
ALTER TABLE `ospos_sales_payments`
|
|
ADD CONSTRAINT `ospos_sales_payments_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_sales_suspended`
|
|
--
|
|
ALTER TABLE `ospos_sales_suspended`
|
|
ADD CONSTRAINT `ospos_sales_suspended_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`),
|
|
ADD CONSTRAINT `ospos_sales_suspended_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `ospos_customers` (`person_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_sales_suspended_items`
|
|
--
|
|
ALTER TABLE `ospos_sales_suspended_items`
|
|
ADD CONSTRAINT `ospos_sales_suspended_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`),
|
|
ADD CONSTRAINT `ospos_sales_suspended_items_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales_suspended` (`sale_id`),
|
|
ADD CONSTRAINT `ospos_sales_suspended_items_ibfk_3` FOREIGN KEY (`item_location`) REFERENCES `ospos_stock_locations` (`location_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_sales_suspended_items_taxes`
|
|
--
|
|
ALTER TABLE `ospos_sales_suspended_items_taxes`
|
|
ADD CONSTRAINT `ospos_sales_suspended_items_taxes_ibfk_1` FOREIGN KEY (`sale_id`,`item_id`,`line`) REFERENCES `ospos_sales_suspended_items` (`sale_id`,`item_id`,`line`),
|
|
ADD CONSTRAINT `ospos_sales_suspended_items_taxes_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_sales_suspended_payments`
|
|
--
|
|
ALTER TABLE `ospos_sales_suspended_payments`
|
|
ADD CONSTRAINT `ospos_sales_suspended_payments_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales_suspended` (`sale_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_item_quantities`
|
|
--
|
|
ALTER TABLE `ospos_item_quantities`
|
|
ADD CONSTRAINT `ospos_item_quantities_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`),
|
|
ADD CONSTRAINT `ospos_item_quantities_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `ospos_stock_locations` (`location_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_suppliers`
|
|
--
|
|
ALTER TABLE `ospos_suppliers`
|
|
ADD CONSTRAINT `ospos_suppliers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`);
|
|
|
|
--
|
|
-- Constraints for table `ospos_giftcards`
|
|
--
|
|
ALTER TABLE `ospos_giftcards`
|
|
ADD CONSTRAINT `ospos_giftcards_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`);
|