public.event
| Documentation | Tickit |
| Name | event |
| Module | Tickit diagram |
Each row represents a separate event that takes place at a specific venue at a specific time.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | eventid | integer | public.date | Primary key, a unique ID value for each row. Each row represents a separate event that takes place at a specific venue at a specific time. | ||||
| Primary key, a unique ID value for each row. Each row represents a separate event that takes place at a specific venue at a specific time. References: public.date |
||||||||
| 2 | venueid | smallint | public.venue | Foreign-key reference to the VENUE table. | ||||
| Foreign-key reference to the VENUE table. References: public.venue |
||||||||
| 3 | catid | smallint | public.category | Foreign-key reference to the CATEGORY table. | ||||
| Foreign-key reference to the CATEGORY table. References: public.category |
||||||||
| 4 | dateid | smallint | Foreign-key reference to the DATE table. | |||||
| Foreign-key reference to the DATE table. |
||||||||
| 5 | eventname | character varying(200) | Name of the event, such as Hamlet or La Traviata. | |||||
| Name of the event, such as Hamlet or La Traviata. |
||||||||
| 6 | starttime | timestamp without time zone | Full date and start time for the event, such as 2008-10-10 19:30:00. | |||||
| Full date and start time for the event, such as 2008-10-10 19:30:00. |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| public.event | public.category | public.event.catid = public.category.catid | fk_category_event | |
|
public.event.catid = public.category.catid Name: fk_category_event |
||||
| public.event | public.date | public.event.eventid = public.date.dateid | fk_date_event | |
|
public.event.eventid = public.date.dateid Name: fk_date_event |
||||
| public.event | public.venue | public.event.venueid = public.venue.venueid | fk_venue_event | |
|
public.event.venueid = public.venue.venueid Name: fk_venue_event |
||||
| public.listing | public.event | public.listing.eventid = public.event.eventid | fk_event_listing | |
|
public.listing.eventid = public.event.eventid Name: fk_event_listing |
||||
| public.sales | public.event | public.sales.eventid = public.event.eventid | fk_event_sales | |
|
public.sales.eventid = public.event.eventid Name: fk_event_sales |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| pk_event | eventid |
Uses
| Name |
|---|
|
public.event
|
Used by
| Name |
|---|
|
public.event
|
Exported: 2018-10-12 23:27, Last imported: 2018-10-01 10:44