Likelion2

Tables (5)

Cart (CopyOfCopyOfCopyOfUntitled2)

  • ID (Key) — int — Primary key — NOT NULL
  • 수량 (Field4) — int
  • 담은 날짜 (Field5) — datetime
  • Product ID (Key2) — int — Foreign key → Product.ID — NOT NULL
  • User ID (Key3) — int — Foreign key → User.ID — NOT NULL

Order (CopyOfCopyOfUntitled)

  • ID (Key) — int — Primary key — NOT NULL
  • 주문 날짜 (Field3) — datetime
  • 배송 상태 (Field4) — varchar
  • 총 금액 (Field5) — int
  • User ID (Key2) — int — Foreign key → User.ID — NOT NULL

Product (CopyOfUntitled)

  • ID (Key) — int — Primary key — NOT NULL
  • 이름 (Field2) — varchar
  • 가격 (Field3) — int
  • 카테고리 (Field4) — varchar
  • 재고 수량 (Field5) — int

Review (CopyOfCopyOfUntitled2)

  • ID (Key) — int — Primary key — NOT NULL
  • 평점 (Field4) — int
  • 리뷰 내용 (Field5) — varchar
  • User ID (Key2) — int — Foreign key → User.ID — NOT NULL
  • Product ID (Key3) — int — Foreign key → Product.ID — NOT NULL

User (Untitled)

  • ID (Key) — int — Primary key — NOT NULL
  • 이름 (Field2) — varchar
  • 이메일 (Field3) — varchar
  • 연락처 (Field4) — varchar
  • 주소 (Field5) — varchar