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,101–4,125 of 5,412

payment, page 165 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4101debit_card45002019-02-08 11:54:24
4102credit_card15002019-02-08 15:22:56
4103credit_card60002019-02-09 12:20:12
4104credit_card51002019-02-09 14:16:34
4105credit_card4002019-02-09 16:03:04
4106credit_card45002019-02-09 19:21:15
4107credit_card15002019-02-09 19:30:39
4108digital_wallet75002019-02-10 07:34:05
4109credit_card30002019-02-10 07:55:51
4110digital_wallet60002019-02-10 19:00:14
4111credit_card30002019-02-10 20:59:09
4112credit_card34002019-02-11 09:49:51
4113debit_card15002019-02-11 13:26:24
4114credit_card51002019-02-12 10:26:08
4115digital_wallet8002019-02-12 11:15:46
4116credit_card34002019-02-12 13:03:57
4117credit_card34002019-02-12 14:06:14
4118cash8002019-02-12 14:49:43
4119debit_card60002019-02-13 08:42:37
4120cash17002019-02-13 11:11:08
4121debit_card8002019-02-14 10:47:31
4122credit_card15002019-02-14 22:25:17
4123cash8002019-02-15 15:31:53
4124debit_card8002019-02-15 15:36:21
4125debit_card75002019-02-16 08:19:57
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;