VbzCart/tables - Revision history

Woozle: /* Event Logging */ more obsolete tables, so I can close the tabs

2020-03-03T13:47:53Z

Event Logging: more obsolete tables, so I can close the tabs

← Older revision		Revision as of 13:47, 3 March 2020
Line 141:		Line 141:
	** to be converted:		** to be converted:
	*** [[/stk_history]]		*** [[/stk_history]]
	* ~~no longer needed~~:		* obsolete:
	** [[/event_log]] - now renamed <code>OLD event_log</code>, soon to be removed		** [[/event_log]] - now renamed <code>OLD event_log</code>, soon to be removed
	** [[/shop_cart_event]] - now renamed <code>OLD shop_cart_event</code>, to be removed after checking that data has been migrated		** [[/shop_cart_event]] - now renamed <code>OLD shop_cart_event</code>, to be removed after checking that data has been migrated
			** [[/ord_pull]]
			*** [[/ord_pull/migration]]
			** [[/shop_cart_event]]

	===Miscellaneous===		===Miscellaneous===

Woozle: /* Customers */ table name updates

2019-10-26T22:51:57Z

Customers: table name updates

← Older revision		Revision as of 22:51, 26 October 2019
Line 59:		Line 59:
	There ought to be a better way to organize this stuff, but I haven't been able to think of one that doesn't cause worse problems. Each type of customer data has its own set of fields and its own search-optimization, and combining them results in the awkward possibility of pulling up the wrong type of data under certain circumstances. So, until something better comes along...		There ought to be a better way to organize this stuff, but I haven't been able to think of one that doesn't cause worse problems. Each type of customer data has its own set of fields and its own search-optimization, and combining them results in the awkward possibility of pulling up the wrong type of data under certain circumstances. So, until something better comes along...

	* [[/~~core_custs~~]] - main customer records		* [[/cust]] - main customer records
	* [[/~~cust_addrs~~]] - customer mailing addresses (shipping and credit card)		* [[/cust_addr]] - customer mailing addresses (shipping and credit card)
	* [[/cust_cards]] - customer credit card numbers - '''sensitive data'''		* [[/cust_cards]] - customer credit card numbers - '''sensitive data'''
	* [[/cust_emails]] - customer email addresses		* [[/cust_emails]] - customer email addresses
	* [[/cust_names]] - customer names/aliases		* <s>[[/cust_names]] - customer names/aliases</s> - deprecated
	* [[/cust_phones]] - customer phone numbers		* [[/cust_phones]] - customer phone numbers
	* [[/cust_charges]] - credit card charges - '''sensitive data''' (includes card #s)		* [[/cust_charges]] - credit card charges - '''sensitive data''' (includes card #s)

	===Users===		===Users===
	Customers can be users, but only when they've created a user account. Users can also be admins and (eventually) suppliers and vendors.		Customers can be users, but only when they've created a user account. Users can also be admins and (eventually) suppliers and vendors.

Woozle: /* Shopping */ cart_data

2019-07-25T15:05:56Z

Shopping: cart_data

← Older revision		Revision as of 15:05, 25 July 2019
Line 90:		Line 90:
	** [[/shop_cart_line]]		** [[/shop_cart_line]]
	** [[/shop_cart_event]]		** [[/shop_cart_event]]
	** [[/shop_cart_data]]		** [[/cart_data]]
			** [[/shop_cart_data]] - OBSOLETE

	===Stock Management===		===Stock Management===

Woozle: /* Event Logging */ updates: shop_cart_event

2018-02-22T01:31:31Z

Event Logging: updates: shop_cart_event

← Older revision		Revision as of 01:31, 22 February 2018
Line 139:		Line 139:
	** to be converted:		** to be converted:
	*** [[/stk_history]]		*** [[/stk_history]]
	*** [[/shop_cart_event]]
	* no longer needed:		* no longer needed:
	** [[/event_log]] - soon to be removed		** [[/event_log]] - now renamed <code>OLD event_log</code>, soon to be removed
			** [[/shop_cart_event]] - now renamed <code>OLD shop_cart_event</code>, to be removed after checking that data has been migrated

	===Miscellaneous===		===Miscellaneous===

Woozle: /* Event Logging */ oh, yeah, the cart log...

2018-02-22T01:20:54Z

Event Logging: oh, yeah, the cart log...

← Older revision		Revision as of 01:20, 22 February 2018
Line 139:		Line 139:
	** to be converted:		** to be converted:
	*** [[/stk_history]]		*** [[/stk_history]]
			*** [[/shop_cart_event]]
	* no longer needed:		* no longer needed:
	** [[/event_log]] - soon to be removed		** [[/event_log]] - soon to be removed

Woozle: file management

2017-07-23T00:32:18Z

file management

← Older revision		Revision as of 00:32, 23 July 2017
Line 13:		Line 13:
	* [[/cat_ittyps]]: item types - every item has one, but they are often all the same		* [[/cat_ittyps]]: item types - every item has one, but they are often all the same
	* [[/cat_ioptns]]: these typically distinguish items within a title		* [[/cat_ioptns]]: these typically distinguish items within a title
	* [[/cat_folders]]: where things are stored and how to access them (sort of a mini-[[FileFerret]])
	* [[/cat_topic]]: categorization		* [[/cat_topic]]: categorization
	** [[/cat_title_x_topic]]: titles for each topic		** [[/cat_title_x_topic]]: titles for each topic
	* [[/cat_images]]: image data; so far, we only keep track of images by title
	* [[/cat_ship_cost]]: shipping costs for different types of item		* [[/cat_ship_cost]]: shipping costs for different types of item
	* [[/cat_pages]]: mapping URLs to various catalog entities (suppliers, depts, titles)		* [[/cat_pages]]: mapping URLs to various catalog entities (suppliers, depts, titles)
Line 34:		Line 32:
	* [[/ctg_upd1]]		* [[/ctg_upd1]]
	* [[/ctg_upd2]]		* [[/ctg_upd2]]
			===File Management===
			* [[/fm_node]]: a filesystem entity (could be either file or folder)
			* [[/fm_file]]: files of any type
			* [[/fm_folder]]: places where files can be stored
			* [[/cat_images]]: files that are images, with additional metadata
	===Ordering===		===Ordering===
	Cart data and line-items are converted to orders and order lines when the customer confirms the order. Orders become the focal point for a lot of other activity, such as shipping, transactions, and tracking of status changes.		Cart data and line-items are converted to orders and order lines when the customer confirms the order. Orders become the focal point for a lot of other activity, such as shipping, transactions, and tracking of status changes.

Woozle: /* Event Logging */ stk_history

2017-06-11T16:04:37Z

Event Logging: stk_history

← Older revision		Revision as of 16:04, 11 June 2017
Line 135:		Line 135:
	** [[/event_vc_ord_hold]] - order status log		** [[/event_vc_ord_hold]] - order status log
	*** [[/ord_hold_type]]		*** [[/ord_hold_type]]
			** to be converted:
			*** [[/stk_history]]
	* no longer needed:		* no longer needed:
	** [[/event_log]] - soon to be removed		** [[/event_log]] - soon to be removed

Woozle: /* Ordering */ there have been changes

2017-06-02T11:26:15Z

Ordering: there have been changes

← Older revision		Revision as of 11:26, 2 June 2017
Line 45:		Line 45:
	** [[/ord_trxact]] - order transactions		** [[/ord_trxact]] - order transactions
	** [[/ord_trx_type]] - order transaction types		** [[/ord_trx_type]] - order transaction types
	** [[/ord_event]] - internal events not generally affecting order status
	** [[/ord_pull]]
	*** [[/ord_pull_type]] - can this be migrated to ord_event_type?
	*** [[/ord_change]] - admin-initiated events which change order status; will eventually replace and supplement ord_pull
	**** [[/ord_change_type]]
	** [[/ord_msg]]		** [[/ord_msg]]
	*** [[/ord_msg_media]]		*** [[/ord_msg_media]]
			** ''see also [[#Event Logging]]''
	* [[/card_auth_code]] - reference table for payment status codes; this should probably be a hard-coded array, not a table		* [[/card_auth_code]] - reference table for payment status codes; this should probably be a hard-coded array, not a table
			* '''obsolete''':
			** [[/ord_pull]]
			*** [[/ord_pull_type]]
			** [[/ord_event]] - internal events not generally affecting order status

	===Customers===		===Customers===

Woozle: /* Event Logging */

2017-06-02T10:40:12Z

Event Logging

← Older revision		Revision as of 10:40, 2 June 2017
Line 135:		Line 135:
	** [[/event_vc_ord_hold]] - order status log		** [[/event_vc_ord_hold]] - order status log
	*** [[/ord_hold_type]]		*** [[/ord_hold_type]]
	* no longer needed~~; may be removed~~:		* no longer needed:
	* [[/event_log]] - soon to be removed		** [[/event_log]] - soon to be removed

	===Miscellaneous===		===Miscellaneous===

Woozle: /* Event Logging */ order pulls renamed

2017-06-02T10:39:49Z

Event Logging: order pulls renamed

← Older revision		Revision as of 10:39, 2 June 2017
Line 133:		Line 133:
	** [[/event_vc_legacy]] - old log data		** [[/event_vc_legacy]] - old log data
	** [[/event_vc_bin]] - stock bin log		** [[/event_vc_bin]] - stock bin log
	** [[/~~event_vc_ord_change~~]] - order status log		** [[/event_vc_ord_hold]] - order status log
			*** [[/ord_hold_type]]
	* no longer needed; may be removed:		* no longer needed; may be removed:
	* [[/event_log]] - soon to be removed		* [[/event_log]] - soon to be removed