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