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,426–3,450 of 5,412

payment, page 138 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3426debit_card4002018-07-12 20:24:46
3427digital_wallet15002018-07-12 21:22:41
3428credit_card15002018-07-13 13:06:36
3429credit_card45002018-07-13 16:53:02
3430credit_card30002018-07-14 09:46:19
3431credit_card34002018-07-14 10:35:25
3432cash8002018-07-14 10:54:48
3433debit_card8002018-07-14 11:05:21
3434credit_card15002018-07-14 11:37:49
3435debit_card15002018-07-15 07:40:55
3436credit_card17002018-07-15 11:04:04
3437debit_card8002018-07-15 11:25:45
3438cash34002018-07-15 11:36:08
3439digital_wallet51002018-07-15 13:48:45
3440credit_card75002018-07-15 14:22:15
3441digital_wallet15002018-07-16 10:23:12
3442credit_card60002018-07-16 13:22:32
3443cash51002018-07-17 08:49:24
3444debit_card4002018-07-17 09:14:45
3445debit_card60002018-07-17 11:52:09
3446digital_wallet17002018-07-17 14:08:33
3447cash68002018-07-17 14:08:38
3448digital_wallet8002018-07-17 14:31:11
3449cash8002018-07-17 14:37:45
3450digital_wallet68002018-07-18 09:30:01
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;