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 4,926–4,950 of 5,412

payment, page 198 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4926credit_card30002019-10-05 13:26:17
4927credit_card30002019-10-06 07:27:42
4928credit_card34002019-10-06 12:46:30
4929credit_card15002019-10-06 18:52:50
4930credit_card8002019-10-07 09:41:26
4931credit_card30002019-10-08 07:10:44
4932digital_wallet75002019-10-08 09:48:50
4933digital_wallet8002019-10-08 11:16:53
4934debit_card8002019-10-08 11:18:38
4935credit_card30002019-10-08 12:52:42
4936credit_card30002019-10-08 15:49:54
4937credit_card60002019-10-08 18:10:40
4938credit_card30002019-10-08 20:20:13
4939credit_card4002019-10-08 22:35:49
4940credit_card17002019-10-09 09:30:29
4941debit_card15002019-10-10 14:41:03
4942digital_wallet30002019-10-10 19:30:39
4943digital_wallet30002019-10-11 07:00:59
4944credit_card8002019-10-11 10:44:14
4945debit_card8002019-10-11 10:52:46
4946credit_card30002019-10-11 22:08:46
4947debit_card4002019-10-12 01:24:55
4948digital_wallet15002019-10-12 14:21:47
4949debit_card4002019-10-13 02:52:06
4950credit_card15002019-10-13 09:12:42
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;