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,501–3,525 of 5,412

payment, page 141 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3501credit_card17002018-08-02 10:35:26
3502credit_card15002018-08-02 11:18:51
3503credit_card34002018-08-02 11:26:49
3504cash17002018-08-02 11:34:05
3505debit_card30002018-08-02 15:33:11
3506debit_card8002018-08-02 16:11:51
3507credit_card15002018-08-02 23:51:07
3508cash68002018-08-03 11:04:19
3509debit_card8002018-08-03 11:28:58
3510credit_card60002018-08-03 12:28:33
3511debit_card30002018-08-03 23:14:36
3512credit_card4002018-08-04 05:16:05
3513credit_card15002018-08-04 07:07:28
3514credit_card495002018-08-04 12:12:08
3515cash68002018-08-04 13:04:21
3516credit_card8002018-08-04 13:26:09
3517cash8002018-08-04 13:31:45
3518debit_card34002018-08-04 16:27:28
3519credit_card8002018-08-04 17:12:22
3520debit_card8002018-08-04 17:13:11
3521credit_card17002018-08-05 10:56:35
3522cash68002018-08-05 12:38:19
3523cash8002018-08-05 13:14:22
3524credit_card4002018-08-05 17:54:07
3525credit_card15002018-08-06 08:14:28
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;