week4 - 2022-07-22 11:27:54

Tables (3)

COMMENT (댓글)

  • comment_id (Key) — Long — Primary key — NOT NULL
  • item_id (Key2) — Long — Foreign key — NOT NULL
  • user_name (Key3) — Long — Foreign key — NOT NULL
  • comment (Field) — String

ITEM (상품)

  • item_id (Key) — Long — Primary key — NOT NULL
  • user_id (Key3) — Long — Foreign key — NOT NULL
  • image (Field) — File
  • item_name (Field2) — String
  • item_price (Field3) — Long
  • item_detail (Field4) — String

USER (유저)

  • user_id (Key) — Long — Primary key — NOT NULL
  • user_name (Field) — String
  • pw (Field2) — Strng
  • nickname (Field3) — String
  • city (Field4) — String