couponcodes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"couponcodes_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_couponcodes_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

coupon int4 10 null
coupons.ID FK_couponcodes_coupon C
transaction int4 10 null
transactions.ID FK_couponcodes_transaction N
flag int2 5 0
date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

code text 2147483647 null
value float8 17,17 0
datefrom int8 19 null

Unix timestamp in seconds

dateto int8 19 null

Unix timestamp in seconds

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_couponcodes_ID Primary key Asc ID

Relationships