AIBC

테이블 (15)

기본스캔 (Scan_B)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • 카테고리01 A ~ E (A)
  • (B)
  • (C)
  • (D)
  • (E)
  • 카테고리02 MK-1 ~ MK-4 (MK-1)
  • (MK-2)
  • (MK-3)
  • (MK-4)
  • 카테고리03 (DT-1-NAME)
  • (DT-1-1)
  • (DT-1-2)
  • (DT-1-3)
  • (DT-1-4)
  • (DT-1-5)
  • (DT-1-TEXT)
  • (DT-2-NAME)
  • (DT-2-1)
  • (DT-2-2)
  • (DT-2-3)
  • (DT-2-4)
  • (DT-2-5)
  • (DT-2-TEXT)
  • 파일 (FILE_NAME)

기본포커스 답변 (focus_a)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • 질문 유형 (QUESTION_TYPE) — NOT NULL
  • (1-1)
  • (1-2)
  • (1-3)
  • (1-4)
  • (2-1)
  • (2-2)
  • (2-3)
  • (2-4)
  • (2-5)
  • (2-6)
  • (2-7)
  • (2-8)
  • (3-1)
  • (3-2)
  • (3-3)
  • (3-4)
  • (4-1)
  • (4-2)
  • 첨부파일 (F_1_1)
  • (F_1_2)
  • (F_1_3)
  • (F_1_4)
  • (F_2_1)
  • (F_2_2)
  • (F_2_3)
  • (F_2_4)
  • (F_2_5)
  • (F_2_6)
  • (F_2_7)
  • (F_2_8)
  • (F_3_1)
  • (F_3_2)
  • (F_3_3)
  • (F_3_4)
  • (F_4_1)
  • (F_4_2)

리포트 (Scan_R)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • (AS-1-1)
  • (AS-1-2)
  • (AS-1-3)
  • (AS-1-4)
  • (AS-2-1)
  • (AS-2-2)
  • (AS-2-3)
  • (AS-2-4)
  • (AS-3-1)
  • (AS-3-2)
  • (AS-3-3)
  • (AS-3-4)
  • (AS-4-1)
  • (AS-4-2)
  • (AS-4-3)
  • (AS-4-4)
  • (AS-5-1)
  • (AS-5-2)
  • (AS-5-3)
  • (AS-5-4)
  • (AS-6-1)
  • (AS-6-2)
  • (KW-1-1)
  • (KW-1-2)
  • (KW-1-3)
  • (KW-1-4)
  • (KW-2-1)
  • (KW-2-2)
  • (KW-2-3)
  • (KW-2-4)
  • (KW-3-1)
  • (KW-3-2)
  • (KW-3-3)
  • (KW-3-4)
  • (KW-4-1)
  • (KW-4-2)
  • (KW-4-3)
  • (KW-4-4)
  • (KW-5-1)
  • (KW-5-2)
  • (KW-5-3)
  • (KW-5-4)
  • (KW-6-1)
  • (KW-6-2)
  • 첨부파일 (FILE_NAME)

리포트 (focus_r)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • (AS-1-1)
  • (AS-1-2)
  • (AS-1-3)
  • (AS-1-4)
  • (AS-2-1)
  • (AS-2-2)
  • (AS-2-3)
  • (AS-2-4)
  • (AS_2_5)
  • (AS_2_6)
  • (AS_2_7)
  • (AS_2_8)
  • (AS-3-1)
  • (AS-3-2)
  • (AS-3-3)
  • (AS-3-4)
  • (AS-4-1)
  • (AS-4-2)
  • (KW-1-1)
  • (KW-1-2)
  • (KW-1-3)
  • (KW-1-4)
  • (KW-2-1)
  • (KW-2-2)
  • (KW-2-3)
  • (KW-2-4)
  • (KW-2-5)
  • (KW-2-6)
  • (KW-2-7)
  • (KW-2-8)
  • (KW-3-1)
  • (KW-3-2)
  • (KW-3-3)
  • (KW-3-4)
  • (KW-4-1)
  • (KW-4-2)
  • 첨부파일 (FILE_NAME)

상태 (State)

  • 상태 아이디 (STATE_ID) — 기본 키 — NOT NULL
  • 상태 이름 (STATE_NAME) — NOT NULL

