claude_erd

Tables (33)

Account

  • Id — Id — Primary key — NOT NULL
  • Name — 텍스트(80)
  • Address__c — 텍스트(255)
  • Phone__c — 전화
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Agency_Sales_Item__c

  • Id — Id — Primary key — NOT NULL
  • Agency_Sales__c — 마스터-세부 — Foreign key → Agency_Sales__c.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Name — 자동
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)
  • Quantity__c — 숫자

Agency_Sales__c

  • Id — Id — Primary key — NOT NULL
  • Case__c — 조회(문의) — Foreign key → Case.Id
  • Id (Id2) — Id — Foreign key → Agency__c.Id — NOT NULL
  • Agency_Id__c — Id
  • Sales_Date__c — 날짜
  • Total_Amount__c — 통화
  • Status__c — 선택목록
  • Payment__c — 선택목록
  • Invoice__c — 파일
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Agency__c

  • Id — Id — Primary key — NOT NULL
  • Name — 텍스트(80)
  • Address__c — 텍스트영역(255)
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Asset_Movement_History__c

  • Id — Id — Primary key — NOT NULL
  • Shipment__c — 조회(배송) — Foreign key → Shipment__c.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Shipment_Item__c — 조회(배송 품목) — Foreign key → Shipment_Item__c.Id
  • Name — 자동
  • Movement_Type__c — 선택
  • Movement_Date__c — 날짜
  • To_Type__c — 선택목록
  • To_Record_Id__c — 텍스트(18)
  • To_Name__c — 텍스트(255)
  • From_Type__c — 선택목록
  • From_Record_Id__c — 텍스트(18)
  • From_Name__c — 텍스트(255)
  • OwnerId — 조회(사용자)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Asset__c

  • Id — Id — Primary key — NOT NULL
  • Contact__c — 조회(환자) — Foreign key → Contact.Id
  • Product__c — 조회(제품) — Foreign key → Product__c.Id
  • Name — 텍스트(80)
  • Is_New__c — 선택
  • Status__c — 선택
  • Compliance_Data_Source__c — 선택
  • Stock_In_Date__c — 날짜
  • Warranty_End_Date__c — 날짜
  • NHI_Registration_Date__c — 날짜
  • Current_Location_Id__c — 텍스트(18)
  • Current_Location_Type__c — 선택
  • Current_Location_Name__c — 텍스트(255)
  • OwnerId — 조회(사용자,그룹)
  • Notes__c — 긴텍스트영역(32768)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Case

  • Id — Id — Primary key — NOT NULL
  • Repair__c — 조회(수리) — Foreign key → Repair__c.Id
  • ContactId — 조회(연락처) — Foreign key → Contact.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • RecordTypeId — 레코드
  • CaseNumber — 자동번호
  • Inquiry_Type__c — 선택목록
  • Name__c — 텍스트(120)
  • Satisfaction_Score__c — 선택
  • Consultation_Date__c — 날짜
  • Status — 상태
  • Channel__c — 선택목록
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Compliance_History__c

  • Id — Id — Primary key — NOT NULL
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Contract__c — 조회(계약) — Foreign key → Contract.Id
  • Compliance__c — 숫자
  • Measurement_Month__c — 선택목록
  • Measurement_Start_Date__c — 날짜
  • Measurement_End_Date__c — 날짜
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Consumable_Sales_Item__c

  • Id — Id — Primary key — NOT NULL
  • Consumable_Sales__c — 마스터-세부 — Foreign key → Consumable_Sales__c.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Name — 자동
  • Item_Type__c — 선택
  • Quantity__c — 숫자
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Consumable_Sales__c

  • Id — Id — Primary key — NOT NULL
  • Contract__c — 조회(계약) — Foreign key → Contract.Id
  • Case__c — 조회(문의) — Foreign key → Case.Id
  • Status__c — 선택목록
  • Order_Date__c — 날짜
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Contact

  • Id — Id — Primary key — NOT NULL
  • Hospital__c — 조회(병원) — Foreign key → Hospital__c.Id
  • Doctor__c — 조회(담당의) — Foreign key → Doctor__c.Id
  • AccountId — Id — Foreign key → Account.Id
  • Name__c — 텍스트(255)
  • Phone — 전화
  • Address__c — 텍스트(255)
  • NHI_Mask_Purchase_Date__c — 날짜
  • NHI_Branch__c — 텍스트(100)
  • BirthDate__c — 날짜
  • Gender__c — 선택목록
  • PSG_Pass_Date__c — 날짜
  • Compliance_Pass_Date__c — 날짜
  • Delegation_Start_Date__c — 날짜
  • Delegation_End_Date__c — 날짜
  • Email — 이메일
  • Resident_Number__c — 텍스트(50)
  • Last_Prescription_Period__c — 텍스트(50)
  • Last_Prescription_Date__c — 날짜
  • First_Rental_Date__c — 날짜
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Contract

  • Id — Id — Primary key — NOT NULL
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Substitute_Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Contact__c — 조회(환자) — Foreign key → Contact.Id
  • ContractTerm — 숫자(4,0)
  • ContractNumber — 자동
  • Name — 텍스트(80)
  • EndDate — 날짜
  • NHI_Registration_Date__c — 날짜
  • Contract_File__c — 텍스트(255)
  • Return_Status__c — 선택
  • Return_Date__c — 날짜
  • Return_Confirmation_File__c — 텍스트(255)
  • Insurance_Type__c — 선택
  • Compliance_Status__c — 선택
  • Compliance_Report_File__c — 텍스트(255)
  • Delegation_File__c — 텍스트(255)
  • Prescription_Pressure__c — 텍스트(50)
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)
  • ActivatedDate — 날짜/시간
  • ActivatedById — 조회(사용자)

