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

payment, page 205 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5101digital_wallet75002019-11-21 22:26:40
5102credit_card75002019-11-22 07:38:28
5103credit_card68002019-11-22 11:53:39
5104credit_card8002019-11-22 15:09:03
5105credit_card30002019-11-23 09:13:25
5106credit_card51002019-11-23 09:41:35
5107credit_card4002019-11-23 11:48:44
5108credit_card30002019-11-23 18:24:25
5109credit_card60002019-11-24 23:59:22
5110digital_wallet8002019-11-25 10:20:28
5111credit_card30002019-11-25 12:53:04
5112debit_card30002019-11-25 19:03:55
5113credit_card8002019-11-26 10:51:43
5114digital_wallet15002019-11-27 11:52:26
5115credit_card15002019-11-27 14:45:41
5116credit_card68002019-11-28 09:03:37
5117debit_card8002019-11-28 09:42:43
5118credit_card8002019-11-29 12:54:46
5119credit_card51002019-11-30 09:52:52
5120credit_card4002019-11-30 13:18:24
5121digital_wallet17002019-11-30 16:41:54
5122digital_wallet45002019-11-30 17:09:11
5123credit_card30002019-11-30 19:39:34
5124credit_card15002019-12-01 09:36:44
5125credit_card15002019-12-01 16:07:55
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;