sikdorang
Tables (8)
category (Untitled2)
- pk — Integer — Primary key — NOT NULL
- category (카테고리) — String
- storeId (가게 아이디) — Integer — Foreign key → store.pk — NOT NULL
image (Untitled4)
- pk — Integer — Primary key — NOT NULL
- imageURL (이미지) — String
- menuId (메뉴 아이디) — Integer — Foreign key → menu.pk — NOT NULL
- storeId (가게아이디) — Integer — Foreign key → store.pk — NOT NULL
menu (Untitled3)
- pk — Integer — Primary key — NOT NULL
- menu (메뉴) — String
- preview (한줄설명) — String
- details (상세설명) — String
- price (가격) — Integer
- categoryId (카테고리아이디) — Integer — Foreign key → category.pk — NOT NULL
- storeId (가게아이디) — Integer — Foreign key → store.pk — NOT NULL
- soldOut (품절) — Boolean
- order (순서) — Integer
recommand_keyword (Untitled)
- pk — Integer — Primary key — NOT NULL
- keyword1 (키워드1) — String
- keyword2 (키워드2) — String
recommand_menu (Untitled7)
- pk — Integer — Primary key — NOT NULL
- storeId (가게 아이디) — Integer — Foreign key → store.pk — NOT NULL
- menuId (메뉴아이디) — Integer — Foreign key → menu.pk — NOT NULL
- score (점수) — Integer
- keywordId (키워드 아이디) — Integer — Foreign key → recommand_keyword.pk — NOT NULL
recommand_question (Untitled6)
- pk — Integer — Primary key — NOT NULL
- question (질문) — String
- recommand_keywordId (키워드 아이디) — Integer — Foreign key → recommand_keyword.pk — NOT NULL
store (Untitled5)
- pk — Integer — Primary key — NOT NULL
- store (가게이름) — String
- address (가게주소) — String
- userID (아이디) — String
- password (비밀번호) — String
- storeNumber (가게전화번호) — String
- manager (관리자이름) — String
- phoneNumber (개인전화번호) — String
- approved (승인여부) — Boolean
- paid (결제여부) — Boolean
- refreshToken (리프레시 토큰) — String
tag (Untitled8)
- pk — Integer — Primary key — NOT NULL
- tag (태그) — String
- menuId (메뉴아이디) — Integer — Foreign key → menu.pk — NOT NULL