Doctor__c

  • Id — Id — Primary key — NOT NULL
  • Hospital__c — 조회(병원) — Foreign key → Hospital__c.Id
  • Name — 텍스트(80)
  • License_Number__c — 텍스트(50)
  • Phone__c — 전화
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Hospital__c

  • Id — Id — Primary key — NOT NULL
  • Name — 텍스트(80)
  • Phone__c — 전화
  • Phone2__c — 전화
  • Address__c — 텍스트(255)
  • Is_Parking_Supported__c — 확인란
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Message_Log__c

  • Id — Id — Primary key — NOT NULL
  • ContactId — 조회(환자) — Foreign key → Contact.Id
  • Tester__c — 조회(검사자) — Foreign key → Tester__c.Id
  • Message_Type__c — 선택목록
  • Status__c — 선택목록
  • MessageBody__c — 텍스트영역
  • Requested_Date__c — 날짜
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Online_Sales_Item__c

  • Id — Id — Primary key — NOT NULL
  • Online_Sales__c — 마스터-세부 — Foreign key → Online_Sales__c.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Name — 자동
  • Quantity__c — 숫자
  • Sales_Price__c — 통화
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Online_Sales__c

  • Id — Id — Primary key — NOT NULL
  • Contact__c — 조회(환자) — Foreign key → Contact.Id
  • Order_Date__c — 날짜
  • Status__c — 선택목록
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)
  • Customer_Name__c — 텍스트(80)
  • Customer_Phone__c — 전화
  • Customer_Email__c — 이메일
  • Recipient_Name__c — 텍스트(80)
  • Recipient_Phone__c — 전화
  • Shipping_Address__c — 텍스트(255)
  • Note__c — 긴
  • Total_Amount__c — 통화
  • Shipping_Fee__c — 통화
  • Total_Payment_Amount__c — 수식(상품총액+택배비여부)

