Venue

• Engine: SQL (Django model / relational table)
• App: reference
• Table/Collection: reference_venue
• Verbose name: venue

Venue(created, last_edit_time, last_edit_by, is_dirty, id, slug, venue_type, location_text, is_demo, osm_way_id, wa_id, ngb_code, formal_name, nickname, english_name, local_name, region1, region2, region3, region4, street, country, latitude, longitude, altitude, verified, certification, floodlit, indoor, straight_only, length, num_lanes_curve, num_lanes_straight, water_jump, capacity)

Field	Type	Column/Key	Null/Default	PK	Choices	Notes
created	DateTimeField	created	null		—	—
last_edit_time	DateTimeField	last_edit_time	null		—	—
last_edit_by	CharField	last_edit_by	null		—	—
is_dirty	BooleanField	is_dirty	dflt=True		—	—
id	CharField	id	dflt=15e2534f-f38d-4eb3-939e-368ff94e753f	PK	—	—
slug	CharField	slug	—		—	—
venue_type	CharField	venue_type	dflt=TRACK		TRACK: Track; HQ: HeadQuarters; OFFICE: Office; TOWN: Town; ROAD: Road Race; XC: XC Course	—
location_text	CharField	location_text	—		—	—
is_demo	BooleanField	is_demo	dflt=False		—	Used for demo/training, hide on live site
osm_way_id	IntegerField	osm_way_id	null		—	—
wa_id	IntegerField	wa_id	null		—	—
ngb_code	CharField	ngb_code	—		—	—
formal_name	CharField	formal_name	—		—	Official Name of Track
nickname	CharField	nickname	—		—	Name athletes call the track
english_name	CharField	english_name	—		—	If location name is not English, it will be stored here
local_name	CharField	local_name	—		—	Local name
region1	CharField	region1	—		—	e.g. Wales, England
region2	CharField	region2	—		—	e.g. North, Midlands
region3	CharField	region3	—		—	e.g. County
region4	CharField	region4	—		—	e.g. Town
street	CharField	street	—		—	e.g. Iffley Road
country	ForeignKey → Country (FK)	country_id	null/dflt=GBR		—	—
latitude	FloatField	latitude	null		—	—
longitude	FloatField	longitude	null		—	—
altitude	FloatField	altitude	null		—	—
verified	BooleanField	verified	dflt=False		—	—
certification	CharField	certification	—		—	What can be hosted here?
floodlit	BooleanField	floodlit	dflt=False		—	—
indoor	BooleanField	indoor	dflt=False		—	—
straight_only	BooleanField	straight_only	dflt=False		—	—
length	PositiveSmallIntegerField	length	dflt=400		—	400 (in meters)
num_lanes_curve	PositiveSmallIntegerField	num_lanes_curve	null		—	2?
num_lanes_straight	PositiveSmallIntegerField	num_lanes_straight	null		—	2?
water_jump	CharField	water_jump	—		INSIDE: Inside; OUTSIDE: Outside	—
capacity	IntegerField	capacity	null		—	—

Field names link to their fuller explanation below.

Field details

Click a field name in the table above to jump to its explanation. Fields with no help text yet show a prompt, and are the ones to improve by adding a help_text on the model field, then regenerating.

created

• Engine: SQL
• Type: DateTimeField
• Column/Key: created
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

last_edit_time

• Engine: SQL
• Type: DateTimeField
• Column/Key: last_edit_time
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

last_edit_by

• Engine: SQL
• Type: CharField
• Column/Key: last_edit_by
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

is_dirty

• Engine: SQL
• Type: BooleanField
• Column/Key: is_dirty
• default = True

No help text yet — add a help_text on the model field and regenerate to fill this in.

id

• Engine: SQL
• Type: CharField
• Column/Key: id
• primary key; default = c7783cb9-32e1-4d66-99e7-c311863cf7f0

No help text yet — add a help_text on the model field and regenerate to fill this in.

slug

• Engine: SQL
• Type: CharField
• Column/Key: slug

