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 (수정일시)