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 801–825 of 5,412

payment, page 33 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
801cash34002015-11-17 15:37:37
802debit_card8002015-11-17 16:06:31
803debit_card30002015-11-17 17:39:28
804debit_card15002015-11-17 19:43:54
805debit_card8002015-11-18 10:12:02
806cash8002015-11-18 10:24:08
807credit_card4002015-11-19 04:42:05
808cash8002015-11-19 13:27:49
809credit_card4002015-11-20 00:08:37
810credit_card600002015-11-20 18:18:35
811credit_card15002015-11-21 09:49:02
812credit_card17002015-11-21 10:53:11
813credit_card45002015-11-21 13:12:26
814cash8002015-11-21 13:17:25
815debit_card17002015-11-21 14:32:53
816cash17002015-11-22 08:58:45
817credit_card8002015-11-22 15:10:03
818credit_card51002015-11-24 11:29:21
819debit_card8002015-11-24 12:07:10
820credit_card30002015-11-24 13:18:07
821credit_card8002015-11-24 14:13:52
822credit_card15002015-11-26 10:42:28
823credit_card34002015-11-26 14:11:00
824credit_card68002015-11-27 09:46:55
825credit_card34002015-11-27 15:04:18
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;