mysql-schema.sql

CREATE TABLE `ecommerce`.`merchants` (
  `id` int,
  `country_code` int,
  `merchant_name` varchar(255),
  `created_at` varchar(255),
  `admin_id` int,
  PRIMARY KEY (`id`, `country_code`)
);

CREATE TABLE `ecommerce`.`order_items` (
  `order_id` int,
  `product_id` int,
  `quantity` int DEFAULT 1
);

CREATE TABLE `ecommerce`.`orders` (
  `id` int PRIMARY KEY,
  `user_id` int NOT NULL UNIQUE,
  `status` varchar(255),
  `created_at` varchar(255)
);

CREATE TABLE `ecommerce`.`products` (
  `id` int PRIMARY KEY,
  `name` varchar(255),
  `merchant_id` int NOT NULL,
  `price` int,
  `status` int,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE `ecommerce`.`product_tags` (
  `id` int PRIMARY KEY,
  `name` varchar(255)
);

CREATE TABLE `ecommerce`.`merchant_periods` (
  `id` int PRIMARY KEY,
  `merchant_id` int,
  `country_code` int,
  `start_date` timestamp,
  `end_date` timestamp
);

CREATE TABLE `users` (
  `id` INT,
  `full_name` varchar(255),
  `created_at` timestamp,
  `country_code` int
);

CREATE TABLE `countries` (
  `code` int PRIMARY KEY,
  `name` varchar(255),
  `continent_name` varchar(255)
);

CREATE TABLE `ecommerce`.`product_tags_products` (
  `product_tags_id` int,
  `products_id` int,
  PRIMARY KEY (`product_tags_id`, `products_id`)
);