spring_project

Tables (7)

CART (장바구니)

  • cid (Key) — Primary key — NOT NULL
  • mid (유저 고유 아이디) — Foreign key → MEMBER.mid — NOT NULL
  • regdate (등록일) — DATE

CART. (장바구니.)

  • cmid (Key) — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • mid (사용자 고유아이디) — INT — Foreign key → MEMBER..mid — NOT NULL
  • pid (상품 고유아이디) — INT — Foreign key → PRODUCT..pid — NOT NULL
  • quantity (담을 수량) — INT
  • totalprice (총 가격) — INT
  • added_at (추가한 일자) — DATE

CARTITEM (장바구니아이템)

  • cmid (Key) — Primary key — NOT NULL
  • cid (카트 고유아이디) — Foreign key → CART.cid — NOT NULL
  • pid (상품 고유아이디) — Foreign key → PRODUCT.pid — NOT NULL
  • quantity (담을 수량)
  • added_at (추가한 일자) — DATE

MEMBER (사용자)

  • mid (Key) — Primary key — NOT NULL
  • username (아이디) — VARCHAR
  • password (비밀번호)
  • email (이메일)
  • role (권한)
  • regdate (등록일)

MEMBER. (사용자.)

  • mid (Key) — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • username (아이디) — VARCHAR — UNIQUE
  • password (비밀번호) — VARCHAR
  • email (이메일) — VARCHAR — UNIQUE
  • role (권한) — VARCHAR
  • regdate (등록일) — DATE

PRODUCT (상품)

  • pid (Key) — Primary key — NOT NULL
  • name (상품명)
  • price (가격)
  • amount (재고수량)
  • img (이미지) — LOB
  • regdate (등록일) — DATE

PRODUCT. (상품.)

  • pid (Key) — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • name (상품명) — VARCHAR
  • price (가격) — INT
  • amount (재고수량) — INT
  • img (이미지) — LOB
  • regdate (등록일) — DATE