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