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