LGAS

Tables (13)

AFTER_VISIT_REPORT

  • REPORT_ID — NUMBER
  • VISIT_ID — NUMBER — NOT NULL
  • FEE_ID — NUMBER
  • FINAL_CAUSE — VARCHAR2(500) — NOT NULL
  • MAINTENANCE_GUIDE — CLOB
  • STANDARD_TRAVEL_COST — NUMBER — NOT NULL
  • STANDARD_TECH_COST — NUMBER — NOT NULL
  • FINAL_TOTAL_COST — NUMBER
  • GENERATED_AT — TIMESTAMP — NOT NULL

AI_ANALYSIS_RESULT

  • ANALYSIS_ID — NUMBER
  • VISIT_ID — NUMBER — NOT NULL
  • STT_TEXT — CLOB
  • SUMMARY — CLOB

AS_REQUEST

  • REQUEST_ID — NUMBER
  • CUSTOMER_ID — NUMBER — NOT NULL
  • PRODUCT_ID — NUMBER — NOT NULL
  • SYMPTOM_ID — NUMBER — NOT NULL
  • SERVICE_ADDRESS — VARCHAR2(500) — NOT NULL
  • CONTACT_PHONE — VARCHAR2(20) — NOT NULL
  • STATUS — VARCHAR2(50) — NOT NULL
  • REQUESTED_AT — TIMESTAMP — NOT NULL

BEFORE_VISIT_REPORT

  • REPORT_ID — NUMBER
  • REQUEST_ID — NUMBER — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL

CUSTOMER_DETAIL

  • CUSTOMER_ID — NUMBER
  • DEFAULT_ADDRESS — VARCHAR2(500)

PRODUCT_MASTER

  • PRODUCT_ID — NUMBER
  • CATEGORY_NAME — VARCHAR2(255) — NOT NULL
  • PRODUCT_NAME — VARCHAR2(255) — NOT NULL
  • MANUAL_URL — VARCHAR2(500)

REPAIR_LOG

  • LOG_ID — NUMBER
  • VISIT_ID — NUMBER — NOT NULL
  • ACTION_TAKEN — CLOB

REPAIR_PRICE_MASTER

  • FEE_ID — NUMBER
  • REPAIR_ITEM_NAME — VARCHAR2(255) — NOT NULL
  • STANDARD_PARTS_COST — NUMBER — NOT NULL

SYMPTOM_MASTER

  • SYMPTOM_ID — NUMBER
  • PRODUCT_ID — NUMBER — NOT NULL
  • PROBLEM_TYPE — VARCHAR2(255) — NOT NULL
  • SYMPTOM_NAME — VARCHAR2(255) — NOT NULL

TECHNICIAN_DETAIL

  • TECH_ID — NUMBER
  • CENTER_NAME — VARCHAR2(255)
  • EMP_NUMBER — VARCHAR2(50) — NOT NULL

USERS

  • USER_ID — NUMBER
  • LOGIN_ID — VARCHAR2(50) — NOT NULL
  • USER_TYPE — VARCHAR2(20) — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL

VISIT_TASK

  • VISIT_ID — NUMBER
  • REQUEST_ID — NUMBER — NOT NULL
  • TECH_ID — NUMBER — NOT NULL
  • SCHEDULED_AT — TIMESTAMP — NOT NULL
  • START_AT — TIMESTAMP
  • END_AT — TIMESTAMP
  • VISIT_STATUS — VARCHAR2(50) — NOT NULL

VOICE_RECORDING

  • RECORD_ID — NUMBER
  • VISIT_ID — NUMBER — NOT NULL
  • FILE_PATH — VARCHAR2(500) — NOT NULL