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,476–4,500 of 5,412

payment, page 180 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4476credit_card30002019-05-31 19:25:19
4477debit_card30002019-05-31 23:31:50
4478credit_card30002019-06-01 17:01:44
4479credit_card4002019-06-01 23:59:08
4480digital_wallet30002019-06-02 08:51:02
4481credit_card15002019-06-03 11:06:13
4482debit_card30002019-06-03 13:58:04
4483credit_card30002019-06-03 21:28:38
4484credit_card30002019-06-04 09:18:27
4485debit_card17002019-06-04 11:09:37
4486debit_card8002019-06-04 11:41:51
4487credit_card4002019-06-04 13:00:24
4488digital_wallet30002019-06-05 10:11:48
4489credit_card30002019-06-06 10:19:03
4490credit_card8002019-06-06 11:22:00
4491credit_card4002019-06-07 04:24:35
4492credit_card15002019-06-07 07:01:12
4493credit_card30002019-06-07 09:27:24
4494digital_wallet30002019-06-07 12:42:05
4495credit_card17002019-06-08 10:12:42
4496credit_card34002019-06-08 10:48:17
4497credit_card17002019-06-08 14:12:30
4498debit_card8002019-06-08 16:00:48
4499credit_card8002019-06-08 16:23:28
4500credit_card4002019-06-09 06:09:03
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;