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