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,251–4,275 of 5,412

payment, page 171 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4251debit_card4002019-03-30 08:03:44
4252credit_card8002019-03-30 10:04:40
4253credit_card30002019-03-30 14:36:51
4254credit_card68002019-03-30 14:48:22
4255credit_card4002019-03-30 20:36:14
4256cash34002019-03-31 09:30:17
4257digital_wallet8002019-03-31 10:07:12
4258credit_card4002019-03-31 19:28:57
4259debit_card60002019-04-01 19:07:13
4260cash8002019-04-02 10:15:41
4261credit_card4002019-04-02 14:35:57
4262credit_card30002019-04-02 20:15:02
4263credit_card615002019-04-03 09:19:19
4264credit_card30002019-04-03 09:35:23
4265digital_wallet45002019-04-03 15:46:16
4266credit_card8002019-04-03 16:05:33
4267debit_card4002019-04-03 23:29:15
4268debit_card4002019-04-04 01:37:29
4269digital_wallet8002019-04-04 12:05:13
4270digital_wallet15002019-04-04 12:18:07
4271credit_card15002019-04-04 14:12:18
4272credit_card45002019-04-04 14:45:01
4273debit_card4002019-04-04 17:31:02
4274credit_card45002019-04-04 18:13:42
4275digital_wallet30002019-04-04 22:09:44
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;