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 4,976–5,000 of 5,412

payment, page 200 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4976debit_card15002019-10-20 10:22:33
4977debit_card15002019-10-20 14:26:18
4978credit_card30002019-10-21 09:06:10
4979debit_card15002019-10-21 16:03:26
4980credit_card4002019-10-21 19:06:33
4981credit_card8002019-10-22 11:51:37
4982debit_card30002019-10-22 18:13:30
4983digital_wallet30002019-10-22 20:45:00
4984debit_card4002019-10-23 03:10:59
4985credit_card30002019-10-23 08:22:18
4986credit_card4002019-10-23 11:44:57
4987cash17002019-10-23 13:39:19
4988credit_card15002019-10-23 20:28:27
4989credit_card4002019-10-24 08:23:44
4990debit_card30002019-10-24 15:23:34
4991credit_card4002019-10-24 20:51:58
4992credit_card8002019-10-25 09:54:46
4993digital_wallet15002019-10-25 13:13:59
4994digital_wallet30002019-10-25 15:03:45
4995credit_card8002019-10-26 10:45:01
4996cash8002019-10-26 11:49:26
4997debit_card8002019-10-26 15:07:17
4998credit_card4002019-10-27 01:36:15
4999cash34002019-10-27 14:38:44
5000debit_card30002019-10-27 17:02:33
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;