No help text yet — add a help_text on the model field and regenerate to fill this in.

venue_type

• Engine: SQL
• Type: CharField
• Column/Key: venue_type
• default = TRACK; choices: TRACK: Track; HQ: HeadQuarters; OFFICE: Office; TOWN: Town; ROAD: Road Race; XC: XC Course

No help text yet — add a help_text on the model field and regenerate to fill this in.

location_text

• Engine: SQL
• Type: CharField
• Column/Key: location_text

No help text yet — add a help_text on the model field and regenerate to fill this in.

is_demo

• Engine: SQL
• Type: BooleanField
• Column/Key: is_demo
• default = False

Used for demo/training, hide on live site

osm_way_id

• Engine: SQL
• Type: IntegerField
• Column/Key: osm_way_id
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

wa_id

• Engine: SQL
• Type: IntegerField
• Column/Key: wa_id
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

ngb_code

• Engine: SQL
• Type: CharField
• Column/Key: ngb_code

No help text yet — add a help_text on the model field and regenerate to fill this in.

formal_name

• Engine: SQL
• Type: CharField
• Column/Key: formal_name

Official Name of Track

nickname

• Engine: SQL
• Type: CharField
• Column/Key: nickname

Name athletes call the track

english_name

• Engine: SQL
• Type: CharField
• Column/Key: english_name

If location name is not English, it will be stored here

local_name

• Engine: SQL
• Type: CharField
• Column/Key: local_name

Local name

region1

• Engine: SQL
• Type: CharField
• Column/Key: region1

e.g. Wales, England

region2

• Engine: SQL
• Type: CharField
• Column/Key: region2

e.g. North, Midlands

region3

• Engine: SQL
• Type: CharField
• Column/Key: region3

e.g. County

region4

• Engine: SQL
• Type: CharField
• Column/Key: region4

e.g. Town

street

• Engine: SQL
• Type: CharField
• Column/Key: street

e.g. Iffley Road

country

• Engine: SQL
• Type: ForeignKey → Country (FK)
• Column/Key: country_id
• nullable; default = GBR

No help text yet — add a help_text on the model field and regenerate to fill this in.

latitude

• Engine: SQL
• Type: FloatField
• Column/Key: latitude
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

longitude

• Engine: SQL
• Type: FloatField
• Column/Key: longitude
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

altitude

• Engine: SQL
• Type: FloatField
• Column/Key: altitude
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

verified

• Engine: SQL
• Type: BooleanField
• Column/Key: verified
• default = False

No help text yet — add a help_text on the model field and regenerate to fill this in.

certification

• Engine: SQL
• Type: CharField
• Column/Key: certification

What can be hosted here?

floodlit

• Engine: SQL
• Type: BooleanField
• Column/Key: floodlit
• default = False

No help text yet — add a help_text on the model field and regenerate to fill this in.

indoor

• Engine: SQL
• Type: BooleanField
• Column/Key: indoor
• default = False

No help text yet — add a help_text on the model field and regenerate to fill this in.

straight_only

• Engine: SQL
• Type: BooleanField
• Column/Key: straight_only
• default = False

No help text yet — add a help_text on the model field and regenerate to fill this in.

length

• Engine: SQL
• Type: PositiveSmallIntegerField
• Column/Key: length
• default = 400

400 (in meters)

num_lanes_curve

• Engine: SQL
• Type: PositiveSmallIntegerField
• Column/Key: num_lanes_curve
• nullable

2?

num_lanes_straight

• Engine: SQL
• Type: PositiveSmallIntegerField
• Column/Key: num_lanes_straight
• nullable

2?

water_jump

• Engine: SQL
• Type: CharField
• Column/Key: water_jump
• choices: INSIDE: Inside; OUTSIDE: Outside

No help text yet — add a help_text on the model field and regenerate to fill this in.

capacity

• Engine: SQL
• Type: IntegerField
• Column/Key: capacity
• nullable

No help text yet — add a help_text on the model field and regenerate to fill this in.

Generated by docs_models management command for SQL.