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,026–3,050 of 5,412

payment, page 122 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3026credit_card60002018-03-23 16:27:41
3027credit_card15002018-03-24 10:06:56
3028digital_wallet34002018-03-24 10:25:55
3029credit_card8002018-03-24 11:12:54
3030credit_card4002018-03-24 21:27:00
3031debit_card4002018-03-25 00:25:18
3032credit_card4002018-03-25 06:06:55
3033credit_card30002018-03-25 15:29:38
3034credit_card34002018-03-26 10:37:30
3035cash34002018-03-26 12:06:58
3036credit_card8002018-03-26 12:31:20
3037credit_card4002018-03-26 14:55:44
3038credit_card15002018-03-26 20:07:38
3039debit_card15002018-03-27 18:17:44
3040debit_card30002018-03-28 09:05:11
3041credit_card30002018-03-28 09:44:24
3042debit_card15002018-03-28 12:39:17
3043credit_card34002018-03-29 09:21:59
3044debit_card51002018-03-29 09:37:54
3045credit_card8002018-03-29 10:01:54
3046debit_card8002018-03-29 10:22:00
3047credit_card34002018-03-30 11:11:46
3048debit_card30002018-03-30 15:23:24
3049credit_card75002018-03-30 22:08:08
3050debit_card51002018-03-31 08:50:26
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;