car_stats

Tables (4)

Car_City (시도별자동차등록현황)

  • Year — YEAR — Primary key — NOT NULL
  • CityID (도시ID) — INT — Foreign key → City.CityID — NOT NULL
  • CarCount (시도/연도별 자동차등록현황(단위:만대)) — INT

City (도시)

  • CityID (도시ID) — INT — Primary key — NOT NULL
  • CityName (도시명) — VARCHAR(10)

FAQ_Company (FAQ기업)

  • CompanyID (회사ID) — INT — Primary key — NOT NULL
  • CompanyName (회사이름) — VARCHAR(10)

FAQ_Question (FAQ질문답변)

  • QuestionID (질문ID) — INT — Primary key — NOT NULL
  • QuestionTitle (질문) — VARCHAR(500)
  • QuestionAnswer (답변) — VARCHAR(2000)
  • CompanyID (회사ID) — INT — Foreign key → FAQ_Company.CompanyID — NOT NULL