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,776–4,800 of 5,412

payment, page 192 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4776debit_card30002019-08-15 20:51:01
4777digital_wallet15002019-08-15 21:12:42
4778credit_card30002019-08-16 12:14:32
4779cash8002019-08-16 14:28:34
4780debit_card4002019-08-17 13:21:27
4781digital_wallet15002019-08-18 08:22:43
4782debit_card8002019-08-18 10:59:19
4783debit_card17002019-08-18 11:04:24
4784digital_wallet30002019-08-19 09:49:40
4785debit_card17002019-08-19 10:27:15
4786cash34002019-08-19 12:49:30
4787credit_card4002019-08-20 01:36:04
4788debit_card30002019-08-20 12:11:27
4789debit_card4002019-08-20 12:32:04
4790credit_card30002019-08-20 13:34:35
4791credit_card8002019-08-21 10:24:17
4792credit_card4002019-08-21 18:57:48
4793digital_wallet30002019-08-22 09:05:21
4794credit_card15002019-08-22 13:26:17
4795debit_card34002019-08-22 14:33:22
4796credit_card30002019-08-22 22:24:59
4797digital_wallet15002019-08-23 08:10:50
4798cash17002019-08-23 09:51:06
4799digital_wallet30002019-08-23 21:53:29
4800credit_card4002019-08-24 01:27:51
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;