ssafy2

Tables (7)

Untitled (product)

  • Key (id) — INTEAGER — Primary key — NOT NULL
  • Field (name) — VARCHAR(32)
  • Field (detail) — TEXT
  • Field (price) — INTEAGER

Untitled (order)

  • Key (id) — INTEAGER — Primary key — NOT NULL
  • Key (user_id) — VARCHAR(32) — Foreign key → user.Key — NOT NULL
  • Key (address_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
  • Field (date) — INTEAGER

Untitled (cart)

  • Key (id) — INTEAGER — Primary key — NOT NULL
  • Key (product_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — VARCHAR(32) — Foreign key → user.Key — NOT NULL
  • Field (count) — INTEAGER

Untitled (order_detail)

  • Key (id) — INTEAGER — Primary key — NOT NULL
  • Key (order_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
  • Field (count) — INTEAGER

Untitled (address)

  • Key (id) — INTEAGER — Primary key — NOT NULL
  • Key (user_id) — VARCHAR(32) — Foreign key → user.Key — NOT NULL
  • Field (addr) — VARCHAR(32)
  • Field (name) — VARCHAR(32)

Untitled (grade)

  • Key (id) — INTEAGER — Primary key — NOT NULL
  • Field (name) — VARCHAR(32)
  • Field (rate) — INTEAGER

user

  • Key (id) — VARCHAR(32) — Primary key — NOT NULL
  • Key (grade_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(32)
  • Field (pw) — VARCHAR(32)