Resrvation nnn ERD

Tables (11)

Account (고객 / 매장)

  • ID — Auto — Primary key
  • Name — Text
  • Email — Picklist
  • ShippingAddress — Address
  • Email (Email__c) — Email
  • Grade (Grade__c) — Picklist
  • FirstVisitDate (FirstVisitDate__c) — Date
  • LastConsultationDate (LastConsultationDate__c) — Date
  • TotalOrders (TotalOrders__c) — Roll-up Summary
  • BusinessHours (BusinessHours__c) — Text

Case (문의)

    ConsultationAnswerOption__c (결과 아이템)

    • ID — ID — Primary key — NOT NULL
    • Order (Order__c) — Formula (Number)

    ConsultationAnswer__c (결과)

    • ID — ID — Primary key — NOT NULL
    • Consultation (Consultationc__c) — master-detail(Consultationc__c) — Foreign key → Consultationc__c.ID
    • FormId (FormId__c) — Lookup(ConsultationForm__c) — Foreign key → ConsultationQuestion__c.Id — NOT NULL
    • AnswerText (AnswerText__c) — Long Text Area
    • Order (Order__c) — Formula (Number)

    ConsultationForm__c (상담지 폼)

    • ID — ID — Primary key — NOT NULL
    • Name — Text
    • Description (Description__c) — Long Text
    • isActice (isActive__c) — Checkbox
    • FormType (FormType__c) — Picklist

    ConsultationQuestionOption__c (질문 옵션)

    • ID — ID — Primary key — NOT NULL
    • QuestionId (QuestionId__c) — master-Detail(ConsultationQuestion__c) — Foreign key → ConsultationQuestion__c.Id — NOT NULL
    • Order (Order__c) — Number
    • Name — Text(255)

    ConsultationQuestion__c (상담지 질문)

    • Id — Id — Primary key — NOT NULL
    • FormId (FormId__c) — master-Detail(ConsultationForm__c) — Foreign key → ConsultationForm__c.ID — NOT NULL
    • Question (Question__c) — Long Text
    • Type (Type__c) — Picklist
    • Order (Order__c) — Number

    Consultationc__c (상담)

    • ID — Auto — Primary key
    • Reservation (Reservation__c) — Lookup(Reservation__c) — Foreign key → Reservation__c.ID
    • Account (Account__c) — Lookup(Account__c) — Foreign key → Account.ID
    • FormId (FormId__c) — Lookup(ConsultationForm__c) — Foreign key → ConsultationForm__c.ID — NOT NULL
    • AssignedUser (AssignedUser__c) — Lookup(User)
    • ConsultationType (ConsultationType__c) — DateTime
    • Status (Status__c) — Picklist
    • Date — Date

    ReservationRelatedTime (예약 인원 관리)

    • ID — Auto — Primary key — NOT NULL
    • Store (Store__c) — Lookup(Account) — Foreign key → Account.ID
    • SeatType (SeatType__c) — Lookup(SeatTypeSchedule) — Foreign key → StoreSeatType__c.ID — NOT NULL
    • Name — Text
    • Date (ReservationDate__c) — Date
    • ReservedCount (ReservedCount__c) — Number
    • AvailableCount (AvailableCount__c) — Fumular
    • IsAvailable (IsAvailable__c) — Checkbox

    Reservation__c (전체 예약 정보)

    • ID — Auto — Primary key
    • ReservationRelatedTimeId (ReservationRelatedTimeId__c) — Master-Deatil(ReservationRelatedTime__c) — Foreign key → ReservationRelatedTime.ID — NOT NULL
    • Customer (Customer__c) — Lookup(Account__c) — Foreign key → Account.ID
    • Store (Store__c) — Lookup(Account__c) — Foreign key → Account.ID
    • SeatType (SeatType__c) — Lookup(SeatTypeSchedule__c) — Foreign key → StoreSeatType__c.ID — NOT NULL
    • Status (Status__c) — Picklist
    • Date — Date
    • ReservationCount (ReservationCount__c) — Picklist
    • Memo (Memo__c) — Long Text
    • Phone (Phone__c) — Number

    StoreSeatType__c (좌석 , 시간대 관리)

    • ID (Id) — Auto — Primary key — NOT NULL
    • Store (Store__c) — Lookup(Account) — Foreign key → Account.ID
    • Name — Text
    • SeatType (SeatType__c) — Picklist
    • MaxSeat (MaxSeat__c) — Number
    • MaxPerson (MaxPerson__c) — Number
    • MinPerson (MinPerson__c) — Number
    • Time (Time__c) — Time