migrated_and_current_ticket_sales

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ticket_id

int4

10

√

null

ticket_sales.ticket_id

Implied Constraint

R

Ticket id as it exists in PBJ

customer_encoded_id

text

2147483647

√

null

dim_draw_id

int4

10

√

null

dim_draw.dim_draw_id

Implied Constraint

R

See table dim_draw

lottery_names

text

2147483647

√

null

Lotteries this sale applies to

lottery_type_name

text

2147483647

√

null

Type of lottery this sale applies to (e.g. Raffle)

game_offer_names

text

2147483647

√

null

Game offers this sale applies to

sales

numeric

15,5

√

null

Total cost of the ticket

ticket_timestamp

timestamptz

35,6

√

null

When this ticket was last updated

Relationships

Close relationships within degrees of separation

View Definition

SELECT ticket_sales.ticket_id,
    customer.customer_encoded_id,
    ticket_sales.dim_draw_id,
    ticket_sales.lottery_names,
    ticket_sales.lottery_type_name,
    ticket_sales.game_offer_names,
    ticket_sales.sales,
    latest.ticket_status_history_timestamp AS ticket_timestamp
   FROM ((ticket_sales
     JOIN customer USING (customer_id))
     JOIN ( SELECT ticket_status_history.ticket_id,
            ticket_status_history.ticket_status_history_timestamp,
            ticket_status_history.ticket_status_id,
            rank() OVER (PARTITION BY ticket_status_history.ticket_id ORDER BY ticket_status_history.ticket_status_history_timestamp DESC) AS rank
           FROM ticket_status_history) latest USING (ticket_id))
  WHERE (latest.rank = 1)
UNION
 SELECT migrated_ticket_sales.migrated_ticket_id AS ticket_id,
    migrated_ticket_sales.customer_encoded_id,
    migrated_ticket_sales.dim_draw_id,
    migrated_ticket_sales.lottery_names,
    migrated_ticket_sales.lottery_type_name,
    migrated_ticket_sales.game_offer_names,
    migrated_ticket_sales.sales,
    migrated_ticket_sales.migrated_ticket_timestamp AS ticket_timestamp
   FROM migrated_ticket_sales;

migrated_and_current_ticket_sales

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views