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,176–5,200 of 5,412

payment, page 208 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5176credit_card8002019-12-15 15:19:52
5177credit_card30002019-12-15 20:32:00
5178debit_card4002019-12-16 00:14:57
5179credit_card30002019-12-16 11:08:58
5180credit_card30002019-12-16 12:52:32
5181digital_wallet15002019-12-16 23:42:01
5182credit_card4002019-12-17 02:12:53
5183digital_wallet15002019-12-17 07:56:58
5184credit_card4002019-12-17 09:36:28
5185digital_wallet8002019-12-17 10:38:49
5186debit_card60002019-12-17 12:14:46
5187cash8002019-12-17 13:41:58
5188debit_card15002019-12-18 07:30:35
5189cash34002019-12-18 10:56:59
5190digital_wallet15002019-12-18 11:11:19
5191credit_card15002019-12-18 19:27:47
5192debit_card30002019-12-18 20:31:02
5193debit_card15002019-12-18 22:18:19
5194credit_card8002019-12-19 14:30:27
5195digital_wallet30002019-12-19 14:52:36
5196credit_card30002019-12-19 18:51:34
5197debit_card30002019-12-20 07:33:10
5198credit_card15002019-12-20 08:17:32
5199credit_card15002019-12-21 10:24:13
5200credit_card8002019-12-21 10:33:23
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;