40 lines
1.1 KiB
YAML
40 lines
1.1 KiB
YAML
# Read about fixtures at https://api.rubyonrails.org/classes/ActiveRecord/FixtureSet.html
|
|
|
|
# == Schema Information
|
|
#
|
|
# Table name: completions
|
|
#
|
|
# id :integer not null, primary key
|
|
# display_relative_time :string
|
|
# display_time_from_start :string
|
|
# time_seconds :integer
|
|
# created_at :datetime not null
|
|
# updated_at :datetime not null
|
|
# contest_id :integer not null
|
|
# contestant_id :integer not null
|
|
# puzzle_id :integer not null
|
|
#
|
|
# Indexes
|
|
#
|
|
# index_completions_on_contest_id (contest_id)
|
|
# index_completions_on_contestant_id (contestant_id)
|
|
# index_completions_on_puzzle_id (puzzle_id)
|
|
#
|
|
# Foreign Keys
|
|
#
|
|
# contest_id (contest_id => contests.id)
|
|
# contestant_id (contestant_id => contestants.id)
|
|
# puzzle_id (puzzle_id => puzzles.id)
|
|
#
|
|
completion_one:
|
|
time_seconds: 1
|
|
contestant: team_one
|
|
puzzle: puzzle_one
|
|
contest: team_contest
|
|
|
|
completion_two:
|
|
time_seconds: 2
|
|
contestant: solo_one
|
|
puzzle: puzzle_two
|
|
contest: solo_contest
|