sideshow.db.model.customers

Data models for Customers

class sideshow.db.model.customers.CustomerMixin[source]

Base class for customer tables. This has shared columns, used by e.g.:

class sideshow.db.model.customers.LocalCustomer(**kwargs)[source]

This table contains the local customer records.

Sideshow will do customer lookups against this table by default, unless it’s configured to use external customers instead.

Also by default, when a new order batch with a pending customer is executed, a new record is added to this local customers table, for lookup next time.

email_address

Email address for the customer.

external_id

ID of the proper customer account associated with this record, if applicable.

first_name

First name of the customer.

full_name

Full display name for the customer account.

last_name

Last name of the customer.

new_order_batches

List of NewOrderBatch records associated with this customer.

orders

List of Order records associated with this customer.

phone_number

Phone number for the customer.

class sideshow.db.model.customers.PendingCustomer(**kwargs)[source]

This table contains the pending customer records, used when creating an order for new/unknown customer.

Sideshow will automatically create and (hopefully) delete these records as needed.

By default, when a new order batch with a pending customer is executed, a new record is added to the local customers table, for lookup next time.

created

Timestamp when the customer record was created.

created_by

Reference to the User who created the customer record.

customer_id

ID of the proper customer account associated with this record, if applicable.

email_address

Email address for the customer.

first_name

First name of the customer.

full_name

Full display name for the customer account.

last_name

Last name of the customer.

new_order_batches

List of NewOrderBatch records associated with this customer.

orders

List of Order records associated with this customer.

phone_number

Phone number for the customer.

status

Status code for the customer record.