Skip to content
Louvre Ops DB

Table

payment

One row per payment; the method is a single column.

Replaces in 2020: Payment Methods

Download CSV Query in playground

Rows 4,876–4,900 of 5,412

payment, page 196 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4876credit_card4002019-09-12 08:17:06
4877cash34002019-09-12 09:10:33
4878digital_wallet15002019-09-13 09:43:41
4879digital_wallet8002019-09-13 11:37:15
4880digital_wallet8002019-09-13 11:41:06
4881credit_card4002019-09-14 06:31:09
4882credit_card8002019-09-14 09:28:07
4883cash34002019-09-14 11:17:33
4884credit_card8002019-09-14 14:47:24
4885credit_card75002019-09-15 08:00:45
4886credit_card60002019-09-15 08:18:57
4887cash51002019-09-15 09:58:12
4888credit_card870002019-09-15 15:21:06
4889debit_card15002019-09-15 19:14:47
4890credit_card30002019-09-15 20:58:03
4891debit_card4002019-09-17 02:28:13
4892credit_card4002019-09-17 08:17:37
4893debit_card15002019-09-17 13:26:09
4894credit_card4002019-09-17 21:19:06
4895debit_card15002019-09-18 10:56:10
4896debit_card15002019-09-19 12:08:42
4897credit_card60002019-09-20 09:58:35
4898credit_card30002019-09-20 14:52:33
4899debit_card15002019-09-22 08:10:13
4900credit_card45002019-09-22 08:57:10
Table definition
CREATE TABLE payment (
  payment_id   INTEGER PRIMARY KEY,
  method       TEXT NOT NULL
               CHECK (method IN ('credit_card', 'debit_card', 'digital_wallet', 'cash')),
  amount_cents INTEGER NOT NULL CHECK (amount_cents >= 0),
  paid_at      TEXT NOT NULL CHECK (paid_at GLOB '[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]')
) STRICT;