로컬앤라이프

테이블 (3)

Untitled (User)

  • Key (User_ID) — PK — 기본 키 — NOT NULL
  • Field (username) — CharField
  • Field (password) — CharField
  • Field (point) — IntegerField

Untitled (Product)

  • Key (product_id) — PK — 기본 키 — NOT NULL
  • Field (name) — CharField
  • Field (price) — IntegerField
  • Field (delivery_fee) — IntegerField

Untitled (PayHistory)

  • Key (payhistory_id) — PK — 기본 키 — NOT NULL
  • Key (User_ID) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Key (product_id) — PK — 외래 키 → Untitled.Key — NOT NULL
  • Field (balance) — Integer_Field
  • Field (create_date) — DateTimeField
  • Field (count) — Integer_Field
  • Field (total_price) — Integer_Field