f1

Tables (19)

CIRCUIT

  • circuit_id — INTEGER — Primary key — NOT NULL

CONSTRUCTO

  • constructor_id — INTEGER — Primary key — NOT NULL
  • name
  • full_name
  • color_rgb
  • team_chief
  • base
  • engine_manufacturer
  • world_championships
  • first_team_entry
  • technical_chief
  • f1_car_image_url
  • constructor_logo_url
  • constructor_normalized_logo_url

CONSTRUCTOR

  • constructor_id — INTEGER — Primary key — NOT NULL
  • Field
  • year — INTEGER — Foreign key → SEASON.year — NOT NULL
  • team_id — Foreign key → TEAM.team_id — NOT NULL

CONSTRUCTOR_RESULT

  • point
  • year — INTEGER — Foreign key → SEASON.year — NOT NULL
  • grandprix_id — INTEGER — Foreign key → GRANDPRIX.grandprix_id — NOT NULL
  • session_id — INTEGER — Foreign key → SESSION.session_id — NOT NULL
  • constructor_id — INTEGER — Foreign key → CONSTRUCTOR.constructor_id — NOT NULL
  • wins
  • total_point
  • total_position

DRIVER

  • driver_id — INTEGER — Primary key — NOT NULL

DRIVER_RESULT

  • session_id — INTEGER — Foreign key → SESSION.session_id — NOT NULL
  • driver_season_id — INTEGER — Foreign key → DRIVER_SEASON.driver_season_id — NOT NULL
  • year — INTEGER — Foreign key → SEASON.year — NOT NULL
  • grandprix_id — INTEGER — Foreign key → GRANDPRIX.grandprix_id — NOT NULL
  • point
  • position
  • total_point
  • total_position
  • grid
  • status — "RTIRED"

DRIVER_SEASON

  • driver_season_id — INTEGER — Primary key — NOT NULL
  • racing_number
  • constructor_id — INTEGER — Foreign key → CONSTRUCTOR.constructor_id — NOT NULL
  • year — INTEGER — Foreign key → SEASON.year — NOT NULL
  • driver_id — INTEGER — Foreign key → DRIVER.driver_id — NOT NULL

FIA_DOCS

  • grandprix_id — INTEGER — Foreign key → GRANDPRIX.grandprix_id — NOT NULL

GRANDPRIX

  • grandprix_id — INTEGER — Primary key — NOT NULL
  • circuit_id — INTEGER — Foreign key → CIRCUIT.circuit_id — NOT NULL
  • year — INTEGER — Foreign key → SEASON.year — NOT NULL
  • round

LAP

  • lap_id — BIGINT — Primary key — NOT NULL
  • lap_number
  • time
  • is_pit
  • st_speed
  • pitstop_id — Foreign key → PIT_STOP.pitstop_id — NOT NULL
  • session_id — INTEGER — Foreign key → DRIVER_RESULT.session_id — NOT NULL
  • driver_season_id — INTEGER — Foreign key → DRIVER_RESULT.driver_season_id — NOT NULL
  • position (Field)

NEWS

  • news_id — INTEGER — Primary key — NOT NULL
  • title — VARCHAR2(256)
  • title_kr — VARCHAR2(256)
  • summary — VARCHAR2(512)
  • summary_kr — VARCHAR2(512)
  • cover_url — VARCHAR2(512)
  • link — VARCHAR2(512)
  • published_at — DATETIME
  • created_at — DATETIME
  • news_source_id — INTEGER — Foreign key → NEWS_SOURCE.news_source_id — NOT NULL

NEWS_SOURCE

  • news_source_id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR2(56)
  • logo_url — VARCHAR2(128)

NEWS_TYPE

  • news_type_id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR2(32)
  • name_kr — VARCHAR2(32)

PIT_STOP (Untitled)

  • pitstop_id — Primary key — NOT NULL
  • duration

SEASON

  • year — INTEGER — Primary key — NOT NULL

SEASON_INFO

  • constructor_id — INTEGER — Foreign key → CONSTRUCTO.constructor_id — NOT NULL
  • car
  • full_name
  • color_rgb
  • team_chief
  • base
  • engine_manufacturer
  • world_championships
  • technical_chief
  • f1_car_image_url
  • constructor_logo_url
  • constructor_normalized_logo_url

SESSION

  • session_id — INTEGER — Primary key — NOT NULL
  • year — INTEGER — Foreign key → SEASON.year — NOT NULL
  • grandprix_id — INTEGER — Foreign key → GRANDPRIX.grandprix_id — NOT NULL

TEAM

  • team_id — Primary key — NOT NULL

_NEWS_NEWS_TYPE

  • news_id — INTEGER — Foreign key → NEWS.news_id — NOT NULL
  • news_type_id — INTEGER — Foreign key → NEWS_TYPE.news_type_id — NOT NULL