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