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 876–900 of 5,412

payment, page 36 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
876credit_card30002015-12-14 11:38:57
877credit_card15002015-12-14 23:20:29
878credit_card68002015-12-15 10:09:39
879cash8002015-12-15 11:03:28
880credit_card15002015-12-15 20:37:52
881credit_card4002015-12-16 02:50:05
882credit_card45002015-12-16 12:29:07
883debit_card68002015-12-18 09:30:41
884debit_card17002015-12-18 13:09:22
885debit_card30002015-12-18 15:19:25
886debit_card8002015-12-18 16:37:03
887cash17002015-12-19 09:33:51
888cash34002015-12-19 14:21:52
889cash34002015-12-19 15:19:15
890debit_card8002015-12-19 15:48:56
891digital_wallet30002015-12-19 20:17:01
892debit_card4002015-12-19 22:31:25
893credit_card4002015-12-20 06:32:02
894credit_card30002015-12-20 08:50:29
895credit_card15002015-12-20 15:10:53
896cash51002015-12-21 12:20:40
897debit_card68002015-12-21 14:36:01
898credit_card15002015-12-22 07:33:11
899cash34002015-12-22 10:01:52
900credit_card30002015-12-22 11:21:41
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;