public.venue
| Documentation | Tickit |
| Name | venue |
| Module | Tickit diagram |
Each row represents a specific venue where events take place.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | venueid | smallint | Primary key, a unique ID value for each row. Each row represents a specific venue where events take place. | |||||
| Primary key, a unique ID value for each row. Each row represents a specific venue where events take place. |
||||||||
| 2 | venuename | character varying(100) | Exact name of the venue, such as Cleveland Browns Stadium. | |||||
| Exact name of the venue, such as Cleveland Browns Stadium. |
||||||||
| 3 | venuecity | character varying(30) | City name, such as Cleveland. | |||||
| City name, such as Cleveland. |
||||||||
| 4 | venuestate | character(2) | Two-letter state or province abbreviation (United States and Canada), such as OH. | |||||
| Two-letter state or province abbreviation (United States and Canada), such as OH. |
||||||||
| 5 | venueseats | integer | Maximum number of seats available at the venue, if known, such as 73200. For demonstration purposes, this column contains some null values and zeroes. | |||||
| Maximum number of seats available at the venue, if known, such as 73200. For demonstration purposes, this column contains some null values and zeroes. |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| public.event | public.venue | public.event.venueid = public.venue.venueid | fk_venue_event | |
|
public.event.venueid = public.venue.venueid Name: fk_venue_event |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| pk_venue | venueid |
Used by
| Name |
|---|
|
public.venue
|
Exported: 2018-10-12 23:27, Last imported: 2018-10-01 10:44