Reservation ERD

Tables (4)

Account (고객/매장)

  • ID (Key) — ID — Primary key — NOT NULL
  • Name — Text(255)
  • Email — Address
  • Grade (Grade__c) — Picklist
  • FirstVisitDate (FirstVisitDate__c) — Date
  • LastConsultationDate (LastConsultationDate__c) — Date
  • TotalOrders (TotalOrders__c) — Roll-up Summary
  • BusinessHours (BusinessHours__c) — Text

ReservationRelatedTime (CopyOfCopyOf고객/매장2)

  • ID (Key2) — ID — Primary key — NOT NULL
  • Store (Key) — Lookup(Account) — Foreign key → Account.ID — NOT NULL
  • SeatType (Key22) — Lookup(SeatTypeSchedule) — Foreign key → SeatTypeSchedule__c.ID — NOT NULL
  • Name — Text(255)
  • Date (TotalOrders__c) — Date
  • ReservedCount (BusinessHours__c) — Number
  • AvailableCount (Field) — Fumular
  • IsAvailable (Field2) — Checkbox

Reservation__c (CopyOf고객/매장)

  • ID (Key) — ID — Primary key — NOT NULL
  • ReservationRelatedTimeId (Key23) — Master-Deatil(ReservationRelatedTime__c) — Foreign key → ReservationRelatedTime.ID — NOT NULL
  • Customer (Key2) — Lookup(Account__c) — Foreign key → Account.ID — NOT NULL
  • Store (Key3) — Lookup(Account__c) — Foreign key → Account.ID — NOT NULL
  • SeatType (Key22) — Lookup(SeatTypeSchedule__c) — Foreign key → SeatTypeSchedule__c.ID — NOT NULL
  • ReservationRelatedTimeId (Name) — Text(255)
  • SeatType (FirstVisitDate__c) — Lookup(SeatTypeSchedule__c)
  • Status (LastConsultationDate__c) — Picklist
  • Date (TotalOrders__c) — Date
  • ReservationCount (BusinessHours__c) — Picklist
  • Memo (Field) — LongText
  • Phone (Field2) — Number

SeatTypeSchedule__c (CopyOfCopyOf고객/매장)

  • ID (Key2) — ID — Primary key — NOT NULL
  • Name — Text(255)
  • SeatType (FirstVisitDate__c) — Picklist
  • MaxSeat (LastConsultationDate__c) — Number
  • MaxPerson (TotalOrders__c) — Number
  • MinPerson (BusinessHours__c) — Number
  • Memo (Field) — LongText
  • Time (Field2) — Time
  • Store (Key) — Lookup(Account) — Foreign key → Account.ID — NOT NULL