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 5,351–5,375 of 5,412

payment, page 215 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5351debit_card51002020-02-02 16:06:26
5352cash8002020-02-02 16:41:01
5353cash8002020-02-02 16:45:44
5354debit_card4002020-02-03 11:30:09
5355credit_card51002020-02-04 08:46:56
5356debit_card8002020-02-04 09:18:06
5357debit_card8002020-02-04 09:18:09
5358credit_card60002020-02-04 22:38:16
5359digital_wallet15002020-02-05 13:23:38
5360credit_card15002020-02-05 21:15:29
5361cash34002020-02-06 08:28:02
5362credit_card30002020-02-06 09:51:49
5363debit_card4002020-02-06 13:28:51
5364digital_wallet30002020-02-06 22:06:26
5365credit_card4002020-02-06 23:05:56
5366digital_wallet8002020-02-07 13:36:43
5367digital_wallet15002020-02-08 08:00:50
5368digital_wallet34002020-02-08 09:51:42
5369debit_card30002020-02-08 15:36:01
5370debit_card15002020-02-09 07:43:17
5371debit_card15002020-02-09 08:39:28
5372digital_wallet34002020-02-09 14:11:29
5373credit_card30002020-02-09 14:33:41
5374credit_card4002020-02-10 03:57:39
5375credit_card45002020-02-10 08:29:10
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;