iNNOVup

Tables (4)

Untitled (cal_CMGR)

  • Key2 (Key) — NN — Primary key — NOT NULL
  • Field (GMCR) — NN
  • Key (new in Nov) — NN — NOT NULL
  • Key2 (left in Nov) — NN — NOT NULL

Untitled (CMGR)

  • Field6 (key) — NN — Primary key
  • Field (company_id) — NN — Primary key
  • Field2 (address) — NN
  • Field3 (industry code) — NN
  • Field4 (new employees in Nov) — NN
  • Field5 (left employees in Nov) — NN
  • Key (company) — NN — NOT NULL

Untitled (MoM)

  • Key — NN — Primary key — NOT NULL
  • Field (data created date) — NN
  • Field2 (company) — NN
  • Field3 (company_id) — NN
  • Field4 (industry_id) — NN
  • Field5 (new) — NN
  • Field6 (loss) — NN
  • Field7 (avg_mom_sal) — NN
  • Field (avg_yr_sal) — NN
  • Field (MoM) — NN
  • Field

alldata.csv

  • 사업자번호 (company id) — NN — Primary key
  • 사업장명 (company name) — NN — Primary key
  • 도로명주소 (address) — NN
  • 업종코드명 (industry code) — NN
  • 가입자수 (num of subscribers) — NN
  • 신규 (new) — NN
  • 상실 (loss) — NN
  • Field2 (average annual salary) — NN
  • Field (average montly salary) — NN
  • 자료생성년월 (data created date) — NN — NOT NULL
  • Field6 (key) — NN — Foreign key → Untitled.Field6
  • Field (company_id) — NN — Foreign key → Untitled.Field
  • Key — NN — Foreign key → Untitled.Key — NOT NULL