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,901–3,925 of 5,412

payment, page 157 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3901cash34002018-11-24 09:43:35
3902digital_wallet8002018-11-24 10:27:22
3903credit_card45002018-11-24 15:43:21
3904credit_card75002018-11-25 18:58:59
3905credit_card4002018-11-26 01:46:00
3906credit_card4002018-11-26 07:32:54
3907credit_card34002018-11-26 10:23:14
3908cash8002018-11-26 10:59:57
3909cash68002018-11-26 11:38:47
3910credit_card8002018-11-26 12:27:57
3911digital_wallet30002018-11-26 13:01:17
3912debit_card15002018-11-26 22:40:25
3913credit_card45002018-11-27 13:13:48
3914debit_card15002018-11-27 17:11:14
3915debit_card15002018-11-27 17:45:33
3916credit_card4002018-11-28 04:28:31
3917credit_card8002018-11-28 11:11:03
3918debit_card15002018-11-28 14:24:19
3919credit_card8002018-11-29 10:32:11
3920debit_card45002018-11-29 13:25:13
3921debit_card4002018-11-29 14:59:21
3922credit_card30002018-11-29 17:05:41
3923debit_card30002018-11-29 17:11:30
3924cash8002018-11-30 09:26:17
3925credit_card34002018-11-30 12:34:12
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;