lookup_actions_p <------ I can't find it

[bears]

The player actions by street strings (like lookup_actions_p.action) consist of a series of characters to represent all of a player's actions on a single street.

It appears that there is supposed to be a table called lookup_actions_p containing a table called action

I can't find it using "pgAdmin III " only found the table lookup_actions

I also found id_action_p as a column within the table holdem_hand_player_detail

But that doesn't seem to be what this lookup_actions_p.action thing would be.

When I go the "insert" method it shows that as a Table Name. Why don't I see it with "pgAdmin III" ?

[kraada]

The lookup_actions_x "tables" are joins built on holdem_hand_player_detail.id_action_x and lookup_actions. The id_action_x field yields the id number of the action string taken and lookup_actions turns the id number into an actual action string. In order to simplify the process for the end user, lookup_actions_x was created which can be used in the creating of statistics as if it were a normal database table (even though it obviously is not).