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,051–4,075 of 5,412

payment, page 163 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4051credit_card15002019-01-18 12:33:11
4052credit_card15002019-01-18 15:40:27
4053credit_card68002019-01-19 08:59:59
4054digital_wallet8002019-01-19 09:21:55
4055credit_card17002019-01-19 10:14:37
4056debit_card34002019-01-19 11:58:46
4057debit_card4002019-01-20 04:49:39
4058credit_card8002019-01-20 09:50:47
4059credit_card60002019-01-20 16:57:56
4060debit_card30002019-01-21 11:46:58
4061credit_card30002019-01-23 07:03:59
4062credit_card30002019-01-23 08:32:33
4063debit_card4002019-01-23 22:33:42
4064credit_card4002019-01-24 04:04:55
4065debit_card34002019-01-24 14:51:18
4066credit_card8002019-01-24 15:19:42
4067credit_card15002019-01-24 17:30:19
4068digital_wallet8002019-01-25 17:02:14
4069debit_card4002019-01-26 03:43:21
4070credit_card15002019-01-26 22:28:04
4071credit_card15002019-01-27 23:32:02
4072credit_card4002019-01-28 06:59:11
4073debit_card30002019-01-29 09:25:33
4074credit_card735002019-01-29 13:45:00
4075digital_wallet15002019-01-29 23:14:06
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;