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 2,526–2,550 of 5,412

payment, page 102 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2526debit_card8002017-09-03 09:48:24
2527credit_card30002017-09-03 18:39:01
2528credit_card51002017-09-04 16:14:32
2529debit_card60002017-09-05 07:07:44
2530debit_card4002017-09-06 03:31:36
2531debit_card17002017-09-06 11:26:02
2532debit_card51002017-09-06 13:26:45
2533cash8002017-09-06 13:50:05
2534credit_card8002017-09-06 15:40:35
2535credit_card15002017-09-07 08:39:34
2536debit_card75002017-09-07 12:29:55
2537digital_wallet51002017-09-07 15:52:24
2538cash8002017-09-07 16:38:31
2539credit_card17002017-09-08 11:07:31
2540debit_card30002017-09-09 17:52:10
2541credit_card8002017-09-10 11:33:25
2542credit_card30002017-09-10 18:42:39
2543credit_card51002017-09-11 10:33:41
2544credit_card8002017-09-11 11:03:13
2545debit_card17002017-09-11 15:44:59
2546debit_card30002017-09-11 15:50:13
2547credit_card60002017-09-11 16:49:05
2548credit_card60002017-09-12 21:43:47
2549cash85002017-09-13 10:22:03
2550debit_card8002017-09-13 10:29:05
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;