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