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,001–5,025 of 5,412

payment, page 201 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5001credit_card75002019-10-27 20:11:46
5002digital_wallet30002019-10-28 07:31:05
5003credit_card30002019-10-28 09:47:51
5004debit_card17002019-10-28 11:09:56
5005credit_card30002019-10-28 13:10:42
5006credit_card17002019-10-28 13:53:58
5007debit_card8002019-10-28 14:03:56
5008debit_card4002019-10-29 02:50:53
5009credit_card30002019-10-29 08:14:02
5010digital_wallet15002019-10-29 08:42:42
5011digital_wallet34002019-10-29 11:18:42
5012cash68002019-10-29 14:50:29
5013credit_card34002019-10-29 16:36:06
5014credit_card8002019-10-29 17:05:20
5015credit_card4002019-10-30 23:11:36
5016debit_card4002019-10-31 06:11:14
5017credit_card30002019-10-31 12:58:57
5018debit_card15002019-10-31 17:54:10
5019debit_card4002019-11-01 06:56:45
5020debit_card30002019-11-02 07:13:39
5021debit_card17002019-11-02 11:11:21
5022credit_card30002019-11-02 21:21:45
5023digital_wallet15002019-11-03 10:43:33
5024credit_card30002019-11-03 18:50:22
5025digital_wallet30002019-11-03 19:11:05
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;