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,101–2,125 of 5,412

payment, page 85 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2101credit_card85002017-04-24 09:01:45
2102cash8002017-04-24 09:28:21
2103credit_card8002017-04-24 09:30:43
2104cash8002017-04-24 09:31:16
2105debit_card17002017-04-24 12:37:52
2106credit_card15002017-04-24 18:25:41
2107debit_card15002017-04-25 21:02:18
2108credit_card4002017-04-26 06:18:16
2109credit_card4002017-04-26 13:00:27
2110credit_card15002017-04-27 12:15:14
2111credit_card34002017-04-28 09:36:48
2112credit_card15002017-04-28 17:25:02
2113debit_card15002017-04-28 22:24:41
2114debit_card75002017-04-28 22:40:48
2115credit_card68002017-04-29 09:03:40
2116credit_card8002017-04-29 09:34:58
2117cash8002017-04-29 12:37:04
2118digital_wallet8002017-04-29 12:41:17
2119debit_card4002017-04-29 18:42:15
2120credit_card34002017-04-30 12:17:53
2121credit_card8002017-04-30 12:36:07
2122credit_card45002017-04-30 12:38:04
2123debit_card30002017-04-30 20:47:30
2124debit_card15002017-04-30 20:50:23
2125debit_card4002017-05-02 06:02:14
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;