세부스캔 II 답변 (Scan_D_A2)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • (1-1-1)
  • (1-1-2)
  • (1-1-3)
  • (1-1-4)
  • (1-1-5)
  • (1-2-1)
  • (1-2-2)
  • (1-2-3)
  • (1-2-4)
  • (1-2-5)
  • (1-3-1)
  • (1-3-2)
  • (1-3-3)
  • (1-3-4)
  • (1-3-5)
  • (1-4-1)
  • (1-4-2)
  • (1-4-3)
  • (1-4-4)
  • (1-4-5)
  • (2-1-1)
  • (2-1-2)
  • (2-1-3)
  • (2-1-4)
  • (2-1-5)
  • (2-2-1)
  • (2-2-2)
  • (2-2-3)
  • (2-2-4)
  • (2-2-5)
  • (2-3-1)
  • (2-3-2)
  • (2-3-3)
  • (2-3-4)
  • (2-3-5)
  • (2-4-1)
  • (2-4-2)
  • (2-4-3)
  • (2-4-4)
  • (2-4-5)
  • (3-1-1)
  • (3-1-2)
  • (3-1-3)
  • (3-1-4)
  • (3-1-5)
  • (3-2-1)
  • (3-2-2)
  • (3-2-3)
  • (3-2-4)
  • (3-2-5)
  • (3-3-1)
  • (3-3-2)
  • (3-3-3)
  • (3-3-4)
  • (3-3-5)
  • (3-4-1)
  • (3-4-2)
  • (3-4-3)
  • (3-4-4)
  • … +41

세부스캔 II 질문 (Scan_D_Q2)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • (1-1-1)
  • (1-1-2)
  • (1-1-3)
  • (1-1-4)
  • (1-1-5)
  • (1-2-1)
  • (1-2-2)
  • (1-2-3)
  • (1-2-4)
  • (1-2-5)
  • (1-3-1)
  • (1-3-2)
  • (1-3-3)
  • (1-3-4)
  • (1-3-5)
  • (1-4-1)
  • (1-4-2)
  • (1-4-3)
  • (1-4-4)
  • (1-4-5)
  • (2-1-1)
  • (2-1-2)
  • (2-1-3)
  • (2-1-4)
  • (2-1-5)
  • (2-2-1)
  • (2-2-2)
  • (2-2-3)
  • (2-2-4)
  • (2-2-5)
  • (2-3-1)
  • (2-3-2)
  • (2-3-3)
  • (2-3-4)
  • (2-3-5)
  • (2-4-1)
  • (2-4-2)
  • (2-4-3)
  • (2-4-4)
  • (2-4-5)
  • (3-1-1)
  • (3-1-2)
  • (3-1-3)
  • (3-1-4)
  • (3-1-5)
  • (3-2-1)
  • (3-2-2)
  • (3-2-3)
  • (3-2-4)
  • (3-2-5)
  • (3-3-1)
  • (3-3-2)
  • (3-3-3)
  • (3-3-4)
  • (3-3-5)
  • (3-4-1)
  • (3-4-2)
  • (3-4-3)
  • (3-4-4)
  • … +41

세부스캔 답변 (Scan_D_A)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • (1-1)
  • (1-2)
  • (1-3)
  • (1-4)
  • (2-1)
  • (2-2)
  • (2-3)
  • (2-4)
  • (3-1)
  • (3-2)
  • (3-3)
  • (3-4)
  • (4-1)
  • (4-2)
  • (4-3)
  • (4-4)
  • (5-1)
  • (5-2)
  • (5-3)
  • (5-4)
  • (6-1)
  • (6-2)
  • 첨부파일 (F-1-1)
  • (F-1-2)
  • (F-1-3)
  • (F-1-4)
  • (F-2-1)
  • (F-2-2)
  • (F-2-3)
  • (F-2-4)
  • (F-3-1)
  • (F-3-2)
  • (F-3-3)
  • (F-3-4)
  • (F-4-1)
  • (F-4-2)
  • (F-4-3)
  • (F-4-4)
  • (F-5-1)
  • (F-5-2)
  • (F-5-3)
  • (F-5-4)
  • (F-6-1)
  • (F-6-2)

세부스캔 질문 (Scan_D_Q)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • (1-1)
  • (1-2)
  • (1-3)
  • (1-4)
  • (2-1)
  • (2-2)
  • (2-3)
  • (2-4)
  • (3-1)
  • (3-2)
  • (3-3)
  • (3-4)
  • (4-1)
  • (4-2)
  • (4-3)
  • (4-4)
  • (5-1)
  • (5-2)
  • (5-3)
  • (5-4)

