test

Tables (6)

annual_vehicle_registrations (Untitled)

  • year (연도) — int — Primary key — NOT NULL
  • official (관용) — int — NOT NULL
  • private (자가용) — int — NOT NULL
  • commercial (영업용) — int — NOT NULL

company (Untitled5)

  • company_id (기업 아이디) — int — Primary key — NOT NULL
  • company_logo (기업 로고) — blob — NOT NULL
  • company_name (기업 명) — varchar — NOT NULL

company_faq (Untitled4)

  • question_id (질문 아이디) — int — Primary key — NOT NULL
  • company_id (기업 아이디) — int — Foreign key → company.company_id — NOT NULL
  • question (질문) — varchar — NOT NULL
  • answer (대답) — varchar — NOT NULL

company_vehicle (Untitled2)

  • id (아이디) — int — Primary key — NOT NULL
  • company_id (기업 아이디) — int — Foreign key → company.company_id — NOT NULL
  • sales_volume (판매량) — int — NOT NULL
  • company_share (기업별 점유율) — decimal — NOT NULL
  • company_month_over_month (기업별 전월대비) — decimal — NOT NULL
  • company_date (기업별 테이블 날짜) — date — NOT NULL

model (Untitled6)

  • model_id (모델 아이디) — int — Primary key — NOT NULL
  • model_img (모델 사진) — blob — NOT NULL
  • model_name (모델 명) — varchar — NOT NULL

model_vehicle (Untitled3)

  • id (아이디) — int — Primary key — NOT NULL
  • company_id (기업 아이디) — int — Foreign key → company.company_id — NOT NULL
  • model_id (모델 아이디) — int — Foreign key → model.model_id — NOT NULL
  • sales_volume (판매량) — int — NOT NULL
  • model_share (모델별 점유율) — decimal — NOT NULL
  • model_month_over_month (모델별 전월대비) — decimal — NOT NULL
  • model_date (모델별 테이블 날짜) — date — NOT NULL