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,051–5,075 of 5,412

payment, page 203 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5051credit_card15002019-11-10 22:36:40
5052credit_card4002019-11-11 03:30:59
5053digital_wallet51002019-11-11 08:57:57
5054digital_wallet85002019-11-11 09:12:08
5055credit_card8002019-11-11 09:37:04
5056digital_wallet8002019-11-11 09:49:29
5057credit_card8002019-11-11 09:49:39
5058credit_card30002019-11-11 14:47:19
5059credit_card15002019-11-11 18:31:34
5060cash17002019-11-12 10:01:49
5061credit_card30002019-11-12 20:03:03
5062debit_card30002019-11-12 22:05:35
5063credit_card8002019-11-13 10:16:35
5064debit_card34002019-11-13 11:20:57
5065cash8002019-11-13 11:59:23
5066credit_card4002019-11-13 16:04:21
5067credit_card15002019-11-13 17:41:45
5068digital_wallet8002019-11-14 10:01:09
5069credit_card60002019-11-14 13:37:43
5070digital_wallet30002019-11-14 19:27:00
5071digital_wallet30002019-11-15 10:27:16
5072digital_wallet15002019-11-15 11:20:59
5073cash17002019-11-15 15:16:26
5074credit_card15002019-11-15 16:48:58
5075debit_card4002019-11-16 06:26:19
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;