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