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