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