스캔_고객 (Scan_All_Client)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • 제출일시 (CREATED_DATE) — NOT NULL
  • 폰트 굵기 (FONT_BOLD) — INT — NOT NULL
  • 상태 아이디 (STATE_ID) — 외래 키 → 상태.상태 아이디 — NOT NULL

스캔_컨설턴트 (Scan_All_Consultant)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • 제출일시 (CREATED_DATE) — NOT NULL
  • 폰트 굵기 (FONT_BOLD) — INT — NOT NULL
  • 상태 아이디 (STATE_ID) — 외래 키 → 상태.상태 아이디 — NOT NULL

추가포커스 답변 (focus_a2)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • (1-1-1)
  • (1-1-2)
  • (1-1-3)
  • (1-1-4)
  • (1-1-5)
  • (1-2-1)
  • (1-2-2)
  • (1-2-3)
  • (1-2-4)
  • (1-2-5)
  • (1-3-1)
  • (1-3-2)
  • (1-3-3)
  • (1-3-4)
  • (1-3-5)
  • (1-4-1)
  • (1-4-2)
  • (1-4-3)
  • (1-4-4)
  • (1-4-5)
  • (2-1-1)
  • (2-1-2)
  • (2-1-3)
  • (2-1-4)
  • (2-1-5)
  • (2-2-1)
  • (2-2-2)
  • (2-2-3)
  • (2-2-4)
  • (2-2-5)
  • (2-3-1)
  • (2-3-2)
  • (2-3-3)
  • (2-3-4)
  • (2-3-5)
  • (2-4-1)
  • (2-4-2)
  • (2-4-3)
  • (2-4-4)
  • (2-4-5)
  • (2-5-1)
  • (2-5-2)
  • (2-5-3)
  • (2-5-4)
  • (2-5-5)
  • (2-6-1)
  • (2-6-2)
  • (2-6-3)
  • (2-6-4)
  • (2-6-5)
  • (2-7-1)
  • (2-7-2)
  • (2-7-3)
  • (2-7-4)
  • (2-7-5)
  • (2-8-1)
  • (2-8-2)
  • (2-8-3)
  • (2-8-4)
  • … +31

추가포커스 질문 (focus_q2)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • (1-1-1)
  • (1-1-2)
  • (1-1-3)
  • (1-1-4)
  • (1-1-5)
  • (1-2-1)
  • (1-2-2)
  • (1-2-3)
  • (1-2-4)
  • (1-2-5)
  • (1-3-1)
  • (1-3-2)
  • (1-3-3)
  • (1-3-4)
  • (1-3-5)
  • (1-4-1)
  • (1-4-2)
  • (1-4-3)
  • (1-4-4)
  • (1-4-5)
  • (2-1-1)
  • (2-1-2)
  • (2-1-3)
  • (2-1-4)
  • (2-1-5)
  • (2-2-1)
  • (2-2-2)
  • (2-2-3)
  • (2-2-4)
  • (2-2-5)
  • (2-3-1)
  • (2-3-2)
  • (2-3-3)
  • (2-3-4)
  • (2-3-5)
  • (2-4-1)
  • (2-4-2)
  • (2-4-3)
  • (2-4-4)
  • (2-4-5)
  • (2-5-1)
  • (2-5-2)
  • (2-5-3)
  • (2-5-4)
  • (2-5-5)
  • (2-6-1)
  • (2-6-2)
  • (2-6-3)
  • (2-6-4)
  • (2-6-5)
  • (2-7-1)
  • (2-7-2)
  • (2-7-3)
  • (2-7-4)
  • (2-7-5)
  • (2-8-1)
  • (2-8-2)
  • (2-8-3)
  • (2-8-4)
  • … +31

포커스_고객 (focus_all_client)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • 제출일시 (CREATED_DATE) — NOT NULL
  • 폰트 굵기 (FONT_BOLD) — INT — NOT NULL
  • 상태 아이디 (STATE_ID) — 외래 키 → 상태.상태 아이디 — NOT NULL
  • 질문 유형 (QUESTION_TYPE) — NOT NULL

포커스_컨설턴트 (focus_all_consultant)

  • 사업명 (BUSINESS_NAME) — 기본 키 — NOT NULL
  • 제출일시 (CREATED_DATE) — NOT NULL
  • 폰트 굵기 (FONT_BOLD) — INT — NOT NULL
  • 상태 아이디 (STATE_ID) — 외래 키 → 상태.상태 아이디 — NOT NULL
  • 질문 유형 (QUESTION_TYPE) — NOT NULL
  • 고객 이름 (CLIENT_NAME) — NOT NULL