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,076–3,100 of 5,412

payment, page 124 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3076digital_wallet15002018-04-06 09:08:12
3077credit_card4002018-04-06 09:12:55
3078digital_wallet15002018-04-06 11:16:58
3079credit_card4002018-04-06 11:22:20
3080digital_wallet15002018-04-06 12:31:40
3081credit_card17002018-04-07 11:19:17
3082credit_card8002018-04-07 11:52:23
3083cash34002018-04-08 09:59:03
3084debit_card8002018-04-08 12:18:17
3085debit_card75002018-04-08 22:30:26
3086debit_card15002018-04-09 12:14:51
3087cash51002018-04-09 14:57:02
3088credit_card8002018-04-09 15:33:54
3089debit_card4002018-04-10 02:26:02
3090debit_card4002018-04-10 04:14:01
3091cash51002018-04-10 11:09:12
3092cash8002018-04-10 11:55:35
3093digital_wallet17002018-04-10 15:01:14
3094debit_card60002018-04-10 23:18:48
3095credit_card15002018-04-11 08:13:48
3096credit_card60002018-04-11 15:12:20
3097credit_card45002018-04-11 22:27:39
3098debit_card51002018-04-12 10:47:07
3099credit_card4002018-04-12 11:04:07
3100debit_card8002018-04-12 11:08:08
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;