example.sql

CREATE TABLE `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `total_price` DECIMAL(18,2) NOT NULL ,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,

  PRIMARY KEY (`id`)
);

CREATE TABLE `order_line_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `price` int(10),
  `discount` int(10),
  `amount` int(10),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,

  PRIMARY KEY (`id`)
);

CREATE TABLE `products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` DECIMAL(18,2) NOT NULL UNIQUE ,
  `total` int(10) NOT NULL
  `price` decimal(18,2) NOT NULL
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,

  PRIMARY KEY (`id`)
);

CREATE TABLE `product_stocks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` DECIMAL(18,2) NOT NULL UNIQUE ,
  `type` VARCHAR(20) NOT NULL,
  `amount` VARCHAR(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,

  PRIMARY KEY (`id`)
);