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,226–4,250 of 5,412

payment, page 170 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4226digital_wallet8002019-03-20 11:45:17
4227debit_card34002019-03-20 13:57:48
4228digital_wallet8002019-03-20 14:46:27
4229cash8002019-03-20 14:51:34
4230debit_card30002019-03-20 16:16:51
4231credit_card8002019-03-21 11:57:56
4232digital_wallet34002019-03-21 14:12:57
4233credit_card8002019-03-21 14:38:16
4234digital_wallet15002019-03-22 11:41:44
4235debit_card45002019-03-23 12:45:14
4236credit_card15002019-03-23 14:39:20
4237credit_card4002019-03-24 04:06:42
4238debit_card4002019-03-24 04:35:23
4239digital_wallet75002019-03-24 20:04:26
4240debit_card8002019-03-25 10:35:25
4241debit_card4002019-03-25 17:26:14
4242credit_card30002019-03-27 08:42:10
4243credit_card17002019-03-27 09:23:37
4244credit_card68002019-03-27 11:07:33
4245debit_card60002019-03-28 17:44:12
4246credit_card30002019-03-28 18:13:52
4247debit_card4002019-03-29 02:37:21
4248digital_wallet15002019-03-29 08:21:27
4249debit_card60002019-03-29 13:56:03
4250credit_card4002019-03-30 05:46:04
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;