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,226–3,250 of 5,412

payment, page 130 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3226credit_card8002018-05-17 11:21:07
3227credit_card8002018-05-17 11:32:55
3228credit_card17002018-05-17 13:26:38
3229debit_card30002018-05-17 13:34:38
3230digital_wallet30002018-05-17 16:56:34
3231debit_card4002018-05-17 22:59:02
3232debit_card8002018-05-18 10:43:25
3233cash8002018-05-18 10:43:44
3234credit_card8002018-05-18 10:45:06
3235credit_card8002018-05-18 10:49:02
3236credit_card30002018-05-18 13:47:28
3237debit_card4002018-05-18 17:02:59
3238credit_card30002018-05-18 18:49:36
3239credit_card4002018-05-19 09:11:43
3240cash17002018-05-19 10:31:46
3241digital_wallet17002018-05-19 14:36:31
3242credit_card8002018-05-19 15:26:44
3243debit_card8002018-05-19 16:06:11
3244digital_wallet60002018-05-19 17:20:00
3245credit_card30002018-05-19 17:47:19
3246credit_card4002018-05-20 11:26:20
3247credit_card4002018-05-20 22:31:40
3248debit_card8002018-05-21 13:21:57
3249debit_card15002018-05-21 15:45:24
3250digital_wallet8002018-05-22 11:05:27
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;