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
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