DDIP

Tables (5)

USER (user)

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (password) — string — NOT NULL
  • Field (name) — string — NOT NULL
  • Field (email) — string — NOT NULL
  • Field (tel) — string — NOT NULL
  • Field (certification) — ENUM — NOT NULL
  • Field (gender) — ENUM — NOT NULL
  • Field (address) — string
  • Field (createdAt) — date — NOT NULL
  • Field (updatedAt) — date — NOT NULL

Untitled (market)

  • Key (market_id) — int — Primary key — NOT NULL
  • Field (login_id) — string — NOT NULL
  • Field (password) — string — NOT NULL
  • Field (name) — string — NOT NULL
  • Field (tel_market) — string — NOT NULL
  • Field (location) — string — NOT NULL
  • Field (createdAt) — date — NOT NULL
  • Field (updatedAt) — date — NOT NULL

Untitled (product)

  • Key (product_id) — int — Primary key — NOT NULL
  • Key (market_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — string — NOT NULL
  • Field (manufacturer) — string — NOT NULL
  • Field (category) — ENUM — NOT NULL
  • Field (image) — json — NOT NULL
  • Field (price) — string — NOT NULL
  • Field (total_quantity) — int — NOT NULL
  • Field (description) — string — NOT NULL
  • Field (createdAt) — date — NOT NULL
  • Field (updatedAt) — date — NOT NULL

Untitled (ddip)

  • Key (ddip_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → USER.Key — NOT NULL
  • Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (market_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (ddip_num) — int — NOT NULL
  • Field (createdAt) — data — NOT NULL
  • Field (updatedAt) — data — NOT NULL
  • Field (quantity) — int — NOT NULL
  • Field (payment) — int — NOT NULL
  • Field (pay_successed) — bool — NOT NULL
  • Field (pay_date) — date — NOT NULL
  • Field (QR_verified) — bool — NOT NULL

Untitled (location)

  • Key (location_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → USER.Key — NOT NULL
  • Field (location) — string — NOT NULL
  • Field (createdAt) — date — NOT NULL
  • Field (updatedAt) — date — NOT NULL
  • Field (latitude) — float — NOT NULL
  • Field2 (longitude) — float — NOT NULL
  • Field (한글)