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 5,151–5,175 of 5,412

payment, page 207 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5151digital_wallet15002019-12-08 11:52:46
5152credit_card17002019-12-08 15:32:40
5153credit_card4002019-12-08 22:19:48
5154digital_wallet30002019-12-09 22:46:12
5155credit_card30002019-12-10 10:29:12
5156credit_card15002019-12-10 10:44:31
5157digital_wallet8002019-12-10 12:40:54
5158cash34002019-12-10 14:12:33
5159credit_card8002019-12-10 14:35:04
5160debit_card8002019-12-10 15:22:22
5161credit_card4002019-12-11 12:49:41
5162credit_card4002019-12-11 18:28:05
5163credit_card15002019-12-12 18:08:38
5164credit_card15002019-12-12 22:03:59
5165debit_card30002019-12-13 17:24:19
5166credit_card4002019-12-13 19:24:55
5167debit_card15002019-12-13 20:45:54
5168digital_wallet15002019-12-14 08:44:33
5169digital_wallet15002019-12-14 12:03:23
5170credit_card17002019-12-14 14:15:49
5171credit_card34002019-12-14 14:25:51
5172credit_card30002019-12-14 15:33:33
5173debit_card4002019-12-15 05:09:28
5174credit_card30002019-12-15 08:13:01
5175credit_card45002019-12-15 14:20:55
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;