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