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,251–3,275 of 5,412

payment, page 131 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3251digital_wallet17002018-05-23 12:00:02
3252credit_card34002018-05-23 14:29:27
3253debit_card30002018-05-24 08:26:38
3254cash34002018-05-24 13:59:09
3255credit_card8002018-05-25 13:35:21
3256debit_card15002018-05-25 14:24:37
3257digital_wallet17002018-05-25 14:33:27
3258debit_card4002018-05-26 08:30:07
3259debit_card34002018-05-26 10:32:35
3260credit_card15002018-05-26 10:34:17
3261credit_card15002018-05-26 21:19:39
3262debit_card4002018-05-27 04:03:20
3263credit_card4002018-05-27 10:23:09
3264digital_wallet34002018-05-27 10:42:04
3265digital_wallet8002018-05-27 11:32:51
3266credit_card60002018-05-27 15:03:48
3267debit_card34002018-05-28 10:09:39
3268cash17002018-05-28 11:36:04
3269debit_card4002018-05-28 21:44:22
3270debit_card30002018-05-28 22:08:45
3271credit_card465002018-05-29 09:18:48
3272credit_card45002018-05-29 21:31:31
3273debit_card4002018-05-30 04:03:13
3274digital_wallet34002018-05-30 09:07:42
3275cash8002018-05-30 09:56:55
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;