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

payment, page 162 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4026debit_card17002019-01-04 14:15:27
4027credit_card34002019-01-05 08:57:32
4028credit_card30002019-01-05 11:36:44
4029digital_wallet60002019-01-06 11:26:18
4030debit_card17002019-01-06 12:23:07
4031debit_card17002019-01-06 13:39:21
4032credit_card15002019-01-06 21:18:19
4033digital_wallet8002019-01-08 15:31:19
4034credit_card34002019-01-09 10:02:13
4035debit_card8002019-01-09 10:14:13
4036cash8002019-01-09 13:09:17
4037credit_card8002019-01-09 13:15:52
4038debit_card4002019-01-10 10:01:27
4039debit_card15002019-01-10 13:55:47
4040credit_card30002019-01-11 23:09:27
4041cash17002019-01-12 09:58:13
4042credit_card34002019-01-12 10:37:15
4043credit_card15002019-01-13 23:22:40
4044credit_card825002019-01-14 10:53:13
4045debit_card34002019-01-14 13:36:03
4046credit_card30002019-01-15 17:31:49
4047credit_card4002019-01-16 01:47:17
4048digital_wallet15002019-01-16 11:41:08
4049debit_card4002019-01-17 05:44:13
4050digital_wallet30002019-01-18 07:03:26
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;