BbangBbang

Tables (6)

Bread (BreadUrl)

  • Key (breadIdx) — Integer — Primary key — NOT NULL
  • Field (breadImgUrl) — Text

BreadUrl (Bread)

  • Key (breadIdx) — Primary key — NOT NULL

Shop

  • Key (ShopIdx) — Primary key — NOT NULL
  • Field

Untitled5 (Review)

    Untitled6 (ReviewUrl)

      User

      • Key (userIdx) — Integer — Primary key — NOT NULL
      • Field (userName) — varchar(20)
      • Field2 (userPhone) — varchar(15)
      • Field (userEmail) — varchar(40)
      • Field (isShop) — boolean — shop 권한이 있는 계정은 true, 없는 계정은 false
      • Field (createdAt) — TIMESTAMP
      • Field2 (updatedAt) — TIMESTAMP
      • Field (shopIdx) — Integer — NOT NULL — isShop이 true인 경우, shopIdx를 지정해줌.