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