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