db 설계
테이블 (3)
item
- title (Key) — char(100) — 기본 키 — NOT NULL
- description (Field) — text
- created (Field2) — date
- price (Field3) — decimal(12)
- image (Field4) — image
- owner (Field5) — foreignkey
user (Untitled)
- name (Key) — char(20) — 기본 키 — NOT NULL
- email (Field) — email
- phone (Field2) — phone
- private_key (Field3) — char(100)
- address (Field4) — char(100)
userItem
- user (Key) — foreignkey — 외래 키 → user.name — NOT NULL
- item (Key2) — foreignkey — 외래 키 → item.title — NOT NULL