Doctrine Entity Generator

Generate Doctrine PHP entities and ORM XML mappings from SQL CREATE TABLE statements

SQL CREATE TABLE Statement

CREATE TABLE ecommerce.orders (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  customer_id BIGINT UNSIGNED NOT NULL,
  billing_address_id BIGINT UNSIGNED NOT NULL,
  shipping_address_id BIGINT UNSIGNED NOT NULL,
  payment_method_id INT UNSIGNED NOT NULL,
  status ENUM('pending','paid','shipped','delivered','cancelled','refunded') NOT NULL DEFAULT 'pending',
  order_number VARCHAR(32) NOT NULL,
  external_reference VARCHAR(64) DEFAULT NULL,
  currency CHAR(3) NOT NULL,
  is_gift TINYINT(1) NOT NULL DEFAULT 0,
  notes TEXT NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  UNIQUE KEY uniq_orders_order_number (order_number),
  KEY idx_orders_customer_created (customer_id, created_at),
  KEY idx_orders_payment_method (payment_method_id),
  FULLTEXT KEY ft_orders_notes (notes),
  CONSTRAINT fk_orders_customer FOREIGN KEY (customer_id) REFERENCES ecommerce.customers (id) ON UPDATE CASCADE ON DELETE RESTRICT,
  CONSTRAINT fk_orders_billing_address FOREIGN KEY (billing_address_id) REFERENCES ecommerce.addresses (id) ON UPDATE CASCADE ON DELETE RESTRICT,
  CONSTRAINT fk_orders_shipping_address FOREIGN KEY (shipping_address_id) REFERENCES ecommerce.addresses (id) ON UPDATE CASCADE ON DELETE RESTRICT,
  CONSTRAINT fk_orders_payment_method FOREIGN KEY (payment_method_id) REFERENCES ecommerce.payment_methods (id) ON UPDATE CASCADE ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;