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,626–4,650 of 5,412

payment, page 186 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4626credit_card75002019-07-11 17:06:43
4627digital_wallet45002019-07-11 20:07:52
4628cash68002019-07-12 13:16:16
4629credit_card8002019-07-12 13:44:02
4630digital_wallet45002019-07-12 14:11:46
4631digital_wallet15002019-07-12 15:40:37
4632credit_card4002019-07-12 17:36:55
4633credit_card8002019-07-13 09:53:26
4634debit_card30002019-07-13 10:24:10
4635credit_card8002019-07-13 12:19:47
4636debit_card8002019-07-13 14:27:17
4637debit_card30002019-07-14 09:43:08
4638cash34002019-07-14 09:51:44
4639credit_card8002019-07-14 11:11:49
4640credit_card34002019-07-14 14:51:32
4641debit_card8002019-07-14 15:21:51
4642debit_card4002019-07-14 19:25:09
4643debit_card15002019-07-14 23:35:47
4644credit_card17002019-07-15 09:33:32
4645credit_card8002019-07-16 09:54:31
4646cash8002019-07-16 11:28:45
4647debit_card4002019-07-16 18:51:10
4648credit_card17002019-07-18 11:49:04
4649debit_card4002019-07-18 20:32:45
4650credit_card60002019-07-18 23:30: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;