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 3,851–3,875 of 5,412

payment, page 155 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3851credit_card30002018-11-09 13:08:25
3852debit_card15002018-11-10 07:34:05
3853debit_card17002018-11-10 10:20:53
3854credit_card34002018-11-11 08:45:23
3855debit_card30002018-11-11 08:52:12
3856cash17002018-11-11 12:11:26
3857credit_card8002018-11-11 12:25:14
3858credit_card60002018-11-12 10:11:40
3859credit_card4002018-11-12 15:56:53
3860debit_card15002018-11-12 16:35:57
3861credit_card60002018-11-13 10:54:49
3862debit_card17002018-11-13 11:21:13
3863digital_wallet85002018-11-13 13:56:51
3864cash8002018-11-13 14:29:25
3865debit_card60002018-11-13 16:18:25
3866digital_wallet15002018-11-13 18:24:33
3867debit_card15002018-11-14 12:30:21
3868credit_card34002018-11-15 11:16:48
3869credit_card17002018-11-15 11:16:58
3870credit_card15002018-11-15 14:06:23
3871credit_card51002018-11-16 10:27:41
3872debit_card8002018-11-16 11:21:21
3873debit_card15002018-11-16 16:31:10
3874credit_card17002018-11-17 10:42:29
3875credit_card8002018-11-18 09:45:58
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;