Used by Buyers to communicate what they want to buy (An RFX LISTING),
used by Suppliers to search listings and make offers,
and used by Buyers and/or Suppliers to sort and manage transactions and history.
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';
1
1
1
3
SHOW FULL COLUMNS FROM `users`
62
62
1
4
SHOW FULL COLUMNS FROM `groups`
2
2
1
5
SHOW FULL COLUMNS FROM `corporations`
4
4
1
6
SHOW FULL COLUMNS FROM `accounts`
17
17
1
7
SHOW FULL COLUMNS FROM `business_designations`
18
18
1
8
SHOW FULL COLUMNS FROM `offers`
79
79
1
9
SHOW FULL COLUMNS FROM `contracts`
164
164
1
10
SHOW FULL COLUMNS FROM `pp_actions`
37
37
1
11
SHOW FULL COLUMNS FROM `uploads`
10
10
1
12
SHOW FULL COLUMNS FROM `categories`
3
3
1
13
SHOW FULL COLUMNS FROM `multiple_listings`
31
31
1
14
SHOW FULL COLUMNS FROM `ndas`
12
12
1
15
SHOW FULL COLUMNS FROM `cake_sessions`
3
3
1
16
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_sessions` AS `Session` WHERE `id` = '8c61d76741a7cf8088ef8a7d24ae1faa' LIMIT 1
0
0
0
17
SELECT DISTINCT `Category`.`id`, `Category`.`category`, `Listing`.`id` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`published` = 1 AND `Listing`.`expire_date_listing` >= '2026-07-10' AND `Listing`.`under_contract` = 0 AND `Listing`.`deleted` = 0 ORDER BY `Category`.`order` ASC
0
0
3
18
SELECT `Category`.`id`, `Category`.`category`, `Category`.`order` FROM `categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`order` ASC LIMIT 4307, 24
