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,901–4,925 of 5,412

payment, page 197 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4901cash68002019-09-22 11:18:59
4902digital_wallet8002019-09-22 12:56:58
4903credit_card8002019-09-22 15:52:01
4904credit_card45002019-09-22 19:51:55
4905cash34002019-09-23 10:27:06
4906credit_card8002019-09-23 10:42:02
4907digital_wallet60002019-09-24 15:58:47
4908credit_card30002019-09-24 17:35:56
4909credit_card4002019-09-24 21:58:13
4910digital_wallet15002019-09-25 09:38:22
4911credit_card15002019-09-25 10:43:46
4912credit_card4002019-09-26 04:21:46
4913cash34002019-09-28 09:38:43
4914debit_card4002019-09-29 07:22:57
4915credit_card34002019-09-29 08:41:16
4916digital_wallet8002019-09-29 09:23:24
4917debit_card15002019-09-29 17:48:56
4918digital_wallet60002019-09-29 23:48:42
4919debit_card30002019-10-02 08:52:21
4920debit_card45002019-10-02 09:29:55
4921credit_card30002019-10-02 19:51:26
4922credit_card4002019-10-03 08:41:32
4923credit_card34002019-10-03 10:26:26
4924credit_card45002019-10-03 13:19:37
4925debit_card4002019-10-04 11:30:08
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;