public.listing
| Documentation | Tickit |
| Name | listing |
| Module | Tickit diagram |
Each row represents a listing of a batch of tickets for a specific event.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | listid | integer | public.sales | Primary key, a unique ID value for each row. Each row represents a listing of a batch of tickets for a specific event. | ||||
| Primary key, a unique ID value for each row. Each row represents a listing of a batch of tickets for a specific event. References: public.sales |
||||||||
| 2 | sellerid | integer | public.users | Foreign-key reference to the USERS table, identifying the user who is selling the tickets. | ||||
| Foreign-key reference to the USERS table, identifying the user who is selling the tickets. References: public.users |
||||||||
| 3 | eventid | integer | public.event | Foreign-key reference to the EVENT table. | ||||
| Foreign-key reference to the EVENT table. References: public.event |
||||||||
| 4 | dateid | smallint | public.date | Foreign-key reference to the DATE table. | ||||
| Foreign-key reference to the DATE table. References: public.date |
||||||||
| 5 | numtickets | smallint | The number of tickets available for sale, such as 2 or 20. | |||||
| The number of tickets available for sale, such as 2 or 20. |
||||||||
| 6 | priceperticket | numeric | The fixed price of an individual ticket, such as 27.00 or 206.00. | |||||
| The fixed price of an individual ticket, such as 27.00 or 206.00. |
||||||||
| 7 | totalprice | numeric | The total price for this listing (NUMTICKETS*PRICEPERTICKET). | |||||
| The total price for this listing (NUMTICKETS*PRICEPERTICKET). |
||||||||
| 8 | listtime | timestamp without time zone | The full date and time when the listing was posted, such as 2008-03-18 07:19:35. | |||||
| The full date and time when the listing was posted, such as 2008-03-18 07:19:35. |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| public.listing | public.date | public.listing.dateid = public.date.dateid | fk_date_listing | |
|
public.listing.dateid = public.date.dateid Name: fk_date_listing |
||||
| public.listing | public.event | public.listing.eventid = public.event.eventid | fk_event_listing | |
|
public.listing.eventid = public.event.eventid Name: fk_event_listing |
||||
| public.listing | public.sales | public.listing.listid = public.sales.listid | fk_listing_sales | |
|
public.listing.listid = public.sales.listid Name: fk_listing_sales |
||||
| public.listing | public.users | public.listing.sellerid = public.users.userid | fk_users_listing | |
|
public.listing.sellerid = public.users.userid Name: fk_users_listing |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| pk_listing | listid |
Uses
| Name |
|---|
|
public.listing
|
Exported: 2018-10-12 23:27, Last imported: 2018-10-01 10:44