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

payment, page 32 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
776credit_card30002015-11-07 10:37:23
777credit_card4002015-11-07 22:55:52
778credit_card15002015-11-09 09:47:58
779credit_card34002015-11-09 15:09:38
780credit_card8002015-11-09 15:54:50
781credit_card45002015-11-09 19:08:18
782cash8002015-11-10 14:03:14
783credit_card15002015-11-10 15:39:04
784credit_card60002015-11-12 08:25:14
785credit_card60002015-11-12 08:34:47
786credit_card15002015-11-12 10:40:45
787credit_card85002015-11-12 11:18:48
788cash17002015-11-12 14:23:01
789credit_card4002015-11-13 16:41:17
790debit_card17002015-11-14 09:07:05
791credit_card8002015-11-14 09:36:07
792credit_card34002015-11-14 10:08:49
793cash8002015-11-14 10:43:40
794credit_card30002015-11-14 12:29:49
795cash17002015-11-14 13:00:23
796debit_card8002015-11-14 13:34:43
797debit_card4002015-11-14 17:41:54
798credit_card30002015-11-15 20:11:15
799debit_card15002015-11-15 20:46:07
800credit_card4002015-11-16 06:58: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;