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 1,076–1,100 of 5,412

payment, page 44 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1076debit_card15002016-03-20 19:05:47
1077debit_card34002016-03-21 14:53:33
1078debit_card8002016-03-21 15:01:10
1079debit_card8002016-03-21 15:02:01
1080debit_card8002016-03-21 15:17:57
1081debit_card8002016-03-21 15:37:47
1082debit_card8002016-03-21 15:39:47
1083credit_card17002016-03-22 10:06:55
1084debit_card15002016-03-22 20:24:16
1085credit_card4002016-03-23 03:23:51
1086digital_wallet15002016-03-24 09:03:21
1087credit_card75002016-03-24 13:28:01
1088cash34002016-03-25 12:07:09
1089credit_card4002016-03-25 19:07:27
1090credit_card75002016-03-25 20:16:44
1091credit_card15002016-03-25 22:19:43
1092cash34002016-03-26 09:39:59
1093credit_card34002016-03-26 10:00:14
1094debit_card4002016-03-27 02:28:27
1095credit_card75002016-03-28 08:24:39
1096debit_card8002016-03-28 11:13:50
1097credit_card17002016-03-28 11:30:42
1098debit_card4002016-03-28 13:30:07
1099debit_card17002016-03-28 14:51:12
1100debit_card60002016-03-28 22:32:50
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;