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