demae

Tables (8)

CART (Untitled4)

  • cartId (pk) — BIGINT — Primary key — NOT NULL
  • cartState (주문상태) — VARCHAR(10)
  • cartPrice (주문 가격) — INT
  • userId (pk2) — BIGINT — Foreign key → User.userId — NOT NULL
  • storeId (pk3) — BIGINT — Foreign key → Store.storeId — NOT NULL
  • menuId (pk4) — BIGINT — Foreign key → Menu.menuId — NOT NULL

Menu (Untitled3)

  • menuId (pk) — BIGINT — Primary key — NOT NULL
  • menuName (메뉴이름) — VARCHAR(255)
  • menuPrice (메뉴가격) — INT
  • storeId (pk2) — BIGINT — Foreign key → Store.storeId — NOT NULL

Order (Untitled2)

    OrderList (Untitled7)

      Picture (Untitled5)

        Review (Untitled6)

        • reviewId (pk) — BIGINT — Primary key — NOT NULL
        • reviewPoint (리뷰별점) — INT
        • reviewContent (리뷰설명) — VARCHAR(255)
        • orderId (pk2) — BIGINT — Foreign key → CART.cartId — NOT NULL
        • menuId (pk3) — BIGINT — Foreign key → Menu.menuId — NOT NULL

        Store (Untitled8)

        • storeId (pk) — BIGINT — Primary key — NOT NULL
        • storeName (상점이름) — VARCHAR(255)
        • storeAddress (상점주소) — VARCHAR(255)
        • storeCategory (상품분류) — VARCHAR(255)
        • userId (pk2) — BIGINT — Foreign key → User.userId — NOT NULL

        User (Untitled)

        • userId (pk) — BIGINT — Primary key — NOT NULL
        • email (이메일) — VARCHAR(255)
        • passwoerd (비밀번호) — VARCHAR(255)
        • phone (전화번호) — VARCHAR(11)
        • userName (이름) — VARCHAR(20)
        • userAddress (주소) — VARCHAR(255)
        • point (코인) — INT
        • role (Field7) — VARCHAR(10)