contact_companyPanel2024
테이블 (5)
리스트 테이블 (contact_companyPanel2024)
- 리스트ID (listID) — varchar(100) — 기본 키 — NOT NULL
- Field (center) — varchar(20)
- Field2 (interviewer1) — varchar(10)
- Field3 (interviewer2) — varchar(10)
- Field (group1info1) — varchar(200)
- Field2 (group1info2) — varchar(200)
- Field3 (group1info3) — varchar(200)
- Field4 (group1info4) — varchar(200)
- Field5 (group1info5) — varchar(200)
- Field6 (group1info6) — varchar(200)
- Field7 (group1info7) — varchar(200)
- Field8 (group1info8) — varchar(200)
- Field9 (group1info9) — varchar(200)
- Field10 (group1info10) — varchar(200)
- Field11 (group2info1) — varchar(200)
- Field12 (group2info2) — varchar(200)
- Field13 (group2info3) — varchar(200)
- Field14 (group2info4) — varchar(200)
- Field (group2info5) — varchar(200)
- Field2 (group2info6) — varchar(200)
- Field3 (group2info7) — varchar(200)
- Field4 (group2info8) — varchar(200)
- Field5 (group2info9) — varchar(200)
- Field6 (group2info10) — varchar(200)
- Field7 (group3info1) — varchar(200)
- Field8 (group3info2) — varchar(200)
- Field9 (group3info3) — varchar(200)
- Field10 (group3info4) — varchar(200)
- Field11 (group3info5) — varchar(200)
- Field15 (group3info6) — varchar(200)
- Field16 (group3info7) — varchar(200)
- Field17 (group3info8) — varchar(200)
- Field18 (group3info9) — varchar(200)
- Field19 (group3info10) — varchar(200)
- Field20 (group4info1) — varchar(200)
- Field21 (group4info2) — varchar(200)
- Field22 (group4info3) — varchar(200)
- Field23 (group4info4) — varchar(200)
- Field24 (group4info5) — varchar(200)
- Field25 (group4info6) — varchar(200)
- Field26 (group4info7) — varchar(200)
- Field27 (group4info8) — varchar(200)
- Field28 (group4info9) — varchar(200)
- Field29 (group4info10) — varchar(200)
- Field30 (group5info1) — varchar(200)
- Field31 (group5info2) — varchar(200)
- Field32 (group5info3) — varchar(200)
- Field33 (group5info4) — varchar(200)
- Field34 (group5info5) — varchar(200)
- Field35 (group5info6) — varchar(200)
- Field36 (group5info7) — varchar(200)
- Field37 (group5info8) — varchar(200)
- Field38 (group5info9) — varchar(200)
- Field39 (group5info10) — varchar(200)
사용자 (contact_companyPanel2024_member)
- Key (ID) — varchar(20) — 기본 키 — NOT NULL — 이름 + 전화번호 뒷자리
- Field (name) — varchar(10) — NOT NULL — 이름
- Field (phone) — varchar(20) — NOT NULL — 전화번호
- Field (password) — varchar(4) — NOT NULL — 비밀번호 숫자 4자리
- Field (type) — varchar(20) — NOT NULL — 총괄SV,지방SV, 전화면접원, 방문면접원
- Field (center) — varchar(20) — NOT NULL — 권역(센터)
상태값 코드 (contact_companyPanel2024_statusCode)
- Key (idx) — int — 기본 키 — NOT NULL
- Field (groupName) — varchar(20) — NOT NULL — 어떤 그룹에 들어가는 상태코드인지
- Key (status) — int — NOT NULL
- Field (statusName) — varchar(100) — NOT NULL
- Field (type) — int — NOT NULL — 화면에 노출할지, 클릭이 가능하게 할지 여부 확인
정보변경내역 (contact_companyPanel2024_changeHistory)
- Key (idx) — int — 기본 키 — NOT NULL
- Field3 (listID) — varchar(100) — NOT NULL
- Field (groupName) — varchar(20) — NOT NULL
- Field (beforeValue) — varchar(200) — NOT NULL — 김진욱/IT팀/사원
- Field2 (afterValue) — varchar(200) — NOT NULL — 이인혜/DP팀/차장
- Field (changeWho) — varchar(10) — NOT NULL
- Field (changeDate) — datetime — NOT NULL
컨택내역 (contact_companyPanel2024_contactHistory)
- Key (idx) — int — 기본 키 — NOT NULL
- Field (listID) — varchar(100) — NOT NULL
- Field2 (groupName) — varchar(20) — NOT NULL
- Field3 (status) — int — NOT NULL
- Field (memo) — varchar(200)
- Field4 (insertWho) — varchar(10) — NOT NULL
- Field (insertDate) — datetime — NOT NULL