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
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)