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,301–4,325 of 5,412

payment, page 173 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4301credit_card8002019-04-12 13:37:52
4302credit_card75002019-04-12 15:04:10
4303digital_wallet15002019-04-12 20:39:20
4304debit_card60002019-04-13 09:33:49
4305credit_card8002019-04-13 10:35:50
4306credit_card30002019-04-13 12:00:13
4307digital_wallet60002019-04-13 12:51:32
4308digital_wallet60002019-04-14 08:39:03
4309credit_card34002019-04-14 09:37:12
4310credit_card8002019-04-14 10:47:46
4311debit_card68002019-04-14 13:12:10
4312digital_wallet17002019-04-15 09:39:12
4313debit_card45002019-04-15 11:16:55
4314debit_card4002019-04-15 11:51:50
4315credit_card4002019-04-15 13:15:51
4316debit_card15002019-04-15 15:15:57
4317debit_card15002019-04-15 15:37:54
4318credit_card4002019-04-16 00:29:31
4319credit_card34002019-04-16 08:53:02
4320cash8002019-04-16 09:33:55
4321credit_card15002019-04-16 23:06:19
4322credit_card17002019-04-17 10:30:28
4323credit_card17002019-04-17 14:59:23
4324credit_card30002019-04-17 20:00:35
4325debit_card45002019-04-18 09:35: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;