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,076–4,100 of 5,412

payment, page 164 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4076credit_card60002019-01-30 16:42:42
4077credit_card4002019-01-31 01:37:39
4078credit_card645002019-01-31 12:13:23
4079digital_wallet30002019-01-31 13:45:59
4080credit_card30002019-02-01 10:31:08
4081credit_card15002019-02-01 16:38:55
4082cash34002019-02-02 15:23:14
4083credit_card8002019-02-02 16:14:44
4084credit_card75002019-02-02 19:32:27
4085credit_card4002019-02-03 04:28:35
4086digital_wallet8002019-02-03 12:18:36
4087credit_card15002019-02-04 07:44:51
4088debit_card17002019-02-04 10:43:37
4089digital_wallet15002019-02-04 16:46:14
4090credit_card51002019-02-05 11:48:03
4091debit_card30002019-02-05 12:03:14
4092credit_card4002019-02-06 16:55:39
4093digital_wallet30002019-02-06 17:08:05
4094digital_wallet30002019-02-06 20:36:48
4095digital_wallet30002019-02-07 08:29:21
4096debit_card4002019-02-07 08:59:15
4097digital_wallet15002019-02-07 10:37:41
4098debit_card4002019-02-07 16:04:08
4099debit_card4002019-02-08 11:18:05
4100credit_card15002019-02-08 11:18:59
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;