Product_Category__c

  • Id — Id — Primary key — NOT NULL
  • Category_Type__c — 선택
  • Name — 텍스트(80)
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Product__c

  • Id — Id — Primary key — NOT NULL
  • Product_Category__c — 조회(제품 카테고리) — Foreign key → Product_Category__c.Id
  • Name — 텍스트(80)
  • Manufacturer__c — 선택목록
  • Target_Stock_S__c — 숫자(6,0)
  • Target_Stock_B__c — 숫자(6,0)
  • Target_Stock_G__c — 숫자(6,0)
  • Purchase_Price__c — 통화(12,0)
  • Model_Name__c — 텍스트(100)
  • CPAP_Type__c — 선택
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Repair_Center__c

  • Id — Id — Primary key — NOT NULL
  • Name — 텍스트(80)
  • Address__c — 텍스트영역(255)
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Repair_Item__c

  • Id — Id — Primary key — NOT NULL
  • Repair__c — 마스터-세부 — Foreign key → Repair__c.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Name — 자동
  • Item_Type__c — 선택
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Repair__c

  • Id — Id — Primary key — NOT NULL
  • Contract__c — 조회(계약) — Foreign key → Contract.Id
  • Case__c — 조회(문의) — Foreign key → Case.Id
  • Outsource_Center__c — 조회(외주수리업체) — Foreign key → Repair_Center__c.Id
  • Replacement_Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • New_Contract__c — 조회(계약) — Foreign key → Contract.Id
  • Scrap_Approved_By__c — 조회(사용자)
  • Inspection_Report_File__c — 텍스트(255)
  • Inspection_Datetime__c — 날짜/시간
  • Inspection_Result__c — 긴
  • Outsource_Vendor__c — 텍스트(255)
  • Repair_Reason__c — 긴
  • Notes__c — 긴
  • Source_Address__c — 긴
  • Source_Type__c — 텍스트(255)
  • Scrap_Approved_Datetime__c — 날짜/시간
  • Is_Substitute_Provided__c — 확인란
  • Substitute_Collection_Requested_Datetime__c — 날짜/시간
  • Substitute_Returned_Datetime__c — 날짜/시간
  • Status__c — 선택목록
  • Name — 자동번호
  • Repair_Start_Date__c — 날짜
  • Repair_End_Date__c — 날짜
  • Repair_Type__c — 선택목록
  • Repair_Cost__c — 통화(10,0)
  • Repair_Category__c — 선택목록
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Return_Item__c

  • Id — Id — Primary key — NOT NULL
  • Return__c — 조회(반납) — Foreign key → Return__c.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Name — 자동
  • Item_Type__c — 선택
  • Quantity__c — 숫자
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Return__c

  • Id — Id — Primary key — NOT NULL
  • Contract__c — 조회(계약) — Foreign key → Contract.Id
  • Case__c — 조회(문의) — Foreign key → Case.Id
  • Status__c — 선택목록
  • Return_Registered_Date__c — 날짜
  • Completed_Date__c — 날짜
  • Note__c — 긴
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Shipment_Item__c

  • Id — Id — Primary key — NOT NULL
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Shipment__c — 조회(배송) — Foreign key → Shipment__c.Id
  • Name — 자동
  • Quantity__c — 숫자(6,0)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Shipment__c

  • Id — Id — Primary key — NOT NULL
  • Name — 자동
  • Status__c — 선택목록
  • Completed_Date__c — 날짜
  • Shipment_Type__c — 선택목록
  • Tracking_Number__c — 텍스트(50)
  • From__c — 텍스트(255)
  • To__c — 텍스트(255)
  • Direction__c — 선택
  • Registered_Date__c — 날짜
  • OwnerId — 조회(사용자)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Sleep_Test_Item__c

  • Id — Id — Primary key — NOT NULL
  • Sleep_Test__c — 마스터-세부 — Foreign key → Sleep_Test__c.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Name — 자동
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Sleep_Test__c

  • Id — Id — Primary key — NOT NULL
  • Hospital__c — 조회(병원) — Foreign key → Hospital__c.Id
  • Contact__c — 조회(환자) — Foreign key → Contact.Id
  • Tester__c — 조회(검사자) — Foreign key → Tester__c.Id
  • Name — 텍스트(80)
  • Test_Type__c — 선택
  • Status__c — 선택
  • Scheduled_Date__c — 날짜
  • Confirmation_Datetime__c — 날짜/시간
  • Visit_Expected_Time__c — 시간
  • Is_Daily_SMS_Sent__c — 확인란
  • Daily_Notification_Confirmed_Datetime__c — 날짜/시간
  • Weekly_Notification_Confirmed_Datetime__c — 날짜/시간
  • RecordTypeId — 레코드
  • Completed_Date__c — 날짜
  • Distance__c — 숫자(9,1)
  • Distance_Roundtrip__c — 수식(숫자)
  • Fuel_Amount__c — 수식(숫자)
  • Parking_Fee__c — 숫자(10,0)
  • Is_Fuel_Reimbursed__c — 확인란
  • Is_Parking_Reimbursed__c — 확인란
  • Note__c — 긴
  • Prescription_Pressure__c — 텍스트(50)
  • AHI_Score__c — 숫자(3,2)
  • PSG_Result_File__c — 텍스트(255)
  • TIT_Result_File__c — 텍스트(255)
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Stock_Transfer_Item__c

  • Id — Id — Primary key — NOT NULL
  • Stock_Transfer__c — 마스터-세부 — Foreign key → Stock_Transfer__c.Id
  • Asset__c — 조회(자산) — Foreign key → Asset__c.Id
  • Name — 자동
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)
  • Quantity__c — 숫자

Stock_Transfer__c

  • Id — Id — Primary key — NOT NULL
  • From_Account__c — 조회(본사/지사) — Foreign key → Account.Id
  • To_Account__c — 조회(본사/지사) — Foreign key → Account.Id
  • Status__c — 선택목록
  • Requested_Date__c — 날짜
  • Completed_Date__c — 날짜
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Tester__c

  • Id — Id — Primary key — NOT NULL
  • Name — 텍스트(80)
  • Is_Fuel_Expense_Allowed__c — 확인란
  • Phone__c — 전화
  • Is_Active__c — 확인란
  • Address__c — 텍스트
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Travel__c

  • Id — Id — Primary key — NOT NULL
  • ContactId — 조회(환자) — Foreign key → Contact.Id
  • Name — 자동번호
  • Departure_Date__c — 날짜
  • Arrival_Date__c — 날짜
  • Phone__c — 전화
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)

Work_Shipment_Link__c

  • Id — Id — Primary key — NOT NULL
  • Work_Type__c — 선택목록
  • Repair__c — 조회(수리) — Foreign key → Repair__c.Id
  • Shipment__c — 조회(배송) — Foreign key → Shipment__c.Id
  • Agency_Sales__c — 조회(대리점 판매) — Foreign key → Agency_Sales__c.Id
  • Sleep_Test__c — 조회(검사이력) — Foreign key → Sleep_Test__c.Id
  • Consumable_Sales__c — 조회(소모품 판매) — Foreign key → Consumable_Sales__c.Id
  • Return__c — 조회(반납) — Foreign key → Return__c.Id
  • Online_Sales__c — 조회(쇼핑몰 판매) — Foreign key → Online_Sales__c.Id
  • Name — 자동
  • OwnerId — 조회(사용자,그룹)
  • CreatedById — 조회(사용자)
  • LastModifiedById — 조회(사용자)