DUGOUT

Tables (6)

BANNER (Untitled6)

  • bannerImg (배너이미지) — blob — Primary key — NOT NULL

CART (Untitled4)

  • userId (유저아이디) — varchar(25) — Foreign key → USER.userId — NOT NULL
  • goodsId (상품아이디) — number(10) — Foreign key → GOODS.goodsId — NOT NULL
  • name (상품이름) — varchar(100)
  • team (야구팀분류) — varchar(20)
  • price (가격) — number(20)
  • mainImg (메인이미지) — blob
  • stock (재고) — number(10)
  • count (수량) — number(10)

GOODS (Untitled2)

  • goodsId (상품아이디) — number(10) — Primary key — NOT NULL
  • name (상품이름) — varchar(100)
  • team (야구팀분류) — varchar(20)
  • price (가격) — number(20)
  • category (상품분류) — varchar(20)
  • stock (재고) — number(10)
  • status (판매상태) — boolean
  • mainImg (메인이미지) — blob
  • detailImg (상세이미지) — blob
  • reg_date (등록일) — date
  • like (찜순) — number(10)
  • sales (판매량) — number(10)

GOODS_LIKE (Untitled3)

  • userId (유저아이디) — Vachar(25) — Foreign key → USER.userId — NOT NULL
  • goodsId (상품아이디) — number(10) — Foreign key → GOODS.goodsId — NOT NULL
  • name (상품이름) — varchar(100)
  • team (야구팀분류) — varchar(20)
  • price (가격) — number(20)
  • status (판매상태) — boolean

ORDER (Untitled5)

  • userId (유저아이디) — varchar(25) — Foreign key → USER.userId — NOT NULL
  • team (팀분류) — varchar(20)
  • name (상품이름) — varchar(20)
  • price (가격) — number(20)
  • mainImg (메인이미지) — blob
  • buy_date (구매날짜) — date

USER (Untitled)

  • userId (유저아이디) — Vachar(25) — Primary key — NOT NULL
  • password (비밀번호) — Vachar(50)
  • name (이름) — Vachar(15)
  • phone (휴대폰번호) — Number(22)
  • address (주소) — Vachar(200)
  • emial (이메일) — Vachar(100)
  • admin (관리자) — Boolean