eat-da

Tables (7)

StoreCategory (매장-카테고리)

  • storeID (가게식별자) — Foreign key → Store.storeID — NOT NULL
  • categoryID (카테고리식별자) — Foreign key → Category.categoryID — NOT NULL

Banner (배너)

  • id (배너식별자) — Long — Primary key — NOT NULL
  • rank (순위)
  • link (링크) — String
  • imageUrl (이미지 URL) — String
  • expiredAt (만료일시)
  • createdAt (생성일시)
  • updatedAt (수정일시)

Category (카테고리)

  • categoryID (카테고리식별자) — Primary key — NOT NULL
  • name (이름) — String
  • createdAt (생성일시)
  • updatedAt (수정일시)

Menu (메뉴)

  • id (메뉴식별자) — Primary key — NOT NULL
  • storeID (가게식별자) — Foreign key → Store.storeID — NOT NULL
  • name (이름)
  • price (가격)
  • imageUrl (이미지 URL)
  • createdAt (생성일시)
  • updatedAt (수정일시)

Notice (알림)

  • id (알림식별자) — Long — Primary key — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • createdAt (생성일시)
  • updatedAt (수정일시)

Store (매장)

  • storeID (가게식별자) — Primary key — NOT NULL
  • name (이름)
  • address (주소)
  • displayName (Field)
  • contact (Field3)
  • phoneNumber (전화번호)
  • imageAddress (이미지 URL)
  • location_latitude (위도)
  • location_longitude (경도)
  • createdAt (생성일시)
  • updatedAt (수정일시)

StoreHours (영업시간)

  • id (영업시간식별자) — Primary key — NOT NULL
  • storeID (가게식별자) — Foreign key → Store.storeID — NOT NULL
  • dayOfWeek (요일)
  • openAt (시작 시간)
  • closeAt (마감 시간)
  • createdAt (생성일시)
  • updatedAt (수정일시)