Assignment

Tables (6)

Activity (내역)

  • id (Key) — int — Primary key — NOT NULL
  • productId (상품번호) — int — Foreign key → Product.id — NOT NULL
  • userId (유저번호) — int — Foreign key → User.id — NOT NULL

Auction (경매기록)

  • id (Key) — int — Primary key — NOT NULL
  • productId (상품번호) — int — Foreign key → Product.id — NOT NULL
  • userId (유저번호) — int — Foreign key → User.id — NOT NULL
  • price (가격) — int

Product (상품)

  • id (Key) — int — Primary key — NOT NULL
  • name (상품명) — string
  • price (가격) — number
  • place (장소) — string
  • phone (폰번호) — string
  • status (상태) — enum

Review (별점)

  • id (Key) — int — Primary key — NOT NULL
  • productId (상품번호) — int — Foreign key → User.id — NOT NULL
  • userId (유저번호) — int — Foreign key → Product.id — NOT NULL
  • rating (별점) — int
  • content (내용) — string

User (유저)

  • id (Key) — int — Primary key — NOT NULL
  • userId (아이디) — string
  • password (비밀번호) — string
  • name (이름) — string
  • type (종류) — enum

Wish (찜)

  • id (Key) — int — Primary key — NOT NULL
  • productId (상품번호) — int — Foreign key → User.id — NOT NULL
  • userId (유저번호) — int — Foreign key → Product.id — NOT NULL