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,376–3,400 of 5,412

payment, page 136 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3376credit_card4002018-06-29 03:22:31
3377digital_wallet51002018-06-29 08:32:12
3378credit_card30002018-06-29 09:35:27
3379cash8002018-06-29 11:02:13
3380credit_card34002018-06-29 11:40:17
3381digital_wallet30002018-06-29 16:35:24
3382credit_card30002018-06-29 20:19:21
3383debit_card30002018-06-29 22:07:28
3384credit_card34002018-06-30 09:42:09
3385credit_card68002018-06-30 10:47:15
3386credit_card690002018-06-30 13:28:55
3387digital_wallet8002018-06-30 17:05:16
3388debit_card8002018-06-30 17:11:44
3389credit_card34002018-07-01 10:21:38
3390credit_card30002018-07-02 15:59:23
3391credit_card17002018-07-02 16:32:14
3392credit_card4002018-07-02 23:27:51
3393digital_wallet15002018-07-03 12:09:30
3394digital_wallet34002018-07-03 13:57:22
3395debit_card4002018-07-03 20:34:10
3396digital_wallet8002018-07-04 15:57:35
3397credit_card30002018-07-05 08:25:37
3398debit_card15002018-07-05 10:15:54
3399cash51002018-07-05 10:43:38
3400credit_card34002018-07-05 11:30:32
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;