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,976–4,000 of 5,412

payment, page 160 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3976credit_card4002018-12-15 21:21:45
3977debit_card15002018-12-15 22:22:31
3978credit_card30002018-12-16 07:16:30
3979credit_card8002018-12-16 10:28:54
3980credit_card8002018-12-16 13:05:44
3981credit_card17002018-12-16 16:05:48
3982debit_card4002018-12-17 01:27:25
3983credit_card15002018-12-17 22:25:48
3984debit_card15002018-12-18 08:55:27
3985cash8002018-12-18 09:55:39
3986credit_card4002018-12-18 12:41:02
3987digital_wallet34002018-12-19 08:40:07
3988debit_card30002018-12-19 11:23:14
3989cash8002018-12-19 12:51:30
3990cash17002018-12-19 14:03:56
3991credit_card4002018-12-20 04:30:24
3992debit_card30002018-12-20 08:00:39
3993credit_card555002018-12-20 08:24:13
3994credit_card15002018-12-20 09:06:29
3995cash8002018-12-20 09:57:16
3996credit_card30002018-12-21 11:18:12
3997debit_card45002018-12-22 08:42:17
3998digital_wallet85002018-12-22 10:02:24
3999debit_card8002018-12-22 10:38:26
4000credit_card8002018-12-22 11:31:15
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;