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