schematic diagram for my database
ramnath
findingtrust.sqlSET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- Database: `findingtrust` -- CREATE DATABASE IF NOT EXISTS `findingtrust` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `findingtrust`; -- -------------------------------------------------------- -- -- Table structure for table `auth_group` -- CREATE TABLE IF NOT EXISTS `auth_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `auth_group_permissions` -- CREATE TABLE IF NOT EXISTS `auth_group_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `permission_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`), KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `auth_permission` -- CREATE TABLE IF NOT EXISTS `auth_permission` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `content_type_id` int(11) NOT NULL, `codename` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ; -- -- Dumping data for table `auth_permission` -- INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (1, 'Can add log entry', 1, 'add_logentry'), (2, 'Can change log entry', 1, 'change_logentry'), (3, 'Can delete log entry', 1, 'delete_logentry'), (4, 'Can add permission', 2, 'add_permission'), (5, 'Can change permission', 2, 'change_permission'), (6, 'Can delete permission', 2, 'delete_permission'), (7, 'Can add group', 3, 'add_group'), (8, 'Can change group', 3, 'change_group'), (9, 'Can delete group', 3, 'delete_group'), (10, 'Can add content type', 4, 'add_contenttype'), (11, 'Can change content type', 4, 'change_contenttype'), (12, 'Can delete content type', 4, 'delete_contenttype'), (13, 'Can add session', 5, 'add_session'), (14, 'Can change session', 5, 'change_session'), (15, 'Can delete session', 5, 'delete_session'), (16, 'Can add orders', 6, 'add_orders'), (17, 'Can change orders', 6, 'change_orders'), (18, 'Can delete orders', 6, 'delete_orders'), (19, 'Can add ratings', 7, 'add_ratings'), (20, 'Can change ratings', 7, 'change_ratings'), (21, 'Can delete ratings', 7, 'delete_ratings'), (22, 'Can add product', 8, 'add_product'), (23, 'Can change product', 8, 'change_product'), (24, 'Can delete product', 8, 'delete_product'), (25, 'Can add user', 9, 'add_profile'), (26, 'Can change user', 9, 'change_profile'), (27, 'Can delete user', 9, 'delete_profile'), (28, 'Can add forward details', 10, 'add_forwarddetails'), (29, 'Can change forward details', 10, 'change_forwarddetails'), (30, 'Can delete forward details', 10, 'delete_forwarddetails'); -- -------------------------------------------------------- -- -- Table structure for table `consumer_orders` -- CREATE TABLE IF NOT EXISTS `consumer_orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `prodqty` int(11) NOT NULL, `location` varchar(200) NOT NULL, `user_id` int(11) NOT NULL, `prod_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `consumer_orders_user_id_90bd03f8_fk_general_profile_id` (`user_id`), KEY `consumer_orders_prod_id_6b4563f7_fk_serviceprovider_product_id` (`prod_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `consumer_orders` -- INSERT INTO `consumer_orders` (`id`, `prodqty`, `location`, `user_id`, `prod_id`) VALUES (1, 1, 'chennai', 2, 1), (2, 1, 'mumbai', 2, 2), (3, 1, 'chennai', 5, 3), (4, 2, 'chennai', 5, 6); -- -------------------------------------------------------- -- -- Table structure for table `consumer_ratings` -- CREATE TABLE IF NOT EXISTS `consumer_ratings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rpcost` int(11) NOT NULL, `rpquality` int(11) NOT NULL, `rsflexibitilty` int(11) NOT NULL, `rstrust` int(11) NOT NULL, `rstimedelivery` int(11) NOT NULL, `orders_id` int(11) NOT NULL, `prod_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `consumer_ratings_orders_id_ec242be6_fk_consumer_orders_id` (`orders_id`), KEY `consumer_ratings_prod_id_e39ad99f_fk_serviceprovider_product_id` (`prod_id`), KEY `consumer_ratings_user_id_65ab1d42_fk_general_profile_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `consumer_ratings` -- INSERT INTO `consumer_ratings` (`id`, `rpcost`, `rpquality`, `rsflexibitilty`, `rstrust`, `rstimedelivery`, `orders_id`, `prod_id`, `user_id`) VALUES (1, 5, 5, 3, 4, 4, 1, 1, 2), (2, 2, 3, 2, 3, 4, 1, 1, 2), (3, 4, 4, 4, 4, 4, 1, 1, 2), (4, 4, 2, 5, 5, 4, 4, 6, 5); -- -------------------------------------------------------- -- -- Table structure for table `django_admin_log` -- CREATE TABLE IF NOT EXISTS `django_admin_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_time` datetime(6) NOT NULL, `object_id` longtext, `object_repr` varchar(200) NOT NULL, `action_flag` smallint(5) unsigned NOT NULL, `change_message` longtext NOT NULL, `content_type_id` int(11) DEFAULT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`), KEY `django_admin_log_user_id_c564eba6_fk_general_profile_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `django_content_type` -- CREATE TABLE IF NOT EXISTS `django_content_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `app_label` varchar(100) NOT NULL, `model` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `django_content_type` -- INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (1, 'admin', 'logentry'), (3, 'auth', 'group'), (2, 'auth', 'permission'), (6, 'consumer', 'orders'), (7, 'consumer', 'ratings'), (4, 'contenttypes', 'contenttype'), (9, 'general', 'profile'), (8, 'serviceprovider', 'product'), (5, 'sessions', 'session'), (10, 'vendor', 'forwarddetails'); -- -------------------------------------------------------- -- -- Table structure for table `django_migrations` -- CREATE TABLE IF NOT EXISTS `django_migrations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `app` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `applied` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ; -- -- Dumping data for table `django_migrations` -- INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (1, 'contenttypes', '0001_initial', '2020-05-02 17:53:25.481445'), (2, 'contenttypes', '0002_remove_content_type_name', '2020-05-02 17:53:27.069335'), (3, 'auth', '0001_initial', '2020-05-02 17:53:32.370117'), (4, 'auth', '0002_alter_permission_name_max_length', '2020-05-02 17:53:33.242187'), (5, 'auth', '0003_alter_user_email_max_length', '2020-05-02 17:53:33.331054'), (6, 'auth', '0004_alter_user_username_opts', '2020-05-02 17:53:33.377929'), (7, 'auth', '0005_alter_user_last_login_null', '2020-05-02 17:53:33.439453'), (8, 'auth', '0006_require_contenttypes_0002', '2020-05-02 17:53:33.477539'), (9, 'auth', '0007_alter_validators_add_error_messages', '2020-05-02 17:53:33.535156'), (10, 'auth', '0008_alter_user_username_max_length', '2020-05-02 17:53:33.584960'), (11, 'general', '0001_initial', '2020-05-02 17:53:41.378906'), (12, 'admin', '0001_initial', '2020-05-02 17:53:44.157226'), (13, 'admin', '0002_logentry_remove_auto_add', '2020-05-02 17:53:44.207031'), (14, 'serviceprovider', '0001_initial', '2020-05-02 17:53:45.541015'), (15, 'serviceprovider', '0002_remove_product_rating', '2020-05-02 17:53:46.416992'), (16, 'serviceprovider', '0003_product_category', '2020-05-02 17:53:47.431640'), (17, 'consumer', '0001_initial', '2020-05-02 17:53:48.714843'), (18, 'consumer', '0002_auto_20171202_1124', '2020-05-02 17:53:53.877929'), (19, 'consumer', '0003_ratings', '2020-05-02 17:53:57.503906'), (20, 'general', '0002_auto_20171128_1027', '2020-05-02 17:53:57.568359'), (21, 'general', '0003_auto_20171201_1305', '2020-05-02 17:53:58.347656'), (22, 'sessions', '0001_initial', '2020-05-02 17:53:59.156250'), (23, 'vendor', '0001_initial', '2020-05-02 22:52:18.798828'), (24, 'consumer', '0004_orders_approval', '2020-05-03 01:43:04.327148'), (25, 'general', '0004_auto_20171202_1742', '2020-05-03 01:43:04.383789'), (26, 'consumer', '0005_remove_orders_approval', '2020-05-03 10:53:04.555226'), (27, 'serviceprovider', '0004_auto_20190303_1622', '2020-05-03 10:53:05.820851'); -- -------------------------------------------------------- -- -- Table structure for table `django_session` -- CREATE TABLE IF NOT EXISTS `django_session` ( `session_key` varchar(40) NOT NULL, `session_data` longtext NOT NULL, `expire_date` datetime(6) NOT NULL, PRIMARY KEY (`session_key`), KEY `django_session_expire_date_a5c62663` (`expire_date`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `django_session` -- INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('9lq8mphn96nw84ofng2dt49t7vani7oe', 'OTRlMjk1MWRjZDlkNTI0ZjhiYTcwZjJiYTIzOTZiNjNmOTlkMzI5Zjp7Il9hdXRoX3VzZXJfaWQiOiIyIiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiI0NDQ4OTM5YTNiNDY4MTI1YTVhNjNjNzAyMWIxYmM5MmEyYzQ4ZTkxIn0=', '2020-05-16 22:01:52.242187'), ('r1gx4j56fv11zlbsmvksw4l1r4p45h26', 'YmRmMWIzYzhiMjg0NjllMGNmM2FhNDBlYTAxOWNhZjNmZDEwNmJiMjp7Il9hdXRoX3VzZXJfaWQiOiI3IiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiJmYmM4MTRiMjFkZTc3N2ExOGFmODQyMmEwZDA0NWYwNTEzMGQ0MjY4In0=', '2020-06-17 12:30:06.745117'), ('vyajx8pa0zxg6y35arn3pp36fnnubq5x', 'ODMwNjUxMjIzOWU0NDNjODhhNmE5NGRjMDFjODExOGFiOWIxNjNkZjp7Il9hdXRoX3VzZXJfaWQiOiIzIiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiJjODQxYThkNTMzOWM2YzAzZGViMjc0MTU0ZmViMzY4ZWRkNTZjMGVhIn0=', '2020-06-16 19:05:16.338867'); -- -------------------------------------------------------- -- -- Table structure for table `general_profile` -- CREATE TABLE IF NOT EXISTS `general_profile` ( `id` int(11) NOT NULL AUTO_INCREMENT, `password` varchar(128) NOT NULL, `last_login` datetime(6) DEFAULT NULL, `is_superuser` tinyint(1) NOT NULL, `username` varchar(150) NOT NULL, `first_name` varchar(30) NOT NULL, `last_name` varchar(30) NOT NULL, `email` varchar(254) NOT NULL, `is_staff` tinyint(1) NOT NULL, `is_active` tinyint(1) NOT NULL, `date_joined` datetime(6) NOT NULL, `location` varchar(30) NOT NULL, `user_type` varchar(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `general_profile` -- INSERT INTO `general_profile` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `location`, `user_type`) VALUES (1, 'pbkdf2_sha256$36000$namqIxZ8LAYa$/lYax8zRzzWu7qrOoCK7Vua7l9qC2RdnSaTvH6+WWys=', '2020-05-03 01:32:44.866210', 0, 'gokul', 'gokul', 's', '[email protected]', 0, 1, '2020-05-02 17:56:06.898437', 'chennai', 'SPR'), (2, 'pbkdf2_sha256$36000$BQoKd072gInJ$OIScG3w8yl6ugqXnHO1eYYiFYG1iZw4eyTJ5VwM74zk=', '2020-05-03 01:27:25.718750', 0, 'suresh', 'suresh', 'N', '[email protected]', 0, 1, '2020-05-02 18:00:19.195312', 'chennai', 'CSR'), (3, 'pbkdf2_sha256$36000$TgJoJ2nfyMnt$s9xYL54mo8tWTrBBY4qs/DvKpGnwEqrCQPTvNHV7slU=', '2020-05-03 00:28:45.010742', 0, 'siva', 'siva', 's', '[email protected]', 0, 1, '2020-05-02 18:42:11.214843', 'chennai', 'VEN'), (4, 'pbkdf2_sha256$36000$nfUY3h8ilOmQ$vG7kKJ9yorQu4vc1kDZ9OLjL//eHL4WYckEoCU4NM70=', '2020-05-03 01:22:31.536132', 0, 'dev', 'dev', 'patel', '[email protected]', 0, 1, '2020-05-03 01:22:19.163085', 'chennai', 'SPR'), (5, 'pbkdf2_sha256$36000$yuBOE8JlnfSo$vjKLQAaaDtZaZvCr/28SqwUAZG55zj1d+jKan4y6sXU=', '2020-05-06 01:25:48.138671', 0, 'ravi', 'ravi', 'kumar', '[email protected]', 0, 1, '2020-05-03 01:25:40.704101', 'chennai', 'CSR'), (6, 'pbkdf2_sha256$36000$qgDQod9u3YyO$c4VnfXEXU3RtlkZrs52gX8FWB8t0IfmnRq3hxFbzoVM=', '2020-05-06 12:29:30.361328', 0, 'venkat', 'venkat', 'sabari', '[email protected]', 0, 1, '2020-05-03 11:21:18.513234', 'chennai', 'CSR'), (7, 'pbkdf2_sha256$36000$t8YqRz1bJqK8$nXJ6/uWU7hltwMMskohj0rptigdtBibtpgpI03KPF3A=', '2020-05-06 12:30:06.728515', 0, 'sabari', 'sabari', 'venkat', '[email protected]', 0, 1, '2020-05-03 11:26:38.854054', 'chennai', 'SPR'); -- -------------------------------------------------------- -- -- Table structure for table `general_profile_groups` -- CREATE TABLE IF NOT EXISTS `general_profile_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `general_profile_groups_profile_id_group_id_2fbe609e_uniq` (`profile_id`,`group_id`), KEY `general_profile_groups_group_id_3befd3aa_fk_auth_group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `general_profile_user_permissions` -- CREATE TABLE IF NOT EXISTS `general_profile_user_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile_id` int(11) NOT NULL, `permission_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `general_profile_user_per_profile_id_permission_id_4ec35cbe_uniq` (`profile_id`,`permission_id`), KEY `general_profile_user_permission_id_d7c45d82_fk_auth_perm` (`permission_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `serviceprovider_product` -- CREATE TABLE IF NOT EXISTS `serviceprovider_product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `weight` int(11) NOT NULL, `price` varchar(200) NOT NULL, `description` varchar(300) NOT NULL, `images` varchar(100) NOT NULL, `user_id` int(11) NOT NULL, `category` int(11) NOT NULL, `city` varchar(100) NOT NULL, `state` varchar(100) NOT NULL, PRIMARY KEY (`id`), KEY `serviceprovider_product_user_id_b428705e_fk_general_profile_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `serviceprovider_product` -- INSERT INTO `serviceprovider_product` (`id`, `name`, `weight`, `price`, `description`, `images`, `user_id`, `category`, `city`, `state`) VALUES (1, 'Mobile', 5, '8656', 'It is a god to see and give natural look and feel', 'mobile.jpg', 1, 1, 'Chennai', 'Tamil Nadu'), (2, 'laptop', 2, '25662', 'It is a good to see and give natural look and feel', 'laptop.jpg', 1, 1, 'Chennai', 'Tamil Nadu'), (3, 'mixer', 20, '2500', 'It is a good Product and very flexible', 'mixer.jpg', 1, 2, 'Tirupati', 'Andhra Pradesh'), (4, 'juicer', 15, '2600', 'Very Worth product', 'juicers.png', 1, 2, 'Ajana', 'Goa'), (5, 'Steve Jobs Book', 2, '455', 'Good for knowledge', 'book1.jpg', 1, 6, 'Ranchi', 'Jharkhand'), (6, 'Wings of Fire', 2, '485', 'Inspiring Book', 'book2.jpg', 1, 6, 'Howrah', 'Kolkata'), (7, 'Tennis Racket', 5, '1866', 'It is a good to see and give natural look and feel', 'sports.jpg', 1, 4, 'Howrah ', 'Mumbai'), (8, 'Shuttle Net', 2, '6523', 'It is a very good material', 'badminton.jpg', 1, 4, 'bangolore', 'Karnataka'), (9, 'Charger', 2, '100', 'It is good sustainable', 'charger.jpg', 1, 1, 'Jaipur', 'Rajasthan'), (10, 'Hockey Stic', 2, '366', 'Good to handle and very flexible', 'hocky.jpg', 1, 4, 'Bhopal', 'Madhya Pradesh'); -- -------------------------------------------------------- -- -- Table structure for table `vendor_forwarddetails` -- CREATE TABLE IF NOT EXISTS `vendor_forwarddetails` ( `id` int(11) NOT NULL AUTO_INCREMENT, `to_vendor` varchar(200) NOT NULL, `to_sp` varchar(200) NOT NULL, `status` varchar(200) NOT NULL, `order_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `vendor_forwarddetails_order_id_721da35e_fk_consumer_orders_id` (`order_id`), KEY `vendor_forwarddetails_user_id_0682a397_fk_general_profile_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Constraints for dumped tables -- -- -- Constraints for table `auth_group_permissions` -- ALTER TABLE `auth_group_permissions` ADD CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), ADD CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`); -- -- Constraints for table `auth_permission` -- ALTER TABLE `auth_permission` ADD CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`); -- -- Constraints for table `consumer_orders` -- ALTER TABLE `consumer_orders` ADD CONSTRAINT `consumer_orders_prod_id_6b4563f7_fk_serviceprovider_product_id` FOREIGN KEY (`prod_id`) REFERENCES `serviceprovider_product` (`id`), ADD CONSTRAINT `consumer_orders_user_id_90bd03f8_fk_general_profile_id` FOREIGN KEY (`user_id`) REFERENCES `general_profile` (`id`); -- -- Constraints for table `consumer_ratings` -- ALTER TABLE `consumer_ratings` ADD CONSTRAINT `consumer_ratings_orders_id_ec242be6_fk_consumer_orders_id` FOREIGN KEY (`orders_id`) REFERENCES `consumer_orders` (`id`), ADD CONSTRAINT `consumer_ratings_prod_id_e39ad99f_fk_serviceprovider_product_id` FOREIGN KEY (`prod_id`) REFERENCES `serviceprovider_product` (`id`), ADD CONSTRAINT `consumer_ratings_user_id_65ab1d42_fk_general_profile_id` FOREIGN KEY (`user_id`) REFERENCES `general_profile` (`id`); -- -- Constraints for table `django_admin_log` -- ALTER TABLE `django_admin_log` ADD CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`), ADD CONSTRAINT `django_admin_log_user_id_c564eba6_fk_general_profile_id` FOREIGN KEY (`user_id`) REFERENCES `general_profile` (`id`); -- -- Constraints for table `general_profile_groups` -- ALTER TABLE `general_profile_groups` ADD CONSTRAINT `general_profile_groups_group_id_3befd3aa_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), ADD CONSTRAINT `general_profile_groups_profile_id_ec6a808d_fk_general_profile_id` FOREIGN KEY (`profile_id`) REFERENCES `general_profile` (`id`); -- -- Constraints for table `general_profile_user_permissions` -- ALTER TABLE `general_profile_user_permissions` ADD CONSTRAINT `general_profile_user_permission_id_d7c45d82_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), ADD CONSTRAINT `general_profile_user_profile_id_15be2332_fk_general_p` FOREIGN KEY (`profile_id`) REFERENCES `general_profile` (`id`); -- -- Constraints for table `serviceprovider_product` -- ALTER TABLE `serviceprovider_product` ADD CONSTRAINT `serviceprovider_product_user_id_b428705e_fk_general_profile_id` FOREIGN KEY (`user_id`) REFERENCES `general_profile` (`id`); -- -- Constraints for table `vendor_forwarddetails` -- ALTER TABLE `vendor_forwarddetails` ADD CONSTRAINT `vendor_forwarddetails_user_id_0682a397_fk_general_profile_id` FOREIGN KEY (`user_id`) REFERENCES `general_profile` (`id`), ADD CONSTRAINT `vendor_forwarddetails_order_id_721da35e_fk_consumer_orders_id` FOREIGN KEY (`order_id`) REFERENCES `consumer_orders` (`id`);
