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,551–4,575 of 5,412

payment, page 183 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4551credit_card8002019-06-22 12:07:48
4552cash8002019-06-22 12:34:43
4553digital_wallet15002019-06-22 21:58:12
4554credit_card30002019-06-23 16:12:59
4555credit_card8002019-06-23 17:00:09
4556digital_wallet60002019-06-23 22:31:04
4557credit_card4002019-06-23 23:01:32
4558credit_card8002019-06-24 12:56:12
4559debit_card8002019-06-24 13:01:55
4560credit_card8002019-06-24 13:02:09
4561debit_card4002019-06-24 17:04:47
4562debit_card30002019-06-24 19:37:18
4563credit_card15002019-06-24 23:48:54
4564cash51002019-06-25 10:37:13
4565digital_wallet30002019-06-25 22:31:44
4566debit_card15002019-06-26 10:46:22
4567credit_card4002019-06-26 11:26:02
4568digital_wallet30002019-06-26 22:26:55
4569debit_card68002019-06-27 13:44:11
4570digital_wallet30002019-06-27 20:18:29
4571debit_card4002019-06-27 22:43:53
4572credit_card8002019-06-28 14:28:37
4573digital_wallet60002019-06-28 15:59:39
4574cash51002019-06-29 09:43:57
4575debit_card8002019-06-29 10:12:53
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;