ZB_technical challenges
Tables (8)
Member (회원)
- primary key (id) — Primary key — NOT NULL
- member id (UID) — VARCHAR(255)
- member password (password) — VARCHAR(255)
- member role (role) — VARCHAR(255)
- member name (name) — VARCHAR(255)
- member phone number (phone) — VARCHAR(255)
- member ID status (status) — VARCHAR(255)
- created date (createdAt) — yyyy-MM-dd'T'HH:mm
- update date (updatedAt) — yyyy-MM-dd'T'HH:mm
Menu (메뉴)
- primary key (id) — Primary key — NOT NULL
- reservation id (reservationId) — Foreign key → Reservation.primary key — NOT NULL
- store id (storeId) — Foreign key → Store.primary key — NOT NULL
- menu name (name) — VARCHAR(255)
- menu explanation (explanation) — VARCHAR(255)
- menu price (price)
- menu image (image) — S3
- menu status (status) — VARCHAR(255)
- create date (createdAt) — yyyy-MM-dd'T'HH:mm
- update date (updatedAt) — yyyy-MM-dd'T'HH:mm
RefreshToken (리프레시 토큰)
- primary key (id) — Primary key — NOT NULL
- member id (memberId) — Foreign key → Member.primary key — NOT NULL
- refresh token (refreshToken) — VARCHAR(255)
- created date (createdAt) — yyyy-MM-dd'T'HH:mm
- update date (updatedAt) — yyyy-MM-dd'T'HH:mm
Reservation (예약 정보)
- primary key (id) — Primary key — NOT NULL
- member id (memberId) — Foreign key → Member.primary key — NOT NULL
- store id (storeId) — Foreign key → Store.primary key — NOT NULL
- reservation date time (reservedDateTime) — yyyy-MM-dd'T'HH:mm
- reservation date (reservedDate) — yyyy-MM-dd
- reservation accepted (acceptedStatus) — VARCHAR(255)
- visited status (visitedStatus) — VARCHAR(255)
- reservation status (status) — VARCHAR(255)
- created date (createdAt) — yyyy-MM-dd'T'HH:mm
- update date (updatedAt) — yyyy-MM-dd'T'HH:mm
ReservationStillAvailableReviewing (리뷰 작성 가능 예약 목록)
- primary key (id) — Primary key — NOT NULL
- member id (memberId) — Foreign key → Member.primary key — NOT NULL
- store id (storeId) — Foreign key → Store.primary key — NOT NULL
- reservation id (reservationId) — Foreign key → Reservation.primary key — NOT NULL
- reservation visited date (visitedDate) — yyyy-MM-dd
- review written status (status) — VARCHAR(255)
- created date (createdAt) — yyyy-MM-dd'T'HH:mm
- updated date (updatedAt) — yyyy-MM-dd'T'HH:mm
Review (리뷰)
- primary key (id) — Primary key — NOT NULL
- member id (memberId) — Foreign key → Member.primary key — NOT NULL
- store id (storeId) — Foreign key → Store.primary key — NOT NULL
- star rating (starRating)
- review message (reviewMessage) — VARCHAR(255)
- review status (status) — VARCHAR(255)
- create date (createdAt) — yyyy-MM-dd'T'HH:mm
- update date (updatedAt) — yyyy-MM-dd'T'HH:mm
Store (매장)
- primary key (id) — Primary key — NOT NULL
- member id (memberId) — Foreign key → Member.primary key — NOT NULL
- store name (name) — VARCHAR(255)
- store location (latitude)
- store location (longitude)
- store explanation (explanation) — VARCHAR(255)
- store open hours (openHours) — "HH:mm"
- store closed hours (closedHours) — "HH:mm"
- store reservation term (reservationTerm) — "HH:mm"
- store status (status) — VARCHAR(255)
- store signed status (signedStatus) — VARCHAR(255)
- created date (createdAt) — yyyy-MM-dd'T'HH:mm
- update date (updatedAt) — yyyy-MM-dd'T'HH:mm
StoreReservationInfo (매장 예약 관련 정보)
- primary key (id) — Primary key — NOT NULL
- store id (storeId) — Foreign key → Store.primary key — NOT NULL
- store reservation term (reservationTerm) — "HH:mm"
- store table count (tableCount)
- store seating capacity per table (seatingCapacityPerTable)
- create date (createdAt) — yyyy-MM-dd'T'HH:mm
- update date (updatedAt) — yyyy-MM-dd'T'HH:mm