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 901–925 of 5,412

payment, page 37 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
901credit_card30002015-12-22 11:45:12
902credit_card4002015-12-22 12:17:48
903credit_card17002015-12-22 14:55:10
904cash8002015-12-22 15:42:06
905credit_card4002015-12-23 04:47:33
906debit_card85002015-12-23 08:32:41
907credit_card30002015-12-23 17:04:09
908credit_card15002015-12-23 20:53:56
909debit_card4002015-12-23 23:12:51
910debit_card4002015-12-24 16:23:49
911digital_wallet15002015-12-24 21:53:03
912credit_card4002015-12-26 06:18:11
913debit_card17002015-12-26 08:58:00
914credit_card15002015-12-26 09:50:03
915debit_card68002015-12-26 12:17:58
916debit_card34002015-12-27 10:28:49
917credit_card17002015-12-27 10:59:36
918cash8002015-12-27 11:40:29
919digital_wallet75002015-12-27 12:42:38
920cash34002015-12-28 12:17:07
921debit_card15002015-12-28 13:52:56
922debit_card17002015-12-29 10:31:32
923credit_card4002015-12-29 23:25:23
924debit_card34002015-12-30 15:07:33
925credit_card34002015-12-30 16:19:21
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;