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