By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
gift_certificate_id | name | description | price | create_date | last_update_date | duration |
---|---|---|---|---|---|---|
9 | pizza_certificate | 50% discount for 5 pizzas | 10.50 | 2020-01-18 15:53:21 | 2020-01-18 15:53:21 | 4 |
11 | ninja_sushi_certificate | every second sushi is free | 3.00 | 2020-01-18 15:58:24 | 2020-01-18 15:58:24 | 2 |
12 | salad | every salad 25% discount | 2.00 | 2020-01-18 15:59:14 | 2020-01-19 18:49:53 | 1 |
13 | kfc_delivery_ceritificate | free delivery over 10$ | 2.50 | 2020-01-18 16:00:52 | 2020-01-18 16:00:52 | 10 |
47 | certificate_for_rent_car | car rent xml description | 3.55 | 2020-01-20 21:36:26 | 2020-01-25 12:59:08 | 3 |
tag_id | name |
---|---|
6 | pizza |
8 | certificate |
9 | car |
12 | sushi |
13 | food |
14 | delivery |
15 | salad |
16 | kfc |
21 | tasty |
53 | rent |
tag_id | gift_certificate_id |
---|---|
6 | 9 |
8 | 9 |
12 | 11 |
13 | 11 |
14 | 11 |
13 | 12 |
14 | 12 |
15 | 12 |
21 | 12 |
13 | 13 |
14 | 13 |
16 | 13 |
9 | 47 |
53 | 47 |
gift_certificate_id | name | description | price | create_date | last_update_date | duration | tags |
---|---|---|---|---|---|---|---|
13 | kfc_delivery_ceritificate | free delivery over 10$ | 2.50 | 2020-01-18 16:00:52 | 2020-01-18 16:00:52 | 10 | delivery,food,kfc |