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,801–3,825 of 5,412

payment, page 153 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3801credit_card8002018-10-23 12:45:49
3802credit_card4002018-10-23 18:49:42
3803credit_card4002018-10-24 08:43:08
3804credit_card45002018-10-25 09:06:59
3805cash8002018-10-25 14:31:13
3806debit_card8002018-10-25 14:43:50
3807credit_card30002018-10-25 16:06:51
3808digital_wallet15002018-10-25 18:04:05
3809credit_card68002018-10-26 09:30:09
3810debit_card17002018-10-26 14:04:07
3811digital_wallet68002018-10-26 14:38:34
3812debit_card8002018-10-26 15:28:30
3813credit_card30002018-10-27 07:09:29
3814credit_card30002018-10-27 13:57:11
3815credit_card30002018-10-27 14:42:39
3816digital_wallet15002018-10-27 19:38:11
3817credit_card51002018-10-28 11:45:29
3818digital_wallet30002018-10-28 14:02:10
3819debit_card30002018-10-28 14:37:55
3820credit_card34002018-10-28 15:15:38
3821credit_card68002018-10-29 09:20:21
3822credit_card8002018-10-29 11:15:56
3823credit_card51002018-10-29 12:59:06
3824digital_wallet8002018-10-29 13:47:14
3825digital_wallet45002018-10-30 20:04:45
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;