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,401–3,425 of 5,412

payment, page 137 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3401cash17002018-07-05 12:33:31
3402digital_wallet8002018-07-05 13:19:38
3403credit_card4002018-07-06 15:00:01
3404credit_card4002018-07-06 16:11:06
3405credit_card4002018-07-06 19:17:30
3406debit_card45002018-07-06 19:56:30
3407credit_card60002018-07-07 07:19:24
3408cash8002018-07-07 09:13:30
3409debit_card30002018-07-07 11:40:17
3410credit_card15002018-07-07 14:34:51
3411digital_wallet8002018-07-08 10:42:45
3412debit_card15002018-07-09 07:34:20
3413cash34002018-07-09 13:43:31
3414debit_card8002018-07-09 14:13:24
3415cash17002018-07-10 10:27:51
3416debit_card34002018-07-10 11:41:44
3417digital_wallet45002018-07-10 14:38:16
3418cash17002018-07-11 10:13:26
3419credit_card60002018-07-11 14:11:24
3420credit_card17002018-07-12 10:09:09
3421cash85002018-07-12 11:28:59
3422credit_card8002018-07-12 11:48:35
3423credit_card4002018-07-12 16:07:44
3424digital_wallet15002018-07-12 16:56:52
3425credit_card4002018-07-12 17:55:54
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;