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

payment, page 91 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
2251credit_card17002017-06-14 11:43:07
2252debit_card15002017-06-14 15:20:06
2253debit_card4002017-06-14 19:08:49
2254credit_card8002017-06-15 12:42:46
2255cash34002017-06-16 11:19:06
2256cash17002017-06-16 11:24:21
2257debit_card34002017-06-16 11:27:12
2258debit_card8002017-06-16 11:42:19
2259credit_card8002017-06-16 12:01:50
2260debit_card8002017-06-16 12:10:24
2261credit_card30002017-06-17 07:48:10
2262credit_card15002017-06-17 07:53:28
2263credit_card15002017-06-17 08:13:07
2264debit_card15002017-06-17 10:38:35
2265credit_card4002017-06-17 11:35:40
2266digital_wallet30002017-06-17 18:32:40
2267credit_card15002017-06-18 17:12:31
2268credit_card15002017-06-19 08:03:43
2269cash8002017-06-19 10:14:35
2270debit_card17002017-06-19 10:25:55
2271credit_card34002017-06-19 12:16:15
2272credit_card51002017-06-21 09:55:28
2273credit_card8002017-06-21 10:22:27
2274credit_card17002017-06-21 10:32:29
2275credit_card8002017-06-21 10:33: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;