김희옥(20239383)

테이블 (7)

Comments

  • comment_id — INT
  • post_id — INT
  • member_id — INT
  • content — TEXT
  • created_at — TIMESTAMP

Members

  • member_id — INT
  • name — NCHAR(100)
  • phone — CHAR(20)
  • email — NCHAR(100)
  • address — NCHAR(100)

OrderDetails

  • order_detail_id — INT
  • order_id — INT
  • product_id — INT
  • quantity — INT

Orders

  • order_id — INT
  • order_date — DATETIME
  • shipping_address — NCHAR(100)

Products

  • product_id — INT
  • product_name — NCHAR(200)
  • stock_quantity — CHAR(200)
  • unit_price — CHAR(200)

ShippingAddresses

  • shipping_id — INT
  • order_id — INT
  • shipping_address — NCHAR(100)

Suppliers

  • supplier_id — INT
  • supplier_name — NCHAR(200)
  • phone — CHAR(20)
  • contact_person — NCHAR(100)
  • address — NCHAR(100)