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