kt실제데이터기반
테이블 (4)
T_BUILDING_ADDRESS (Untitled)
- ID (Key) — NUMBER — 기본 키 — NOT NULL
- BUILDING_NAME (Field) — VARCHAR2
- REGION (Field2) — VARCHAR2 — 지역
- ADDRESS (Field3) — VARCHAR2 — 주소
- LAND_AREA (Field4) — NUMBER — 토지면적
- BUILDING_AREA (Field5) — NUMBER — 건물면적
- COMPLETION_DATE (Field6) — DATE — 준공일
- LATITUDE (Field7) — NUMBER — 위도
- LONGITUDE (Field8) — NUMBER — 경도
T_BUILDING_INFO (Untitled2)
- ID (Key) — NUMBER — 기본 키 — NOT NULL
- OWNER (Field) — VARCHAR2 — 소유주
- FM_COMPANY (Field2) — VARCHAR2 — FM사
- BUILDING_NAME (Field3) — VARCHAR2 — FK
- CATEGORY1 (Field4) — VARCHAR2
- CATEGORY2 (Field5) — VARCHAR2
- BUILDING_CODE (Field6) — VARCHAR2
- COMPLETION_DATE (Field7) — DATE
- FLOORS (Field8) — VARCHAR2
- LAND_AREA (Field9) — NUMBER — 대지면적
- GROSS_AREA (Field10) — NUMBER — 연면적
- BUILDING_GRADE (Field11) — VARCHAR2 — 건물등급
- PORTFOLIO (Field12) — VARCHAR2
- IS_24HOURS (Field13) — VARCHAR2 — Y/N
- EMPLOYEE_COUNT (Field14) — NUMBER
- AFFILIATED_GROUP_COUNT (Field15) — NUMBER
- TENANT_COUNT (Field16) — NUMBER
- ANNEX_INFO (Field17) — VARCHAR2
- ANNEX_NOTE (Field18) — VARCHAR2
- PARKING_COUNT (Field19) — NUMBER
- PARKING_NOTE (Field20) — VARCHAR2
- MANAGER (Field21) — VARCHAR2
- MANAGER_PHONE (Field22) — VARCHAR2
- FM_DIRECTOR (Field23) — VARCHAR2
- FM_DIRECTOR_PHONE (Field24) — VARCHAR2
- SAFETY_MANAGER (Field25) — VARCHAR2
- SAFETY_MANAGER_PHONE (Field26) — VARCHAR2
- HAZARDOUS_MANAGER (Field27) — VARCHAR2
- HAZARDOUS_MANAGER_PHONE (Field28) — VARCHAR2
- EMERGENCY_CONTACT (Field29) — VARCHAR2
- EMERGENCY_PHONE (Field30) — VARCHAR2
- SECURITY_OFFICE (Field31) — VARCHAR2
- SECURITY_PHONE (Field32) — VARCHAR2
T_SMS_LOG_HISTORY (Untitled3)
- ID (Key) — NUMBER — 기본 키 — NOT NULL
- ORIGINAL_SMS_ID (Field) — VARCHAR2
- CATEGORY (Field2) — VARCHAR2
- TITLE (Field3) — VARCHAR2
- OWNER (Field4) — VARCHAR2
- BUILDING_NAME (Field5) — VARCHAR2
- FM_COMPANY (Field6) — VARCHAR2
- INCIDENT_DETAIL (Field7) — CLOB
- LOCATION (Field8) — VARCHAR2
- PM_NAME (Field9) — VARCHAR2
- PM_PHONE (Field10) — VARCHAR2
- INCIDENT_DATETIME (Field11) — DATE
- ACTION (Field12) — CLOB
- RESULT (Field13) — CLOB
- CAUSE (Field14) — VARCHAR2
- DAMAGE_DETAIL (Field15) — CLOB
- VIP_CUSTOMERS (Field16) — VARCHAR2
- CREATED_AT (Field17) — DATE
- UPDATED_AT (Field18) — DATE
T_SMS_RAW (Untitled4)
- ID (Key) — NUMBER — 기본 키 — NOT NULL
- SENT_AT (Field) — TIMESTAMP
- CONTENT (Field2) — CLOB