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