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 3,651–3,675 of 5,412

payment, page 147 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3651credit_card900002018-09-10 08:15:48
3652credit_card15002018-09-10 08:53:27
3653credit_card30002018-09-10 19:57:00
3654debit_card34002018-09-11 11:27:54
3655credit_card30002018-09-11 17:45:05
3656credit_card15002018-09-12 08:12:51
3657cash17002018-09-12 09:43:14
3658credit_card45002018-09-12 10:59:21
3659credit_card8002018-09-12 11:42:57
3660credit_card45002018-09-12 14:16:56
3661digital_wallet30002018-09-12 23:42:48
3662digital_wallet30002018-09-13 10:43:19
3663credit_card8002018-09-14 10:20:46
3664debit_card68002018-09-14 10:28:27
3665digital_wallet8002018-09-14 11:11:44
3666digital_wallet30002018-09-14 17:29:48
3667credit_card4002018-09-15 01:08:53
3668credit_card15002018-09-15 08:25:25
3669debit_card34002018-09-15 10:39:23
3670cash51002018-09-16 11:39:40
3671digital_wallet30002018-09-16 12:17:42
3672credit_card8002018-09-16 12:18:25
3673credit_card34002018-09-16 14:52:58
3674debit_card17002018-09-17 09:41:00
3675debit_card68002018-09-17 10:59:35
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;