| ID |
int8 |
19 |
|
√ |
null |
|
|
Coupon code ID |
| creator |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_couponcodes_creator N
|
|
Creator user ID (defaults to authenticated user on creation) |
| creationdate |
int8 |
19 |
|
|
date_part('epoch'::text, now()) |
|
|
Creation date and time as a Unix time stamp (defaults to current date and time on creation) |
| lastmodified |
int8 |
19 |
|
|
date_part('epoch'::text, now()) |
|
|
Last modification date and time as a Unix time stamp (auto-reset on modification) |
| coupon |
int4 |
10 |
|
|
null |
|
|
Coupon ID (**dependency**) |
| transaction |
int4 |
10 |
√ |
|
null |
|
|
Transaction ID |
| flag |
int2 |
5 |
|
|
0 |
|
|
Flag (0=BOOKED, 1=RESERVED, 2=CANCELLED) |
| date |
int8 |
19 |
|
|
date_part('epoch'::text, now()) |
|
|
Designated date and time as a Unix time stamp (defaults to current date and time on creation) |
| code |
text |
2147483647 |
|
|
null |
|
|
Coupon code |
| value |
float8 |
17,17 |
|
|
0 |
|
|
Value |
| datefrom |
int8 |
19 |
√ |
|
null |
|
|
Start date and time as a Unix time stamp; must be less than or equal to dateto |
| dateto |
int8 |
19 |
√ |
|
null |
|
|
End date and time as a Unix time stamp; must be greater than or equal to datefrom |
