gdg-backend
Tables (4)
Member (members)
- id (memebr_id) — Long — Primary key — NOT NULL
- loginId (member_login_id) — String
- password (member_pw) — String
- phoneNumber (member_phone) — String
- address (member_address) — String
- point (member_point) — int
Order (orders)
- orderId (order_id) — Long — Primary key — NOT NULL
- customer (member_id) — Member
- orderDate (order_date) — LocalDataTime
- customerNote (order_note) — String
- orderPrice (order_price) — Long
- customerAddress (customer_address) — String
- customerPhone (customer_phone) — String
OrderProduct (order_product)
- id (order_product_id) — Long — Primary key — NOT NULL
- productId (product_id) — Long — Foreign key → Product.productId — NOT NULL
- orderId (order_id) — Long — Foreign key → Order.orderId — NOT NULL
- quantity (order_quantity) — int
Product (products)
- productId (product_id) — Long — Primary key — NOT NULL
- productName (product_name) — String
- productPrice (product_price) — int
- productCategory (product_category) — String
- productDescription (product_description) — String
- productImageUrls (product_image_urls) — String