devcourse

Tables (6)

Untitled (User)

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (user_name) — varchar(100)
  • Field (password) — varchar(100)
  • Field (nickname) — varchar(100)
  • Field (email) — varchar(100)
  • Field (postalCode) — String
  • Field (role) — String
  • Field (apiKey) — String
  • Field (refreshToken) — String
  • Field (created_date) — datetime
  • Field (modified_date) — datetime

Untitled (product)

  • Key (product_id) — int — Primary key — NOT NULL
  • Field (product_name) — varchar(100)
  • Field (product_price) — int
  • Field (product_description) — varchar(100)
  • Field (product_stock) — int
  • Field (product_image) — TEXT
  • Field (created_date) — datetime
  • Field (modified_date) — datetime

Untitled (Order_item)

  • Key (order_item_id) — int — Primary key — NOT NULL
  • Key (order_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity) — int
  • Field (unit_price) — int
  • Field (total_price) — int
  • Field (created_date) — datetime
  • Field (modified_date) — datetime
  • Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Product_image)

  • Key (image_id) — int — Primary key — NOT NULL
  • Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — varchar
  • Field (created_date) — datetime
  • Field (modified_date) — datetime

Untitled (Wishlist)

  • Key (wishlist_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity) — int
  • Field (created_date) — datetime
  • Field (modified_date) — datetime
  • Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Order)

  • Key (order_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (order_count) — int
  • Field (total_price) — int
  • Field (payment_method) — varchar(30)
  • Field2 (payment_status) — varchar(10)
  • Field (address) — String
  • Field (created_date) — datetime
  • Field (modified_date) — datetime