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,026–2,050 of 5,412

payment, page 82 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2026debit_card85002017-03-28 10:38:13
2027credit_card17002017-03-31 12:26:38
2028credit_card85002017-03-31 12:41:37
2029debit_card4002017-03-31 13:29:23
2030cash8002017-03-31 13:29:42
2031debit_card8002017-03-31 13:32:15
2032debit_card45002017-03-31 14:32:45
2033credit_card17002017-03-31 15:47:30
2034credit_card34002017-04-01 12:57:38
2035credit_card60002017-04-01 18:38:59
2036credit_card30002017-04-01 21:31:44
2037credit_card15002017-04-02 11:27:16
2038credit_card30002017-04-02 14:28:18
2039credit_card4002017-04-02 17:32:24
2040digital_wallet30002017-04-02 18:17:17
2041debit_card4002017-04-03 15:07:25
2042credit_card8002017-04-05 14:04:11
2043debit_card34002017-04-06 12:50:01
2044digital_wallet15002017-04-06 16:20:37
2045credit_card34002017-04-07 14:34:36
2046credit_card15002017-04-07 16:46:59
2047debit_card4002017-04-08 01:45:50
2048credit_card34002017-04-08 10:17:23
2049debit_card30002017-04-09 20:08:01
2050credit_card4002017-04-10 01:08:53
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;