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 3,001–3,025 of 5,412

payment, page 121 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3001debit_card15002018-03-15 23:05:39
3002credit_card17002018-03-16 14:04:42
3003debit_card30002018-03-16 19:17:22
3004credit_card15002018-03-16 22:08:56
3005credit_card8002018-03-17 09:41:09
3006credit_card8002018-03-17 09:41:55
3007credit_card8002018-03-17 09:41:57
3008digital_wallet68002018-03-17 10:58:18
3009debit_card15002018-03-17 12:43:01
3010digital_wallet34002018-03-18 10:33:09
3011debit_card34002018-03-18 11:05:07
3012digital_wallet8002018-03-18 11:32:42
3013debit_card8002018-03-18 16:44:11
3014credit_card15002018-03-18 22:13:45
3015credit_card15002018-03-18 22:24:58
3016digital_wallet30002018-03-19 15:06:55
3017debit_card4002018-03-20 03:14:36
3018cash85002018-03-20 13:01:50
3019digital_wallet8002018-03-20 13:25:43
3020debit_card8002018-03-20 14:53:03
3021credit_card15002018-03-20 23:59:41
3022digital_wallet17002018-03-21 09:21:03
3023debit_card30002018-03-21 10:22:34
3024credit_card45002018-03-22 12:20:05
3025credit_card4002018-03-23 05:28:37
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;