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,501–2,525 of 5,412

payment, page 101 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2501credit_card17002017-08-26 13:47:59
2502credit_card51002017-08-26 15:25:22
2503credit_card75002017-08-27 08:02:12
2504credit_card45002017-08-27 10:31:45
2505credit_card85002017-08-27 11:54:37
2506digital_wallet17002017-08-27 15:03:32
2507debit_card8002017-08-27 16:13:46
2508cash8002017-08-27 16:23:04
2509credit_card4002017-08-27 17:12:56
2510digital_wallet30002017-08-28 07:15:06
2511digital_wallet15002017-08-28 10:00:28
2512cash8002017-08-28 11:56:59
2513cash8002017-08-28 11:57:46
2514credit_card15002017-08-29 16:27:09
2515debit_card15002017-08-29 17:40:01
2516cash17002017-08-30 09:24:00
2517debit_card8002017-08-30 09:59:57
2518credit_card4002017-08-30 16:54:32
2519credit_card60002017-08-30 23:33:17
2520debit_card15002017-08-31 19:18:36
2521credit_card8002017-09-01 10:38:20
2522credit_card30002017-09-01 14:00:04
2523credit_card45002017-09-01 20:11:33
2524credit_card4002017-09-02 03:12:23
2525credit_card45002017-09-02 16:04: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;