week4

Tables (3)

COMMENT (댓글)

  • comment_id (Key) — Long — Primary key — NOT NULL
  • item_id (Key2) — Long — Foreign key → ITEM.item_id — NOT NULL
  • user_name (Key3) — Long — Foreign key → ITEM.user_name — NOT NULL
  • nickname (Field32) — String — Foreign key → ITEM.nickname
  • comment (Field) — String

ITEM (상품)

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

USER (유저)

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