CREATE TABLE `client` (
  `client_id` int unsigned NOT NULL AUTO_INCREMENT,
  `active_product` int unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `address` varchar(60) NOT NULL COMMENT 'company address: first line',
  `city` varchar(60) NOT NULL COMMENT 'company address: city',
  `state` varchar(60) NOT NULL COMMENT 'company address: state',
  `country` varchar(60) NOT NULL DEFAULT 'USA',
  `zip_code` varchar(60) NOT NULL COMMENT 'company address: zip_code',
  `rep_first_name` varchar(60) NOT NULL,
  `rep_last_name` varchar(60) NOT NULL,
  `rep_email` varchar(255) NOT NULL COMMENT 'The representative''s email address.',
  `rep_phone` varchar(25) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`client_id`),
  UNIQUE KEY `rep_email_UNIQUE` (`rep_email`),
  KEY `fk_product_idx` (`active_product`),
  CONSTRAINT `fk_client_product` FOREIGN KEY (`active_product`) REFERENCES `product` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

type Client {
        client_id: ID!
        active_product: Int!
        name: String!
        address: String!
        city: String!
        state: String!
        country: String!
        zip_code: String!
        rep_first_name: String!
        rep_last_name: String!
        rep_email: String!
        rep_phone: String!
        CONSTRAINT: Int
        }