market

Tables (4)

CART (장바구니)

  • cart_item_id (Key) — Long — Primary key — NOT NULL
  • cart_id (Key3) — Long — Foreign key → CARTITEM.cart_id — NOT NULL
  • post_id (Key32) — Long — Foreign key → CARTITEM.post_id — NOT NULL
  • user_id (Key2) — Long — Foreign key → CARTITEM.user_id — NOT NULL
  • total_price (Field) — Int
  • deliveryfee (Field2) — Int

CARTITEM (장바구니 목록)

  • cart_id (Key) — Long — Primary key — NOT NULL
  • post_id (Key3) — Long — Foreign key → POST.post_id — NOT NULL
  • user_id (Key2) — Long — Foreign key → USER.user_id — NOT NULL
  • quatity (Field2) — Int

POST (게시글)

  • post_id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • image (Field2) — File
  • price (Field3) — Int
  • weight (Field4) — String
  • salesunit (Field5) — String

USER (유저)

  • user_id (Key) — Long — Primary key — NOT NULL
  • username (Field) — String
  • password (Field2) — String
  • nickname (Field3) — String